Bypassing Excel automatic links

Nalco
10-22-2004, 08:15 AM
I am reading Excel information in a VB.Net form, and it work wells. The problem I have is the Excel file has a link to another file and I get a message if I want to update the link or not. I do not, but I need help in what code to use to bypass the link. To select the no button. My program is meant to run automatically and right now I have to click the NO on the mesagebox.

herilane
10-22-2004, 08:20 AM
Workbooks.Open("myfile.xls", UpdateLinks:=False)

Nalco
10-22-2004, 09:49 AM
Thank you much very for your help, this solved my problem so I can go on to the next one. :)

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum