Links or macros?

  • Thread starter Thread starter Bonnie
  • Start date Start date
B

Bonnie

What is the best way to save data from one identical
worksheet to another on a server, without having to
remember to manually update? Any help would be appreciated.

Thanks,

Bonnie
 
Bonnie,

Links to other unopened workbooks in Excel are
exteeeeeeeeeeeeeeemly slow.
Unfortunately, whetever Lotus did to make their links update
like lightning, the folks at MS couldn't duplicate.

My suggestion would be to save the sheet on the server
via a macro.

Post back with more specifics and someone will surely
help you out with this.

John
 
Thanks for the reply. I am not sure how to make a macro
with these commands. Would you suggest on thatI could use
to update one worksheets new info to another? Please type
the command for me.

Certainly appreciate this.

Bonnie
 
Bonnie,

It may be more than a couple of lines of code.
What's the name of the workbook that you're trying to
update?
What's the drive and path?
Where's your "copy from" range?
Where's your "copy to" range?

I can give you some code if you post back with specifics.
Basically, you have to find and open that workbook on the server,
copy and paste to it and then save and close it.

If it *IS* only a coule of cells, linking them might be better.
If it's more than that, the open, copy, paste,save,close
would surely be faster.

John
 
What is the reason for the copy...........if it's just a matter of a backup,
your MIS department should be able to arrange for Archive backups as often
as you need..........

Vaya con Dios,
Chuck, CABGx3
 
Back
Top