| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open a file with a macro
Hi, I wonder if it's possible to create a macro that can open a file? I need a macro-solution for this problem: For example, if I change something in file1 and then run my macro and it will open file2 and copy some cells from file1 to file2 and then close file2 again. Can someone help me, please? //Vanity -- Vanity ------------------------------------------------------------------------ Vanity's Profile: http://www.excelforum.com/member.php...o&userid=24568 View this thread: http://www.excelforum.com/showthread...hreadid=381561 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open a file with a macro
Set oThis = ActiveWorkbook
Workbooks.Open Filename:="Example.xls" oThis.Worksheets("Sheet1").Range("A1:H10").Copy ActiveSheet.Range("A1") ActiveWorkbook.Close -- HTH Bob Phillips "Vanity" wrote in message ... Hi, I wonder if it's possible to create a macro that can open a file? I need a macro-solution for this problem: For example, if I change something in file1 and then run my macro and it will open file2 and copy some cells from file1 to file2 and then close file2 again. Can someone help me, please? //Vanity -- Vanity ------------------------------------------------------------------------ Vanity's Profile: http://www.excelforum.com/member.php...o&userid=24568 View this thread: http://www.excelforum.com/showthread...hreadid=381561 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Open Excel file from VB and open MACRO | Excel Discussion (Misc queries) | |||
| 2007 Macro to Open File, Delete Contents, Save New File | Excel Discussion (Misc queries) | |||
| ASP: Open Excel File with Macro, Allow Macro to run, and then save | Excel Programming | |||
| Automate open file, update links, run macro, close and save file | Excel Programming | |||
Hybrid Mode
