execute batch file upon save

[Titus van Houwelingen]

Hi,

I have searched the web and newsgroups (probably with the wrong expressions)
and cannot find the solution.

I have an xls spreadsheet (Office 2003). I did 'save as' html once so from
now on every time I save it also 'publishes' to a local .htm file.

After this 'publication' I would like to run a batchfile which uses the .htm
file as input.

I have little experience with VBA. I tried to look for an event like
'AfterSave' or something like that. I could only come up with a BeforeSave
event, which is to eraly.

Can anyone tell me how I can run a batchfile which uses the automatically
created .htm file, after saving an .xls file?


Thanks for any help.

Regards,
Titus

 

[Pegasus]

Hi,

I have searched the web and newsgroups (probably with the wrong
expressions) and cannot find the solution.

I have an xls spreadsheet (Office 2003). I did 'save as' html once so from
now on every time I save it also 'publishes' to a local .htm file.

After this 'publication' I would like to run a batchfile which uses the
.htm file as input.

I have little experience with VBA. I tried to look for an event like
'AfterSave' or something like that. I could only come up with a BeforeSave
event, which is to eraly.

Can anyone tell me how I can run a batchfile which uses the automatically
created .htm file, after saving an .xls file?


Thanks for any help.

Regards,
Titus

Instead of using the standard Save function, you could write
yourself a macro that does two things:
1. It saves your spreadsheet.
2. It shells out to launch a command processor which invokes your batch
file.