I am a novice Excel user and I know this is not a typical Excel problem.
I have a workbook called 67102 and when launched it opens a duplicate of the same spreadsheet. You enter information into the second spreadsheet and then save it as another name ( example ABC ). When you close ABC it also closes the 67102 as well automatically. 67102 is back to its original form ready for the next time. This is a workbook with alot of scripts and macros and not an template. It works great under its current configuration with no issues.
The reason that I am searching for an answer is that it is built in Office 2003 on an XP machine. I need to update the computer. When I open the same exact work book via remote desktop I get a VB error stating it can not close the second sheet. When using the same configuration PC (XP and Office 2003) only one workbook is launched unless you are on the single PC that it works sucessfully on.
The introductory questions are this:
How can you code a workbook to open a second copy of the workbook per a PC?
Is there a way to copy the complete workbook over with the customize adjustments to another computer?
This is the script that it is attempting to run when it gets an error:
Public Sub ClosingEverything()
On Error Resume Next
With RHTemp1
'.Terminate
.ActiveXActive = False
.TimerInterval = 0
.StopContinuousReadings
End With
Delay (1)
End Sub
What does this mean and where do I go find the items that peform the tasks above on that particular machine?
Many thanks for any help you provide.
I have a workbook called 67102 and when launched it opens a duplicate of the same spreadsheet. You enter information into the second spreadsheet and then save it as another name ( example ABC ). When you close ABC it also closes the 67102 as well automatically. 67102 is back to its original form ready for the next time. This is a workbook with alot of scripts and macros and not an template. It works great under its current configuration with no issues.
The reason that I am searching for an answer is that it is built in Office 2003 on an XP machine. I need to update the computer. When I open the same exact work book via remote desktop I get a VB error stating it can not close the second sheet. When using the same configuration PC (XP and Office 2003) only one workbook is launched unless you are on the single PC that it works sucessfully on.
The introductory questions are this:
How can you code a workbook to open a second copy of the workbook per a PC?
Is there a way to copy the complete workbook over with the customize adjustments to another computer?
This is the script that it is attempting to run when it gets an error:
Public Sub ClosingEverything()
On Error Resume Next
With RHTemp1
'.Terminate
.ActiveXActive = False
.TimerInterval = 0
.StopContinuousReadings
End With
Delay (1)
End Sub
What does this mean and where do I go find the items that peform the tasks above on that particular machine?
Many thanks for any help you provide.