I need a simple macro but im a noob.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

flyboy0204 - 20 Jan 2006 22:09 GMT

I need what I think would be a simple macro to an advanced user. It needs to
start when the book is opened and update all external links (paste specials)
every 20 secconds. I have no idea what commands are needed to do this and
have no idea where to look for information to make it myself. Im using excel
2003. Please help.

Thank you,
Flyboy

Reply to this Message

Tom Ogilvy - 20 Jan 2006 23:09 GMT

See Chip Pearson's page on Application.OnTime

http://www.cpearson.com/excel/ontime.htm

from help on UpdateLink:

This example updates all links in the active workbook.

ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources

I don't see what role pastespecial has to play. Perhaps you could use the
macro recorder to figure out that code.

Signature

Regards,
Tom Ogilvy

> I need what I think would be a simple macro to an advanced user. It needs to
> start when the book is opened and update all external links (paste specials)
[quoted text clipped - 4 lines]
> Thank you,
> Flyboy

Reply to this Message

flyboy0204 - 20 Jan 2006 23:18 GMT

I just included the little paste special line so you would know how I created
my external links. I was not sure if the way I made the external links made
a difference.

Thank you for the help Tom.

> See Chip Pearson's page on Application.OnTime
>
[quoted text clipped - 20 lines]
> > Thank you,
> > Flyboy

Reply to this Message

scooper - 21 Jan 2006 04:20 GMT

The problem with paste special occurs because you have used the Update.Links
method in the sheet.activate event.
Had same problem last week. I took Update.Link out of the macro and it
returned to normal.
scooper

> See Chip Pearson's page on Application.OnTime
>
[quoted text clipped - 22 lines]
>> Thank you,
>> Flyboy

Reply to this Message