Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update linked cells from another workbook with a Macro

Status
Not open for further replies.
kitackers

kitackers

MIS
Apr 16, 2004
33
GB
I've trawled through the internet and cannot find anything on this at all.

All I'm after is a macro that will update linked cells once fired, rather thatn having to close a workbook, then open it again, updating the links when prompted!

Anyone got anything?
 
Sort by date Sort by votes


Hi,

Check out the UpdateLink Method in VBA Help.

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Question
CTRL + BREAK from second macro button
Replies
5
Views
316
strongm
strongm
remeng
  • Locked
  • Helpful tip
Microsoft Office 365 Word Macro Causing a Project is unviewable error
Replies
1
Views
273
dhookom
dhookom
feipezi
  • Locked
  • Question
How to make a recorded Excel macro (convert a text file to a Workbook) more efficient?
Replies
11
Views
310
SkipVought
S
remeng
  • Locked
  • Question
Getting results from a dynamic dimension array
Replies
2
Views
258
Andrzejek
Andrzejek
aldi07
  • Locked
  • Question
update a front-end databases with a new release using vba
Replies
2
Views
134
aldi07
aldi07

Part and Inventory Search

Sponsor

Back
Top