I need a simple macro but im a noob.
 

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

I need a simple macro but im a noob.
 

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.

--
Regards,
Tom Ogilvy


"flyboy0204" wrote in message
...
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

I need a simple macro but im a noob.
 

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.

"Tom Ogilvy" wrote:

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.

--
Regards,
Tom Ogilvy


"flyboy0204" wrote in message
...
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

I need a simple macro but im a noob.
 

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


"Tom Ogilvy" wrote in message
...
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.

--
Regards,
Tom Ogilvy


"flyboy0204" wrote in message
...
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