Open excel and refresh data from vb executable

i have a excel spreadsheet that i want to open and refresh data every day. I want to code this in VB so i can run a executable to do that for me. Please help? I am new to VB and have no ideas how to start this?

Thanks,
Rakshan

Ok, I have written a Vb program that refreshes data in Excel, everytime data is updated i get a prompt (windows dialog box) to confirm update. How can i handle that in VB code. I will have to manually click on OK button before it goes any further. I think i need some kind of dialog properties visibility option turned off.


Thanks,
Rakshan

Well, it depends on how you are updating. If you are using OLE Automation, you should simply be able to insert this into your code before updating it:

Application.DisplayAlerts = False

Hope this helps.

Hi
could any one of you tell me how to write a vb program that refreshes data in excel file without opening the excel file manually?

Rakshan
I think we both are having similar requirement. if you have already solved the issue, could you give me some hints?

Thanks & Regards
Sri