Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Click here to start participating now! Also, check out the New User Guide.
Excel macro
Name: Bruce33 Date: October 19, 2005 at 08:43:11 Pacific OS: Win XP CPU/Ram: Athlon
Comment:
Hi,
I have a spreadsheet that is set to refresh/update with external web data every 2 minutes and what I want to do is to store a history of data in a table, in the workbook.
To do this I have written a macro which stores the updates data sequentially, the only problem is that I have to manually instruct the macro to "run" after each 2 minute refresh.
Does anyone know how I can set my computer to automatically run the macro following a "refresh data" event ?
Summary: HI, Having this problem. Does anyone knows how to read latest updated file from excel macro. eg. File1 reads formula from FM03 and if I add FM04(which is the latest), I want File1 to read the latest ...
Summary: Hello all, long time since ive posted, need some help from you guys again please. i have made an excel macro, on the excel page you have a drop down menu which you can use to select an option from. Wh...