View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Excel File To update Automaticaly

See Chip Pearson's page on Document properties:

http://www.cpearson.com/excel/docprop.htm

Attachments are generally frowned upon in this group.

--
Regards,
Tom Ogilvy

"Khawar" wrote in message
...
Good day,
I have an excel file which I will try to attach here.
It simply had different sheets for The ROE.
All I need is a process or a macro which on the press of a button or upon
opening of the file, reads when was the last update date of the file,

opens
oanda.com- Fx history page, downloads the data for Each currency in the

file
and paste it in the relevant columns/Rows.