Hi,
We have a intranet site to download data, when I open the downloaded file it opens as an excel file.
The first I download and run the file it opens as a name like AHT, when I download 2nd time it gets downloaded and name changes to AHT(2), 3rd time its AHT(3) and so on.
I copy the entire data from that file.
I have made a macro to paste the data which I copied earlier.
Is there any way, I can make a macro to automatically copy and paste data from the file which is already open like AHT or AHT(2) the problem here is that the file names increments everytime its downloaded.
In have used a code like
Worksheet(AHT).Range("A1"). Pastespecial
We have a intranet site to download data, when I open the downloaded file it opens as an excel file.
The first I download and run the file it opens as a name like AHT, when I download 2nd time it gets downloaded and name changes to AHT(2), 3rd time its AHT(3) and so on.
I copy the entire data from that file.
I have made a macro to paste the data which I copied earlier.
Is there any way, I can make a macro to automatically copy and paste data from the file which is already open like AHT or AHT(2) the problem here is that the file names increments everytime its downloaded.
In have used a code like
Worksheet(AHT).Range("A1"). Pastespecial