ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   OPening worksheet (https://www.excelbanter.com/excel-programming/318815-opening-worksheet.html)

Teresa

OPening worksheet
 
Hi,

In cell A1 I have a path: "C:\My Documents\March Rec.xls"

and I have code:

sub op()
A1.Open
end sub

Why doesnt this work? Thks a lot for your help

KL[_6_]

OPening worksheet
 
This should work:

Workbooks.Open Range("A1").Text

Regards,
KL


"teresa" wrote in message
...
Hi,

In cell A1 I have a path: "C:\My Documents\March Rec.xls"

and I have code:

sub op()
A1.Open
end sub

Why doesnt this work? Thks a lot for your help





All times are GMT +1. The time now is 08:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com