10-24-2008, 10:17 AM
The excel macro works with several windows?
Use variables for window names.
Sub NewFormat(windowname)
...
Windows(windowname).Activate
Then call the sub from Quick Macros:
Macro
Excel Visual Basic also probably has a function that shows an input box. Then you would not need QM.
Use variables for window names.
Sub NewFormat(windowname)
...
Windows(windowname).Activate
Then call the sub from Quick Macros:
Macro
str s
inp- s "Excel window name"
ExcelSheet es.Init
es.ws.Application.Run("NewFormat" s)
Excel Visual Basic also probably has a function that shows an input box. Then you would not need QM.