• Options
• Login
• Register
• Desktop Style
• Accelerated Mobile Pages Theme

Excel macros

• Index

  • Jean Lalonde Support Forum
  • QUICK ACCESS POPUP FORUM
  • QAP SUPPORT
  • Excel macros
• Excel macros

• Excel macros

  nitin > 2021-08-05 00:49

  Hi,
  
  Is it possible to run excel macros from QAP? It would be great if I can have a menu with all my excel macros  
  
  Thanks!

• RE: Excel macros

  Jean Lalonde > 2021-08-05 11:34

  Hi Nitin,
  
  Welcome to the forum!
  
  I see various ways to do it. These two solutions can be found on this page:
  https://stackoverflow.com/questions/2050...batch-file
  
  In the first response (using a VBScript file), you would create an Application favorite in QAP with the location of the VBS script in the "Application (path and file name)" field. You would need one VBS script for each macro.
  
  In the second example, you could run only one macro for a given workbook by making this macro auto-executable (with the Workbook_Open event). In QAP, you would create a Document favorite in QAP and enter the path to this workbook.
  
  Let us know how it works. There may be other interesting approaches.
  
  Jean

• RE: Excel macros

  nitin > 2021-08-06 05:44

  Thanks Jean for the wonderful app!
  
  I got it working with the below code:
  
  

  Code:

  Option Explicit
Dim xlApp, xlBook
Set xlApp = Getobject(,"Excel.Application")
xlapp.Run "PERSONAL.XLSB!CopySheetToNewWorkbook"
WScript.Quit

  
  I wanted to run macros from my Personal Macro Workbook on any active excel file.
• Next Oldest Next Newest