[RESOLVED] Browse for workbook, set path as variable

[bheltzel]

I have an activex button that browses for a workbook and sets the path as a string (myFilePath).

In another sub I dim DD as worksheet, and try to set it as myFilePath like so:

Set DD = Workbooks(myFilePath).Worksheets("2012")

Any idea why this does not work and/or how I can make it work?

Let me know if this isnt clear. Thanks!