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