get folder syntax
 

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
--
sr

get folder syntax
 

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

"SR" wrote:


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
--
sr