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 - 26 Jun 2007 14:50 GMT
> Hi,
>
[quoted text clipped - 18 lines]
> 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.