Click to See Complete Forum and Search --> : visual basic and excel


msawaya
April 17th, 2001, 11:31 AM
I need to be able to open excel and automatically save. I have created a macro to save, but then how do I go about calling the macro. The whole process needs to be automated. I will be using task-scheduler to call the excel document, but I just don't know how to automatically save the document when open. Any ideas? I also can not use the add-in save feature that excel offers...

Iouri
April 17th, 2001, 12:06 PM
You can execute a macro by sending keys

'AppActivate "Microsoft Excel"
SendKeys "^(+G)" 'Control-Shift-G ->execute macro


Iouri Boutchkine
iouri@hotsheet.com