Posted to microsoft.public.excel.programming

Steph[_6_] Steph[_6_] is offline

external usenet poster

Posts: 92

Update Links - no prompt

Hi. How can adjust the following line of code to update links?

Set WB = Workbooks.Open(Filename:=OneFile.path)

I tried Set WB = Workbooks.Open(Filename:=OneFile.path), Update Links:=1
but that didn't work.

Thanks!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
Update links without being prompt	George	Excel Discussion (Misc queries)	2	September 12th 07 12:38 AM
Startup Prompt to update Links	Werner Rohrmoser	Links and Linking in Excel	2	July 3rd 06 07:49 AM
Startup prompt - Update links	Horatio J. Bilge	Excel Discussion (Misc queries)	10	February 15th 06 06:48 AM
Prompt to update links	Werner Rohrmoser	Links and Linking in Excel	0	November 3rd 05 09:47 AM
Don't prompt to Update Links	Dwight[_3_]	Excel Programming	0	May 4th 04 10:02 PM

All times are GMT +1. The time now is 08:35 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us