command line function with excel

[ninash]

I am designing a database that has a linked table (Excel Spreadsheet). The data in this table changes all the time and a macro has been placed in it to update the information.
My problem is this....
I need to run the macro in the spreadsheet when the database opened to ensure the correct information is used.

If there is anyone that knows how to do this please please help

 

[SkipVought]

Hi,
There are all kinds of events that are tied to the Workbook Object and Sheet Objects.
In the VBA Project browser, click on the workbook object and select Workbbok as the object (as opposed to General), and then select the Open event.
In the workbook_Open event, make a call to the procedure(s) you want to run when the workbook containing the database opens.
Skip,
metzgsk@voughtaircraft.com

 

[ninash]

thanks Skip
I will give it a try
X-)