Hi
I'm new to macro and this is for personal use. I have a question regarding macro where I import external data in txt format to excel.
I Use Data / Get External Data / From Text to import the text file into A1.
When I Import, I use the tab delimited file, and date format. I change the format of the data to save as a macro.
I assign a macro to a shape. I then save to .xlsm file.

If I send the file to someone to run the macro, how can they use this when the underlying data is saved in my documents?
Where should the data be saved so other people can run the macro?

Hope to hear from someone soon.

Thank you