case statement

T

Taher

Dim enteredvalue is variant
Select Case enteredvalue
Case 1
If Application.CurrentUser = "FF Billing Services" Then
Path = "I:\SIG\taher\FF Billing Services import.xls"
End If

Hello

I have an above code which specifies the route where the
file be soted when executed. But it works only with if
statement, but if i try to use if with case statemetn it
does not work
error is - action or method requires file name afrumetn.

I would appreciate if someone could help me on this.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top