VBA for Excel 97 - Macro for Linking - TechRepublic
General discussion
October 10, 2000 at 02:44 AM
rvs

VBA for Excel 97 – Macro for Linking

by rvs . Updated 25 years, 8 months ago

I have created several order forms that my company uses for our salesreps. They all link to an account database for autofill.
Everytime a rep opens the form, the dialog box “To Update all links, click yes, To keep existing info, click no”, appears. How can I write a macro that runs when the form opens, and automatically says no, without user seeing?
I thought I had it with the line “open filename” updatelinks=false. That works but must be ran from another workbook.
I have tried the above line Using Private Sub Workbook_Open(), macro seems to ignore the line and ask the question anyway.

Remember, It needs to open without asking or updating links.
Thanks.

This discussion is locked

All Comments