FileExists Problem

[NSearch]

For some reason my FileExists statement will not work. Can anyone see what I am doing wrong?

Statement to save excel file (enters data in save as box and clicks enter).

If $domestic <> "D" then

Send("C:\"&$short_name&" International Detail "&$remit&"")

Send("{ENTER}")

EndIf

Statement to close excel once file has saved:

If $domestic <> "D" then

While $flag = 0

If FileExists("C:\"&$short_name&" International Detail "&$remit&".xls") Then

ProcessClose("excel.exe")

ExitLoop

EndIf

WEnd

EndIf

[blindwig]

can you locate the file and see that it is physically there on the drive?

[NSearch]

yes, it is created and saved. I can not understand why it is not being recognized

[HardCopy]

u gonna need to but a couple of debug points in your code to see what value $Domestic $Flag are returning.

put a messagebox(0,"Value of $Domestic + $Flag",$Domestic&" "&$Flag)

before both your save and close excel If statemnts. Other than that we need a bit more code to see what you actually defining in those variables.

HardCopy

Edited August 23, 2005 by HardCopy

[NSearch]

I have done this, and everything comes back the way that it should be before saving, and closing. Both have the same value, but for some reason I can not get it to recognize the file using fileexists.

[therks]

Try putting this line in there:

InputBox('Test', 'FilePath', "C:\"&$short_name&" International Detail "&$remit&".xls")

And if it looks normal, copy from the input box, and paste into your Start>Run dialog, and try to execute like that. If that works fine, then I'll be stumped.

[NSearch]

I am getting a "block". Looks to be a carriage return right before .xls

Am I constructing my string wrong?

FileExists("C:\"&$short_name&" International Detail "&$remit&".xls")

[HardCopy]

If $domestic <> "D" then

Send("C:\"&$short_name&" International Detail "&$remit&"")

Send("{ENTER}")

EndIf

Well u tagging an extra null on the end here!! dunno if that would kill it.

change "" to ".xls" try that

[seandisanti]

If $domestic <> "D" then

Send("C:\"&$short_name&" International Detail "&$remit&"")

Send("{ENTER}")

EndIf

Well u tagging an extra null on the end here!! dunno if that would kill it.

change "" to ".xls" try that

<{POST_SNAPBACK}>

try putting a space on either side of each of your &'s... if nothing else it will help readability. i know in vbs it doesn't like it when &'s are appended to variable names.

[NSearch]

I see what is happening. I am drawing in a carriage return when grabbing the remit number from a file. Is there a string command to strip a string of carriage returns?

[NSearch]

StringStripCR ( "string" )

Got it. Thanks everyone from your help!!!

[therks]

Just in case.. that will only strip carriage returns (ascii 13) sometimes you might have a line feed (ascii 10) on there too, in that case, try StringStripWS (whitespace).