Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open another excel file in macro
I'm trying to open another excel file to no avail. Here's what I have: Code: -------------------- Dim Location As String Location = "U:\BridgeRun_" & VendorCode & "_" & Months & "_Months.xls" GetObject (Location) -------------------- Any other ideas? -- DKY ------------------------------------------------------------------------ DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515 View this thread: http://www.excelforum.com/showthread...hreadid=543838 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open another excel file in macro
Use the Open method of the Workbooks object.
Workbooks.Open Filename:=your_file_name -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "DKY" wrote in message ... I'm trying to open another excel file to no avail. Here's what I have: Code: -------------------- Dim Location As String Location = "U:\BridgeRun_" & VendorCode & "_" & Months & "_Months.xls" GetObject (Location) -------------------- Any other ideas? -- DKY ------------------------------------------------------------------------ DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515 View this thread: http://www.excelforum.com/showthread...hreadid=543838 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open another excel file in macro
Hi,
Looks to me like GetObject is not used for Excel files. I think you should be using: Workbooks.Open Filename:= Location to open an Excel workbook. -- Ken Hudson "DKY" wrote: I'm trying to open another excel file to no avail. Here's what I have: Code: -------------------- Dim Location As String Location = "U:\BridgeRun_" & VendorCode & "_" & Months & "_Months.xls" GetObject (Location) -------------------- Any other ideas? -- DKY ------------------------------------------------------------------------ DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515 View this thread: http://www.excelforum.com/showthread...hreadid=543838 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open Excel file from VB and open MACRO | Excel Discussion (Misc queries) | |||
Open a file do a macro ( made) and open next succesive file | Excel Programming | |||
to open a pdf file from a macro in excel | Excel Programming | |||
ASP: Open Excel File with Macro, Allow Macro to run, and then save | Excel Programming | |||
excel open file macro | Excel Programming |