Update links and SaveAs?

  • Thread starter Thread starter emge
  • Start date Start date
E

emge

Hello all.

I've been trying to figure something out and haven't been having much
luck. If anyone would like to provide me with some information, it
would be greatly appreciated.

I have a spreadsheet that has a bunch of links (data points being
pulled in off a server), one of which is updated constantly. I'd like
for the rest of the links to be updated and the file saved with the
current date and time when the constatly updated link reaches a certain
number. Is there any easy way to do this? Trying to figure this out
and learn how to program excel VB from the help files is not going
well. (If anyone has a suggestion for a good book on learning this
stuff, i'd appreciated that as well.)

Thanks for any responses.
Mike
 
These are the two books I learned (mostly) on:

Microsoft Excel97 Visual Basic Step by Step, Reed Jacobson
Microsoft Excel 2000 Power Programming with VBA, John Walkenbach

The second one is a good concise and inclusive reference book.
The first eases you into vba slowly.

With these two books and a lot of help from this newsgroup I've been able to
get good at generic vba programming.

The macro recorder is a good place to start when you are "lost at sea".

What you are trying to do sounds pretty basic.

HTH,
Shockley
 
Back
Top