Opening an Excel Sheet everytime a document is saved in a folder

[ericpny2]

Is there anyway to have a specific excel sheet open up everytime a Word document is saved in a specific folder?

 

[ericpny2]

or if it cant open the file, have the file at least update by entering the name of the file in a certain cell?

 

[ericpny2]

Any ideas??

 

[Hermanito]

a specific Word document, or any Word document saved in that folder?

What are you trying to achieve?

 

[ericpny2]

<P>any word document saved in that folder.  So everytime a report is written and sent out, i need to update an excel log which shows all of the reports. As a reminder to log it, it would be helpful to have the excel sheet open every time a word document is saved in that folder.  We have several different people who are saving these documents so sometimes people forget to log the report, and if that happens it can cause some problems with the numbering in the log</P>
<P> </P>
<P>Please let me know if there is a efficient solution to this</P>

 

[Hermanito]

It can be done, but it's not easy.

I'm not sure if you're familiar with events, but what you need is to subscribe to filesystem events (file_created) in a specific directory. Unfortunately, these events are not exposed in Excel or Word. Maybe it's possible with Windows API calls, but I doubt it.

In .NET you can easily do this with a FileSystemWatcher object, but it would mean you need to create a .NET tool that runs all the time, for all users, not a trivial task.

If only it had been a specific Word document, you could have written code in the Save event there...

A specific Word add-in might be able to trap all save actions for all documents, and respond when files are saved to that particular directory, but again, this is not a trivial thing to create...