VBS Modification Needed
OK. When I launch the 'splice_years.vbs' form the command prompt in the 'scripts' direcotry, I get the below error. I had to copy the 'actfisc.txt' file into the 'scripts' directory from the 'data' directory. It processed the 'actfisc.txt' file ok, but when it tried the next file it errored out. Why can't it look in the 'data' directory for the data files and process them there while the script remains in the 'script' directory?
D:\AppFiles\SDS\SDS_Retail
Microsoft (R) Windows Script Host Version 5.6
Copyright (C) Microsoft Corporation 1996-2001. All rights reserved.
start - 1/7/2013 11:25:52 AM
file actfisc.txt - 1/7/2013 11:25:52 AM
D:\AppFiles\SDS\SDS_Retail
runtime error: File not found
D:\AppFiles\SDS\SDS_Retail
Microsoft (R) Windows Script Host Version 5.6
Copyright (C) Microsoft Corporation 1996-2001. All rights reserved.
start - 1/7/2013 11:26:31 AM
file actfisc.txt - 1/7/2013 11:26:31 AM
file actppln.txt - 1/7/2013 11:26:55 AM
D:\AppFiles\SDS\SDS_Retail
runtime error: File not found
splice-years.vbs
D:\AppFiles\SDS\SDS_Retail
Microsoft (R) Windows Script Host Version 5.6
Copyright (C) Microsoft Corporation 1996-2001. All rights reserved.
start - 1/7/2013 11:25:52 AM
file actfisc.txt - 1/7/2013 11:25:52 AM
D:\AppFiles\SDS\SDS_Retail
runtime error: File not found
D:\AppFiles\SDS\SDS_Retail
Microsoft (R) Windows Script Host Version 5.6
Copyright (C) Microsoft Corporation 1996-2001. All rights reserved.
start - 1/7/2013 11:26:31 AM
file actfisc.txt - 1/7/2013 11:26:31 AM
file actppln.txt - 1/7/2013 11:26:55 AM
D:\AppFiles\SDS\SDS_Retail
runtime error: File not found
splice-years.vbs
Last Comment
ASKER
My first two lines of the 'splice_years.vbs' is:
Option Explicit
Const C_DATA_DIR = ".\" ' "D:\AppFiles\SDS\SDS_Retai
Option Explicit
Const C_DATA_DIR = ".\" ' "D:\AppFiles\SDS\SDS_Retai
ASKER
OK. I'm an idiot as I forgot about trigger file. So it's executing now. However it's still requiring my data files to be in the 'scripts' directory not the 'data' directory. The second line of the 'splice_years.vbs' is: Const C_DATA_DIR = ".\" ' "D:\AppFiles\SDS\SDS_Retai
thus very confused here.....
thus very confused here.....
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks. Missed that. Works great.
Visual Basic Classic
Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.
165K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
Change that line back and it should work:
Open in new window