Hi!
how can I automatically let Excel update Links when I open my workbook (With VBA)? I always have to say "YES".
Ciao,
Jürgen
Hi!
how can I automatically let Excel update Links when I open my workbook (With VBA)? I always have to say "YES".
Ciao,
Jürgen
Hi,
where do I have to place this code? Into ThisWorkbook? Info: MY Exel-file is used on a network.
Ciao,
Jürgen
I got the impression from your post that the workbook was being opened using VBA, i.e. from another workbook...
If so, then my code can be placed in a normal module in the workbook that opens the workbook that has the links.
If this is not the case, post back.
Will
Hi,
sorry I didn't make myself clear enough.
The Workbook is opened normally with the doubleclick on the Desktop-icon. If you have other questions, please ask.
Jürgen
OK, well this makes it more complicated as the update links warning fires before the WorkBook_Open event, so you'd have no luck placing any code there....
Anyway, I did see a solution (more of a workaround really) posted by Anne and Dave early on...
Here's the whole post
http://www.ozgrid.com/forum/viewthread.php?tid=474
Hope it helps,
Will
PS.... you can also do this if the code method seems too messy for you
In the Workbook housing the links go to Tools>Options>Edit and uncheck "Ask to update automatic links"
The links should then update with no warning message... note that this will be the default so you will never get the message or be asked whilst this is unchecked.
Will
Hi,
ok, thanks for your help!
Jürgen
Hi
your uncheck-method only works on my own computer, but the excel-file has to work on a network.
So I had a look upon the thread you gave me. But I don't comprehend the solution the "Super Admin" proposed... can you explain it in a better way?
E.g. I don't know where I have to put which code sample, if I have to make a new Excel file,...
Here is my real file position which should be opened with automatic link update:
V:\_Projects\Target_validation_DB\_Overview\grand_overview.xls
Thanks for your help,
Jürgen.
Don’t have an account yet? Register yourself now and be a part of our community!