Rabu, 13 April 2016

Re: [ExcelVBA] Stop file link updation box

 

Use 

Application.AskToUpdateLinks = False

Derek Turner
England +++




From: "Paul Schreiner schreiner_paul@att.net [ExcelVBA]" <ExcelVBA@yahoogroups.com>
To: "ExcelVBA@yahoogroups.com" <ExcelVBA@yahoogroups.com>
Sent: Monday, 11 April 2016, 17:27
Subject: Re: [ExcelVBA] Stop file link updation box

 
I've not tried this (and have no opportunity to test it)
but you could try adding:

Application.DisplayAlerts = False

to a Workbook_open (or other) macro.

Paul
-----------------------------------------
"Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can." - John Wesley
-----------------------------------------


On Monday, April 11, 2016 9:09 AM, "Tayyab sheikhtayyab@yahoo.com [ExcelVBA]" <ExcelVBA@yahoogroups.com> wrote:


 
Dear All
I have a set files that linked outside another workbook. When the marco run excel ask to update the link file. how to ignore that message and run complete macro.

thanks

Regards
Tayyab




__._,_.___

Posted by: Derek Turner <g4swy@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (4)
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

.

__,_._,___

Tidak ada komentar:

Poskan Komentar