Greetings all
First I just want to say thanks for this great site, keep up the good work.
Second I apologize if my question has been answered already, but I have searched the forum since the day that I registered trying to find a solution to my problem and haven?t been able to find anything yet, I have found some that was close to what I need but since I?m new to excel and vba I was unable to implement the codes that I have found to do what I need.
Ok here?s my problem I need to export a range of cells to a text file from a named worksheet and all the changes made to that sheet range area, has to be saved to the text file automatically I would say every 20 minutes the data is saved to that text file and when the workbook is closed, the range data has to be deleted from the worksheet range and when the workbook is open again it will load the data back to the data range automatically.
Question, is it possible to have the data loaded to the worksheet refreshed every 10 minutes or so?
I appreciate all and any help that you can give me on this matter.