If ExcelFile Name is "NAME" question

[ScriptCrafter]

Hello,

Is there a way to cross reference an ExcelFile name.

I have tried several derivitives of If Then trying to match an Excel file that has been opened and stored to a variable and nothing seems to work.

Im looking for somehting like

If ExcelFileName = "FILE.csv" Then
msgbox (0, "HI" "YOU GOT IT")
else
msgbox (0, "BYE" YOU DIDNT")
EndIf

Thank You

[ScriptCrafter]

Hello,

Is there a way to cross reference an ExcelFile name.

I have tried several derivitives of If Then trying to match an Excel file that has been opened and stored to a variable and nothing seems to work.

Im looking for somehting like

If ExcelFileName = "FILE.csv" Then
msgbox (0, "HI" "YOU GOT IT")
else
msgbox (0, "BYE" YOU DIDNT")
EndIf

Thank You

BUMP because I am still stuck

[contrex]

I found 4 errors in your code. 1 missing dollar sign, 2 missing commas, 1 missing quote. So look at your code.

Edited December 22, 2009 by contrex