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 SkipVought 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
0
0
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
159
strongm
strongm
feipezi
  • Locked
  • Question
How to make a recorded Excel macro (convert a text file to a Workbook) more efficient?
Replies
11
Views
159
SkipVought
S
remeng
  • Locked
  • Question
Getting results from a dynamic dimension array
Replies
2
Views
134
Andrzejek
Andrzejek
aldi07
  • Locked
  • Question
update a front-end databases with a new release using vba
Replies
2
Views
81
aldi07
aldi07
remeng
  • Locked
  • Question
If obsolete - deactivate all but one macro
Replies
6
Views
119
mintjulep
M

Part and Inventory Search

Sponsor

Back
Top