Hi,

I need a message box function that I can just call from any module. All I need it to do is ask the user for the filename they are using. Then when user, types in the filename & clicks ok, it assigns to a Global variable. I have the rest of the code out but I am struggling with this part. Doesnt matter about the path as all files are in the same dir.
Any help would be brill Thks Sea

Hi Sea

'type this at the top of the module
Public xyz As String

'this is the function
Function getxyz()
xyz = InputBox("What is the filename that you are using?")
End Function


Cheers
JulieD

"Sea" wrote in message
...
Hi,

I need a message box function that I can just call from any module. All I
need it to do is ask the user for the filename they are using. Then when
user, types in the filename & clicks ok, it assigns to a Global variable. I
have the rest of the code out but I am struggling with this part. Doesn't
matter about the path as all files are in the same dir.
Any help would be brill Thks Sea

fName = Application.GetOpenFileName()

This does not open the file, just provides the user with the file open
dialog to select a file.

It does return the name with the path, but you can strip off the path if you
need to.

--
Regards,
Tom Ogilvy


"Sea" wrote in message
...
Hi,

I need a message box function that I can just call from any module. All I
need it to do is ask the user for the filename they are using. Then when
user, types in the filename & clicks ok, it assigns to a Global variable. I
have the rest of the code out but I am struggling with this part. Doesn't
matter about the path as all files are in the same dir.
Any help would be brill Thks Sea