manish.agrawal446@gmail.com
Member
Hi,
I am using excel 2007..
We download a daily report from a particular URL. This report is in csv.
To download this file, we go to internet explorer, give the url , for eg:-http://downloadfile , there is an arrow button , on clicking which, option comes to download or open the xls come
and then save this file in desktop as issues.csv
I have another file in another location for eg: Dmanishfilename.xlsx
Normally I copy issues.csv in sheet1 of new excel say as manish.xls
and I will copy the data from Dmanishfilename.xlsx to sheet2 of manish.xls
Can we write a macro for the same
I am using excel 2007..
We download a daily report from a particular URL. This report is in csv.
To download this file, we go to internet explorer, give the url , for eg:-http://downloadfile , there is an arrow button , on clicking which, option comes to download or open the xls come
and then save this file in desktop as issues.csv
I have another file in another location for eg: Dmanishfilename.xlsx
Normally I copy issues.csv in sheet1 of new excel say as manish.xls
and I will copy the data from Dmanishfilename.xlsx to sheet2 of manish.xls
Can we write a macro for the same