Hi everyone
Please bear with me, as I am new to macros.
I have created a spreadsheet (currently just a test/example) that I will send out via email to staff members.
They will input their information (eg. name, job title, phone number etc) and email it back (so there will be variable file names).
When I receive the file back from them, I will open that and run a macro from the master spreadsheet that I will copy the information into.
This is the macro I have so far... (this is just me testing, I haven't fully developed all the content, hence the simplicity)...
The problem is, when I receive another file and open it eg. "John.xls" (instead of "Jess.xls"), I try to run the macro, it doesn't work because it is a different file name.Please Login or Register to view this content.
Is there something I can replace in the line:
Windows("Jess.xls").Activate
that will allow me to use whatever the other file name is open (whether it be "Jess.xls", "John.xls", "Mary.xls", "Peter.xls" etc etc) and import the data from that file?
The "master.xls" is the file that contains the macro that will house all the data.
I have attached the example master file and two test files that people might send to me.
Master.xlsJess.xlsJohn.xls
Thanks in advance!
Jess.
Bookmarks