Thread: Open another excel file in macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DKY[_116_] DKY[_116_] is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote