You have to login in order to post a reply to this topic.

1 reply [Last post]
Fri, 12/11/2009 - 14:27
Excel macros?
PeterW
User offline. Last seen 2 years 4 days ago. Offline
Joined: 11/18/2009
Posts: 10

Is there a clever way to run Excel macros inside of WA without having to use the recorder - if I want to run jobs in non-interactive mode?

Top
  • Quote
Fri, 12/11/2009 - 17:09
#1
codex
codex's picture
User offline. Last seen 18 weeks 18 hours ago. Offline
Joined: 11/12/2009
Posts: 161
Re: Excel macros?

WinAutomation does not have a way of executing Excel macros in the background (non-interactive mode). This practically means that you have 2 options here:

- Either you will send keystrokes/mouse clicks

- Or you will have to use VBscript to execute the macro

I am not very experienced in executing Excel macros through VBscript, but if you find the code to do it with a script, I can create a job that will execute the code for you...

__________________

Error is not blindness, error is cowardice

__________________

Error is not blindness, error is cowardice

Top
  • reply
  • quote