patgenn123 Posted October 15, 2009 Report Share Posted October 15, 2009 Hello all. I was wondering if anyone could give me a serious answer on this. I might have to go to an excel forum, but maybe there is an answer here. I am "importing external data" from a database to Excel. I set the "refresh" for every 60 seconds. Since I am new in programming, I don't know what to do next. Here is/are my question(s): First, I want to keep the excel file "hidden" and don't want this seen on the desktop at all. So my question is: How can I get a macro to "refresh this" with ME whenever the macro triggers it despite the fact that Excel refreshes itself every 60 seconds. I still might need it to refresh WHENEVER I need it to. Also, if the Excel file is hidden, how can I get it to be "saved" as a tab-delimited/comma delimited without showing any action on the computer screen? How can I get it to be saved whenever I ask ME to save it even though the Excel file is hidden from view? The tab/comma delimited file can be saved in any folder. Am I approaching this the wrong way? If anyone knows a better way(that is, without ME involved), let me know. However, I prefer to stick with ME for the answer. If there are any questions about my foolhardy questions, let me know. I will try to answer by clarifying my questions!!!!!!! Pat Gennarelli Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.