Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / June 2007

Tip: Looking for answers? Try searching our database.

execute batch file upon save

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Titus van Houwelingen - 25 Jun 2007 01:13 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.