Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open excel workbook within macro
Hi! I have a macro that opens a file and goes through a list. If ceratian
things are found in the list I want to open an Excel file and read from that file to the original file. How do I open an excel file from a macro and how can I read from it? Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open excel workbook within macro
This is right out of VBA help file.
Sub OpenUp() Workbooks.Open("C:\MyFolder\MyBook.xls") End Sub If the file you want to open is in the same directory as the active workbook, then you don't need the full path. Once open, you can access it and manipulate data much the same as the active sheet, but you will need to use the workbook and sheet references as you do it like. Workbooks("MyBook"),Sheets(1).Range("A1:B5").Copy Workbooks(ActiveWorkbook).Sheets(1).Range("A1") Good Luck. "Arne Hegefors" wrote: Hi! I have a macro that opens a file and goes through a list. If ceratian things are found in the list I want to open an Excel file and read from that file to the original file. How do I open an excel file from a macro and how can I read from it? Thanks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open excel workbook within macro
Sub Macro1()
Workbooks.Open Filename:="C:\surprise.xls" MsgBox (Range("A1").Value) End Sub -- Gary''s Student - gsnu200754 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open excel workbook within macro
Hi Arne
i hope the code below clears things up for you a bit 'open your workbook giving the full location and name Workbooks.Open ("C:\test\filename.xls") 'activate the workbook you want to work with Workbooks("filename.xls").Activate [A1:A20].Copy 'for example 'activate the original workbook and paste Workbooks("original.xls").Activate [A1].PasteSpecial (xlPasteAll) hope this helps Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening Excel, Book1 opens, remains open with other workbook open | Excel Discussion (Misc queries) | |||
Excel macro to open a password protected workbook | Excel Discussion (Misc queries) | |||
Open workbook macro- find correct month to open? | Excel Programming | |||
Excel 2003 - Keep a Macro Running While the Workbook is Open | Excel Programming | |||
Excel - open a new workbook with "own" macro | Excel Worksheet Functions |