Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cannot Add New Workbook
Hi All,
I have a user with Excel 97 and Windows XP. The VBA code was working fine until the PC was upgraded to XP. I first had a problem in trying to copy a sheet to a new workbook. I was using the line Sheets("Quote").Copy This started to fail. Also, I could no longer copy the sheet manually. Having searched this forum I have tried all the suggestions about the name of the sheet object in the VBE and that all looks fine. The workbook has 10 sheets, some of which are hidden, although the sheet I am trying to copy is not. I abandoned the copy sheet idea and decided to copy the cells , create a new book and paste the data into it. This led to a problem on this line Workbooks.Add This caused the error message "Method 'Add' of Object 'Workbooks' Failed". Also, once this has occured, I can no longer add a new workbook manually without exiting from Excel and restarting. I know the real solution is probably going to be "Upgrade to Excel XP" but that is not an option at the moment. By the way, this problem is not restricted to one PC. It seems to happen on any PC with the combination of Excel 97 & Windows XP. Any idea's? Regards Glyn Baker |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cannot Add New Workbook
Please ignore this post. I have discovered that there are issues with access
permissions which I have yet to figure out. Regards Glyn Baker "Glyn Baker" wrote in message om... Hi All, I have a user with Excel 97 and Windows XP. The VBA code was working fine until the PC was upgraded to XP. I first had a problem in trying to copy a sheet to a new workbook. I was using the line Sheets("Quote").Copy This started to fail. Also, I could no longer copy the sheet manually. Having searched this forum I have tried all the suggestions about the name of the sheet object in the VBE and that all looks fine. The workbook has 10 sheets, some of which are hidden, although the sheet I am trying to copy is not. I abandoned the copy sheet idea and decided to copy the cells , create a new book and paste the data into it. This led to a problem on this line Workbooks.Add This caused the error message "Method 'Add' of Object 'Workbooks' Failed". Also, once this has occured, I can no longer add a new workbook manually without exiting from Excel and restarting. I know the real solution is probably going to be "Upgrade to Excel XP" but that is not an option at the moment. By the way, this problem is not restricted to one PC. It seems to happen on any PC with the combination of Excel 97 & Windows XP. Any idea's? Regards Glyn Baker |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding a chart to large workbook brings workbook activity to a hal | Excel Discussion (Misc queries) | |||
Macro to copy an image (or picture) from one workbook to a new sheetin another workbook | Excel Worksheet Functions | |||
Select sheet tabs in workbook & save to separate workbook files | Excel Worksheet Functions | |||
Open a password protected excel workbook from second workbook to fetch data using dynamic connection | Excel Programming | |||
What commands do you use to name a workbook, save a workbook,open a workbook | Excel Programming |