Macros and Linking
I have multiple workbooks and need to get information from one sheet from
every book. I have created a macro that will go through all the books. Two
1. How can I stop the macro from prompting to save the source workbooks and
stop the message relating to the clipboard from poping up each time.
2. Can I create a named list for the macro to loop around so I don't have to
edit the macro each time a new source workbook is created
Here's my macro
Workbooks.Open Filename:= _
"C:\Documents and Settings\Rousec\My Documents\wickes\ph6249.xls"
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False
|All times are GMT +1. The time now is 09:58 AM.|
Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.