copying linked spread sheets to disk...

[FrankRoman]

Hello,
I have some linked Progress Reports on my hard drive that I need to send to my client so they can load on their system.

I copied the entire folder to disk (contains all the linked workbooks), but when I access the files, update them, and try to save it tells me the original file is read only!

I'm sure there's a simple fix, just haven't arrived at that knowledge plane yet!

Thanks for all help! Frank Roman

 

[DonkeyOte]

Frank, don't know the exact answer to this but you could put confer with your client and get them to designate a folder/filename for this workbook - then insert an Autpen (with prompt) and get it to Save_As thus no longer being read only...

e.g.

Sub AUTO_OPEN()

YN = MsgBox("Do You Wish to Run the Autpen Macro and Save File to Alternate Location?",vbyesno,"SAVE TO NEW LOCATION?")

IF YN = VBNO THEN EXIT SUB

ACTIVEWORKBOOK.SAVEAS("C:MREXCELFRANK.XLS")

END SUB


There are numerous components of SaveAs code which you should look at, you may find some of them may be useful for you in this instance.

Hope this helps if you've not sorted this already.

For others reading this - LOOK AT ZERO REPLIES DAILY - people get forgotten whilst everyone answers the same question.