Posted to microsoft.public.excel.programming

Gautam[_3_] Gautam[_3_] is offline

external usenet poster

Posts: 10

Statement not to update the file while opening through Macro

I am opening various workbooks one after the other inorder to get some
information in it, through a macro. Now everytime the workbook is
opened, it asks for updating of links and stops there. I need a
statement which automatically replys the excel not to update the
files, in the existing macro.

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
can I update an excel file without opening it?	dordy52	Excel Discussion (Misc queries)	1	October 19th 09 10:34 PM
Update data wihout opening the file?	Vellarian	Excel Programming	1	March 3rd 06 09:21 AM
Update data without opening file?	Vellarian	Excel Discussion (Misc queries)	1	March 3rd 06 08:43 AM
automatically update links without opening file	sir Lancelot	Excel Worksheet Functions	0	July 29th 05 04:05 AM
Automate open file, update links, run macro, close and save file	Geoff[_7_]	Excel Programming	2	August 26th 03 10:13 PM

All times are GMT +1. The time now is 02:32 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us