Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have an intermittent problem with Excel 2003. I am manipulating files and
make a copy of the orginal worksheet before I start working on it. Sometimes when I try to move and copy a worksheet I get the message Path/File access error: \VB1A.tmp. The text after VB but before ".tmp" changes each time this error occurs. I encounter this when I try to move and copy a sheet by right-clicking on the sheet tab, as well as when I run a macro with the following statement: ActiveSheet CopyAfter:=Sheets(ShtName) This is only an intermittent problem. It is not cleared by closing Excel or restarting my computer. I have tried the following: Cleaned out all temp folders, including Internet Explorer Gone into Add/Remove programs and run the Repair for Office Uninstalled and reinstalled Excel Defragged my hard drive Copy the data from the workbook and paste it into a new workbook. My companys tech support cant offer any other ideas. I hope someone in this community might be able to help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Move/Copy or Copy/Insert worksheet? | Excel Discussion (Misc queries) | |||
Copy/Move Worksheet from one Workbook to another | Excel Discussion (Misc queries) | |||
Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
Excel 2007 copy/move worksheet to another workbook | Excel Discussion (Misc queries) | |||
How can user move in locked worksheet but not copy cell contents? | Excel Worksheet Functions |