db342
07-25-2007, 05:25 PM
Very new to VBA, but wrote a macro that allows the user to type in a file/filepath on an "Entry" ws which will then open 6 groups of 24 different CSV files and compile them into one newly created workbook with 6 worksheets - 1 ws for each group. (In other words, there is one Excel WB with one WS called "Entry". Data is entered on that and the macro is run from there. The macro creates a new workbook, then pulls all 6x24 worksheets of data into the new workbook and saves it.)
Everything is working except that when it is running the excel ws "Entry" (the ws that is opened in order to run the macro) blinks and the taskbar shows the little blips/blinks with all the files being opened and closed.
I did shut off the screen autoupdate so all the data isn't scrolling about, but any attempts to change the visibility of the windows or application to get rid of the remaining blinking is either shutting off the "Entry" window as well or is creating an object not found error.
There is a sub that creates the new (destination) wb and a sub that opens, copies, and closes both the destination and the source wb/ws's
Any ideas as to how to make this appear as though nothing is happening while all of these files are being opened, copied, closed...??
Thanks for any help!
Shawn
Everything is working except that when it is running the excel ws "Entry" (the ws that is opened in order to run the macro) blinks and the taskbar shows the little blips/blinks with all the files being opened and closed.
I did shut off the screen autoupdate so all the data isn't scrolling about, but any attempts to change the visibility of the windows or application to get rid of the remaining blinking is either shutting off the "Entry" window as well or is creating an object not found error.
There is a sub that creates the new (destination) wb and a sub that opens, copies, and closes both the destination and the source wb/ws's
Any ideas as to how to make this appear as though nothing is happening while all of these files are being opened, copied, closed...??
Thanks for any help!
Shawn