Insert variable name for external data importing

[kanga]

Hi,
Help please.
I am trying to automate a process of importing data from a daily text file (stock prices) and then copying the appropriate data into another file for analysis.

I need an input box that allows me to vary the looked-up file name. Any ideas??

Thanks

Peter

 

[stevebausch]

Investigate the InputBox method.

If no variety helps you out, get back to this same thread (NO DOUBLE POST, PLEASE!) and tell us the shortcoming.

There are several flavors of InputBox method.