copying linked spread sheets to disk...

FrankRoman

New Member
Joined
Nov 6, 2002
Messages
9
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
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

DonkeyOte

MrExcel MVP
Joined
Sep 6, 2002
Messages
9,123
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 Auto_Open (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 Auto_Open 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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,694
Messages
5,597,571
Members
414,157
Latest member
MrBJBones

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top