Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 1st 04, 04:15 PM
Chris
 
Posts: n/a
Default 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
points
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"
Range("A9:G29").Select
Selection.Copy
Windows("summaries.xls").Activate
Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False
Range("C24").Select
Windows("ph6249.xls").Activate
ActiveWorkbook.Close
Range("A23").Select
'

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:45 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017