get folder syntax

S

SR

Hi,

in my current macro I am using a cell to input the folder path information.
Can I ask the user to inut the path (similar to Application.GetFileOpen()). I
need the folder path from where the macro will read file one by one. Can
someone suggest please.

Thanks in advance
 
P

peabrain25

Can you use a message box?

dim FilePath as string

FilePath = msgbox("Please provide the file path", VbOKOnly, "File Path
Needed")

Then you have FilePath as whatever they type in.

Mark
 
Top