Excel Links

  • Thread starter Thread starter Riggs
  • Start date Start date
R

Riggs

I have an Excel WorkBook called EOH.xls that asks if I
want to Update the Links upon its opening. I am opening
this WorkBook through a VB application that I wrote but
cannot figure out how to open the WorkBook while
automatcially choosing 'NO' to Update the Links message.

I can write code in another Excel WorkBook to open the
EOH.xls WorkBook or by turning off the 'Ask to update
links', but I would like to programmatically do so in my
existing VB application. Is this possible and if so, how?

Any suggestions?
 
see one guess to your first post.
I have an Excel WorkBook called EOH.xls that asks if I
want to Update the Links upon its opening. I am opening
this WorkBook through a VB application that I wrote but
cannot figure out how to open the WorkBook while
automatcially choosing 'NO' to Update the Links message.

I can write code in another Excel WorkBook to open the
EOH.xls WorkBook or by turning off the 'Ask to update
links', but I would like to programmatically do so in my
existing VB application. Is this possible and if so, how?

Any suggestions?
Click to expand...
 
Back
Top