I cannot simply right click on a sheet and copy the sheet over into a new
workbook. A window box msg title Microst Visual Basic comes up on screen
which says the following:path\file access erro: '\B1452.temp', am using
Microsoft XP and excel version 2002 (10.6501.6735),

Make sure both your new workbook and your original workbook are open. Then
in your original workbook, right-click on the tab of the sheet to be moved &
select Move or Copy. In the drop-down list, select the name of your new
workbook (it should be there if it is open, or select "blank workbook" to
start a new workbook). Check the "Create a Copy" checkbox, then click OK.
Your worksheet should be copied into your new workbook.

Hope this helps!

"Pegasus" wrote:

I cannot simply right click on a sheet and copy the sheet over into a new
workbook. A window box msg title Microst Visual Basic comes up on screen
which says the following:path\file access erro: '\B1452.temp', am using
Microsoft XP and excel version 2002 (10.6501.6735),

Thanks.

"TR" wrote:

Make sure both your new workbook and your original workbook are open. Then
in your original workbook, right-click on the tab of the sheet to be moved &
select Move or Copy. In the drop-down list, select the name of your new
workbook (it should be there if it is open, or select "blank workbook" to
start a new workbook). Check the "Create a Copy" checkbox, then click OK.
Your worksheet should be copied into your new workbook.

Hope this helps!

"Pegasus" wrote:

I cannot simply right click on a sheet and copy the sheet over into a new
workbook. A window box msg title Microst Visual Basic comes up on screen
which says the following:path\file access erro: '\B1452.temp', am using
Microsoft XP and excel version 2002 (10.6501.6735),

this is what we're doing, and then the error message comes up

"TR" wrote:

Make sure both your new workbook and your original workbook are open. Then
in your original workbook, right-click on the tab of the sheet to be moved &
select Move or Copy. In the drop-down list, select the name of your new
workbook (it should be there if it is open, or select "blank workbook" to
start a new workbook). Check the "Create a Copy" checkbox, then click OK.
Your worksheet should be copied into your new workbook.

Hope this helps!

"Pegasus" wrote:

I cannot simply right click on a sheet and copy the sheet over into a new
workbook. A window box msg title Microst Visual Basic comes up on screen
which says the following:path\file access erro: '\B1452.temp', am using
Microsoft XP and excel version 2002 (10.6501.6735),