Open a workbook from a written path
On Sep 21, 10:41*pm, Boris wrote:
On Sun, 21 Sep 2008 21:23:02 -0700, Ricardo Silva wrote:
Hi,
I would like to run a macro that would open a workbook in which the path is
written in a cell.
Can someone help me?
Cheers
Ricardo
If path is stored in cell B2 on Sheet1, the macro would contain this:
Workbooks.Open ThisWorkbook.Worksheets("Sheet1").Range("B2").Text
HTH
B.
Gary and Boris,
I get a subs-script out of range on both proposed solutions. I used
"A20" as my range. Ideas?
Don in Montana
|