Prompt for Address on upload

[lovemuscle2005]

I have a macro with a very standard transfer spreadsheet command.

The problem is the file which I want to transfer is commonly moved (beyond my control) to another location, hence the upload fails.

Is there some code I could use to prompt the user for an addres?

Thanks in advance

:->

 

[Norie]

Maybe something like this.

Dim strFileLoc

     strFileLoc = Msgbox("Please enter the location of the file")

You could then use the variable strFileLoc in your code.

 

[lovemuscle2005]

A great idea, but that would just give me a yes/no or OK type message box.

I need to be able to choose a file path

 

[Norie]

Sorry MsgBox should be InputBox.

 

[lovemuscle2005]

Yes, we did it at the same time!

Works great, cheers for your help