Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros - Saving over protected worksheet using a macro.
I need to create a macro to save an excel file in a separate directory.
However I am not that familiar with creating macros (i'm much better at making changes to an existing macro). The problem that I am running into is that the file that is saved in the other directory is a protected excel spreadsheet, so when I run my macro it gives me an error. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros - Saving over protected worksheet using a macro.
Please post your code and specify where the error is, it helps to diagnos the
problem. Otherwise we are just guessing what you need. -- Cheers, Ryan "Dolores" wrote: I need to create a macro to save an excel file in a separate directory. However I am not that familiar with creating macros (i'm much better at making changes to an existing macro). The problem that I am running into is that the file that is saved in the other directory is a protected excel spreadsheet, so when I run my macro it gives me an error. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros - Saving over protected worksheet using a macro.
Actually,
I used the macro record tool that comes with excel, I am better an modifying macros than I am at creating them. So the only part of the code that was written was the save as (see below). Sub saveas() ' ' saveas Macro ' Macro recorded 9/30/2008 by dgomez ' ChDir "F:\Illinois-Indy Sales" ActiveWorkbook.saveas Filename:="F:\Illinois-Indy Sales\Bid Register.xls", _ FileFormat:=xlNormal, Password:="", WriteResPassword:="", _ ReadOnlyRecommended:=False, CreateBackup:=False End Sub when I run the macro I get the following error "Cannot access read-only document "Bid Register.xls" "RyanH" wrote: Please post your code and specify where the error is, it helps to diagnos the problem. Otherwise we are just guessing what you need. -- Cheers, Ryan "Dolores" wrote: I need to create a macro to save an excel file in a separate directory. However I am not that familiar with creating macros (i'm much better at making changes to an existing macro). The problem that I am running into is that the file that is saved in the other directory is a protected excel spreadsheet, so when I run my macro it gives me an error. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros on Protected worksheet | Excel Discussion (Misc queries) | |||
Run macros on protected worksheet | Excel Worksheet Functions | |||
Run macros on protected worksheet | Excel Worksheet Functions | |||
allow macros in protected worksheet | Excel Worksheet Functions | |||
Is is possible to run macros on a protected worksheet | Excel Worksheet Functions |