Path name in Excel workbook for Macro
in [Visual Basic]
|
Prev: simple string encryption
Next: jobboersen freiwillige arbeit im ausland stellenangebote Gestalter in fuer visuelles Marketing jobboerse
From: BigHairyUglyGuy on 3 Jul 2008 12:16 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?
From: Jeff Johnson on 3 Jul 2008 13:38
"BigHairyUglyGuy" <BigHairyUglyGuy(a)discussions.microsoft.com> wrote in message news:6B4DE713-B16F-418E-8E56-A5971469440F(a)microsoft.com... >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. |