Thread: Open a workbook from a written path
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Boris[_3_] Boris[_3_] is offline
external usenet poster
  
Posts: 12
Default Open a workbook from a written path
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.
Reply With QuoteReply With Quote