Background -- For nearly one year I have been executing a macro which opens various files, goes to the worksheet CY-PY USD, updates a cell, saves each file and closes each file. Following is the specific code executed:
Workbooks.Open FileName:= _
"\\Fin Color Group\Forecast Pkg\21.xls", UpdateLinks:=3
Workbooks("21").Worksheets("CY-PY USD").Activate
Application.Goto Reference:="R5C4"
Dim Period_Code As Range
Set Period_Code = Worksheets("CY-PY USD").Range("D5")
Period_Code.Formula = VPeriod
Calculate
ActiveWorkbook.Save
ActiveWorkbook.Close
File Location -- Files reside on a Citrix server based at my office location, with the capability to access the drive and execute macros directly from the office or via internet dial-in.
Issue -- Our e-mail is Lotus Notes (another story). Two weeks ago my PC was upgraded to a new version of Notes. Ever since the upgrade, I get the "Subscript out of Range error 9" message when the macro attempts to execute the code:
Workbooks("21").Worksheets("CY-PY USD").Activate
This error occurs when I am accessing the server directly from my PC while in the office and full up the file on my PC.
While in the office, when I access the Citrix server via the internet and run the marco on the Citrix server, everything executes okay.
Any ideas???
Jim
Workbooks.Open FileName:= _
"\\Fin Color Group\Forecast Pkg\21.xls", UpdateLinks:=3
Workbooks("21").Worksheets("CY-PY USD").Activate
Application.Goto Reference:="R5C4"
Dim Period_Code As Range
Set Period_Code = Worksheets("CY-PY USD").Range("D5")
Period_Code.Formula = VPeriod
Calculate
ActiveWorkbook.Save
ActiveWorkbook.Close
File Location -- Files reside on a Citrix server based at my office location, with the capability to access the drive and execute macros directly from the office or via internet dial-in.
Issue -- Our e-mail is Lotus Notes (another story). Two weeks ago my PC was upgraded to a new version of Notes. Ever since the upgrade, I get the "Subscript out of Range error 9" message when the macro attempts to execute the code:
Workbooks("21").Worksheets("CY-PY USD").Activate
This error occurs when I am accessing the server directly from my PC while in the office and full up the file on my PC.
While in the office, when I access the Citrix server via the internet and run the marco on the Citrix server, everything executes okay.
Any ideas???
Jim