Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheets.Copy Error in Excel 2003 - Is this a registry Problem?
Good afternoon,
I've searched all available resources, you're my last hope! For the first time ever, the sheets.copy command in the vbe throws a large error. Firstly it says Microsoft Visual Basic - File not Found C: \Documents.....tmp and then throws a Run Time 1004 "Method Copy of object Sheets Failed". Is this something to do with registry access or temporary file (which I fear has been removed)? If so, could anyone please explain what needs to be put right? If not, any ideas as to what could be the problem would be greatly appreciated and I'll buy you a pint. . . Thanks very much in advance Jon Teale |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheets.Copy Error in Excel 2003 - Is this a registry Problem?
I don't think its the sheets.copy that is failing, but something earlier in
the code that is really causing the problem. I would check to see if there is any ON ERROR statements in the code and comment them out to help find the problem. Run the code without the ON ERRROR statements and see if the Error occurs earlier in the program. "HamishMcT" wrote: Good afternoon, I've searched all available resources, you're my last hope! For the first time ever, the sheets.copy command in the vbe throws a large error. Firstly it says Microsoft Visual Basic - File not Found C: \Documents.....tmp and then throws a Run Time 1004 "Method Copy of object Sheets Failed". Is this something to do with registry access or temporary file (which I fear has been removed)? If so, could anyone please explain what needs to be put right? If not, any ideas as to what could be the problem would be greatly appreciated and I'll buy you a pint. . . Thanks very much in advance Jon Teale |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheets.Copy Error in Excel 2003 - Is this a registry Problem?
Thanks for the advice Joel, but even if I write the routine
sub copy_sheets() sheets.copy end sub I get the errors. Any other dieas? Thanks very much JT On 8 Aug, 17:24, Joel wrote: I don't think its the sheets.copy that is failing, but something earlier in the code that is really causing the problem. I would check to see if there is any ON ERROR statements in the code and comment them out to help find the problem. Run the code without the ON ERRROR statements and see if the Error occurs earlier in the program. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheets.Copy Error in Excel 2003 - Is this a registry Problem?
The code ran fine for me. You are right that you need to start looking at
windows. Make sure you are running in a directory that you have full permission to read and write. When you to a sheet.copy and don't use the after or before it creattes a new workbook. If you don't have perrmission then that could be your source of the problem "HamishMcT" wrote: Thanks for the advice Joel, but even if I write the routine sub copy_sheets() sheets.copy end sub I get the errors. Any other dieas? Thanks very much JT On 8 Aug, 17:24, Joel wrote: I don't think its the sheets.copy that is failing, but something earlier in the code that is really causing the problem. I would check to see if there is any ON ERROR statements in the code and comment them out to help find the problem. Run the code without the ON ERRROR statements and see if the Error occurs earlier in the program. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotal fix for excel 2003 updated registry-now another problem | Excel Discussion (Misc queries) | |||
Copy and paste problem Excel 2003 to Word 2003 | Excel Discussion (Misc queries) | |||
Enable/Disable Drag and Drop in Excel 2003 via Registry | Excel Discussion (Misc queries) | |||
Unable to find registry key for MS-Excel 2003 setting | Setting up and Configuration of Excel | |||
Excel VBA- Error Accessing the system registry | Excel Programming |