Hi,
I am very new to macros but need to implement them on a project. Have been trying to work on my own and learnt a lot but due to time constraint, need help now.
I am trying to do the following -

1. Open an excel file (with some formatting macros)
2. As soon as this file opens, a dialogue box opens asking for the source excel file. (The source excel file is extracted from the internet and the name is variable with dates).
3. On entering the location, the source filer opens up (simultaneously with our destination file opened up) and the data from the only available sheet from the source file gets copied to the first sheet on our destination file)

I am able to have the dialogue box and have the source file open up but I am not able to select the source file as active sheet and copy the data on the destination file (which wee know the name and path for)

This is the file with the dialogue box macro:
https://www.dropbox.com/s/bzapyxqjxx...Worksheet.xlsm

Thanks in advance,
Raunaq