I have a macro stored in Worksheet A that opens another file (Worksheet B). I would like to put the path and filename of Worksheet B inside Worksheet A, so that it's not hidden in the Macro. How can I reference the worksheet path & filename in Worksheet A from the Macro?
Tue, 21 Dec 2010 00:16:00 GMT
Jeff Johnso #2 / 2
Path name in Excel workbook for Macro
Quote:
>I have a macro stored in Worksheet A that opens another file (Worksheet B). > I would like to put the path and filename of Worksheet B inside Worksheet > A, > so that it's not hidden in the Macro. How can I reference the worksheet > path > & filename in Worksheet A from the Macro?
You'd be better served by asking this question in microsoft.public.excel.programming.
Path name in Excel workbook for Macro