LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Can't copy and move a worksheet

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Move/Copy or Copy/Insert worksheet? kjk Excel Discussion (Misc queries) 0 December 15th 06 02:40 PM
Copy/Move Worksheet from one Workbook to another Anney Excel Discussion (Misc queries) 3 December 15th 06 12:42 PM
Unable to Insert Worksheet/Move and copy worksheet Excel 2003 lukerush Excel Worksheet Functions 2 September 7th 06 05:05 PM
Excel 2007 copy/move worksheet to another workbook Hoekie@work Excel Discussion (Misc queries) 0 June 21st 06 07:27 AM
How can user move in locked worksheet but not copy cell contents? PAT Excel Worksheet Functions 0 April 25th 06 08:40 PM


All times are GMT +1. The time now is 01:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"