Open another excel file in macro

[DKY]

I'm trying to open another excel file to no avail. Here's what I have:

Please Login or Register  to view this content.

Any other ideas?

[Chip Pearson]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Ken Hudson]

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
>
>