When the query updates I need to save

[solidsnake5698]

I don't know if I should post this in the Programming forum or not, if you think this question is more of a programming question tell me and I'll move forums... But here I go.

OK I've got a xls with 3 sheets in it. One sheet called PremiumWebsite is a web query that updates every 5 minutes on this update I would like sheet energy columns A, B, C, D, E, F, and S rows 23 - 70 to write to a notepad file called C:\Users\Hatty\Desktop\Solar\forcast.txt. I want this file to write out every 5 mins so the file needs to have some sort of timestamp so it doesn't get written over every 5 mins but I have a log of files for the day.

Thanks

Chris

[mrice]

Sounds like you could write a macro linked to the sheet_change event on your first sheet which writes the text file as described.

Have a look at Open Statement in the VBA Help.