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:
Any idea why this does not work and/or how I can make it work?Code:Set DD = Workbooks(myFilePath).Worksheets("2012")
Let me know if this isnt clear. Thanks!