automate excel

[jayjay60]

is anybody could explai me how i could create an automation which could simply open a specific workbook, a specific worksheet, update the data(using shift+F9) and close it. I would like to create this automation so that i could have a button in my dlg box app, when pushed it will update the data i need for my calculations???

thanks in advance

jayjay

 

[StukA]

There's good example code on the MSDN web site...I don't have the link at hand, but I looked it up once before. The sample code does almost exactly what you want - open the spreadsheet, update the data, then close.