var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: checking to see if file exits
I'm using this to check to see if file exists:
If Dir("T:\SQLDATA\Order_Header.txt") <> "" Then
"Do this...commands go here"
MsgBox "Order Header does not exist, try again in 5 minutes"
It works fine to check for one file, but I need to check for 5 or so. Can anyone recommend an approach?
If this method works for one file, use a boolean variable and iterate through all of the required conditions. If at any point during the iterations your condition fails, set your boolean variable. Check the variable at the end of the code and act accordingly.
Or you can use an array putting all your file names in it, loop through it checking for the existence of the files.
RE: check if file exists
Try this. It will loop thru the folder for your txt file.
Dim tmpFile As String
Dim tmpPath As String
tmpPath = "T:\SQLDATA\"
tmpFile = Dir(tmpPath & "*.txt")
Do While tmpFile <> ""
'Do this... commands go here
tmpFile = Dir