I tried this, by putting this in FDM under scripts Custom--> General. When I try to run this, it errors out
Error: An error occurred running the script:
9 - Subscript out of range
At Line: 110
I wonder what I am doing wrong ?
Line 110 :
|Set oSheet = oBook.Worksheets(intCurrentSheetOrdinal)|
i too tried it, i am getting the similar error.
"Subscript out of range"
i am trying to create a folder one step up from the OUTBOX folder and creating the file.
but to pop-up the message window and copy the file to an custom path for the user. i couldnt make it.
can you please help me.
|Set objFileSys = CreateObject("Scripting.FileSystemObject")|
|strString = "Outbox"|
|strPos = InStr(API.DataWindow.Connection.PstrDirOutbox, strString)|
|strPos = strPos - 1|
|strOutputFilePath = Left(API.DataWindow.Connection.PstrDirOutbox, strPos) & "User Dumps\"|
|strOutputFileName = API.POVMgr.PPOVLocation & "_DimensionMaps.xls"|
Were you able to get the subscript out of range error fixed ?