Dynamic path within macro

[jescat]

Hi,
I have a macro that is importing data, what I would like to do is import data from a path specified in a form rather than having it hard coded into the macro. Is there a way to do this.

Thanks

 

[Isadore]

Jes: You should be able to set up a vba statement that constructs the path depending on user input on the form, etc... What type of data are you trying to import?

 

[jescat]

Thanks for the response, I think I got it.