Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Problem with Excel
#6
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
Code:
Copy      Help
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.


Messages In This Thread

Forum Jump:


Users browsing this thread: 1 Guest(s)