Greetings,
I have a line of code in my excel vba code that calls to a VBScript:
Shell "wscript C:\Users\kev\Documents\VBScript_Stuff\Copy_File_to_Splitter.vbs"
I want the VBScript to receive a variable "sFile" a string, which contains a file name and add that to the file path in VBScript. The VBScript exists outside of the VBA code.
vbscript:
Set objFSO = CreateObject("Scripting.FileSystemObject")
FileSystemObject.CopyFile "\\abc\LoMo\ImportFileLoadingDock\KeLance\" & TodaysFolder & "\" & sFile, "destination path"
I've searched the message boards but haven't found anything that fits the bill. Does anyone have knowledge of how to do this?
thanks,
Keith
I have a line of code in my excel vba code that calls to a VBScript:
Shell "wscript C:\Users\kev\Documents\VBScript_Stuff\Copy_File_to_Splitter.vbs"
I want the VBScript to receive a variable "sFile" a string, which contains a file name and add that to the file path in VBScript. The VBScript exists outside of the VBA code.
vbscript:
Set objFSO = CreateObject("Scripting.FileSystemObject")
FileSystemObject.CopyFile "\\abc\LoMo\ImportFileLoadingDock\KeLance\" & TodaysFolder & "\" & sFile, "destination path"
I've searched the message boards but haven't found anything that fits the bill. Does anyone have knowledge of how to do this?
thanks,
Keith