downloading excel file from website automatically to excel sheet
hi everyone,
i will be really grateful if you could help me on a issue.actually i have to download an excel file from a website given below
http://www.mcb.mu/en/include/popup/download-forex
automatically.can you please suggest me how i can do this.another problem is that the file gets downloaded to excel in xml format.How can I change it to .xls format.Please find the excel sheet attached.i need the table in spreadsheet in xls format to carry out certain operations, please see if you can help me.
thanks,
shenaz :) :)
Have you tried to contac file owner?
Try to contact them in order to get .xls file on regular basis. Ohter solution would be to make web query to import to Excel from their site.