Getting Values From A Different File 1

[SandraF]

I was wondering if it is possible to get information from another file.

For example, I am trying to create a macro, and would like to get the values of certain cells from a worksheet called "CONTRACT BRIEF" that is located in another file called MAster5.xls. THe file I am creating the macro in is called Db.Xls.

Any help would be appreciated! THANKS

 

[Dreamboat]

Sandra, you should easily be able to record that macro. But the code would look like this:

Sub Macro1()
Workbooks.Open Filename:="C:\My Documents\master5.xls"
Range("A113&quot.Select
Selection.Copy
Windows("Book2&quot.Activate
Range("D1&quot.Select
ActiveSheet.Paste
Range("A1&quot.Select
End Sub

Of course, there's another alternative:

Copy the stuff once, go to your db.xls file and hit Edit-Paste special-Paste link and save it that way. That way when the data changes in master5.xls, it should automatically change the data in db.xls.
techsupportgirl@home.com
Brainbench MVP for Microsoft Word

http://www.brainbench.com