Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 32
Default Update link answer = no

Thanks Adriano, I've also found myself.

"Vergel Adriano" wrote:

You can set the UpdateLinks parameter to False when you open the workbook..

Application.Workbooks.Open Filename:="D:\TEMP\sample.xls", UpdateLinks:=False


--
Hope that helps.

Vergel Adriano


"dspilberg" wrote:

Hi, I just wanted to automatically say no to a msgbox asking if I want to
update the links in a workbook opened by a macro.
I cannot Select Edit--Link, because the workbook opened is changed by
someone I don't know and my macro have just to treat his/her file.

Thanks!
Daniel (Brazil)

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 link value Partly Void[_2_] Excel Worksheet Functions 0 August 13th 08 08:15 AM
Update Excel cell in formula not refreshing answer cell Johnny Excel Discussion (Misc queries) 2 June 21st 07 05:49 AM
Don't update link Pedro Mestre Excel Discussion (Misc queries) 2 January 3rd 07 11:07 AM
update link Link Updates Excel Worksheet Functions 1 September 5th 06 05:55 PM
update a link to a CSV T Excel Discussion (Misc queries) 2 August 7th 05 09:00 PM


All times are GMT +1. The time now is 04:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"