Making the run of Macro not visible

[kaffal]

Hi all, I have a macro that will locate files in a folder, then it will copy the worksheets and paste into the current workbook.

However It need to open up to 100 workbooks and copy and paste into the new workbook. During the run of the macro, I can see files opening and closing on the toolbar. is that possible to make those opening and closing of files not seen by the user?

Pls Advise.

Please Login or Register  to view this content.

[royUK]

Does the rest of your code activate or select the workbooks?

[kaffal]

yes, the macro works like this. It will search through the folder for file name containing a cell value. Once Found, it will open the workbook and copy the entire sheet and paste to the new workbook. Once copied, it will close the workbook and continue to search for files in the directory till all are compared.

If the filename does not contain what the cell value specify, it will not open the files.

If we can see the opening and closing of the workbooks during the macro run, is that normal ? or is that a way to hide those ?

[royUK]

You don't need to activate or select these workbooks and/or sheets - this will result in faster, more efficient ode & remove theflashing effect.

[kaffal]

Hi royUK,
sorry I new to VB, I dun get what you mean
Maybe you could take a look at my code and comment

Please Login or Register  to view this content.