Hello everyone,
I'm trying to develop a macro to amalgamate some data on currency exchange rates that are stored in different files with the dates saved in the file's name.
The code of the macro I recorded when opening an example of such a workbook is:
Where: E:\ is the directory the files I want to amalgamate are stored
"EURUSD Curncy" is the currency pair ie. the Euro against US Dollar
"08012009" is the date at which the data starts ie. 8th Jan 2009
What I'd like my macro to do is
1. Open the file in E: that contain the text "EURUSD Curncy" that contains the oldest data start date
2. Perform some operation on it (I've got this bit covered )
3. Close that file
4. Open the next file in chronological order ie. it should open "EURUSD Curncy 08012009.xls" before "EURUSD Curncy 09022009"
I hope I've explained this properly enough to give you a foothold into this predicament. If you have any questions or queries, please don't hesitate to post me back.
Many Thanks in advance for your time,
Twills.
Bookmarks