file path change

[kraigt84]

Hi all,

I am trying to display the below path in a dialog box after changing the current directory in An Excel Macro. Code Sample:

ChDir "G:\Inventory Management\Daily Audits\BCS"

externWorkbookFilepath2 = "G:\Inventory Management\Daily Audits\BCS"

MsgBox externWorkbookFilepath2

MsgBox "Select BCS Files", vbOKOnly

The end result I am trying to accomplish is to go to the folder and select files. Currently the above does not give me the expected result on the first iteration. When I run the ChDir command later in my code to:

ChDir "G:\Inventory Management\Daily Audits\VNDR"

The appropriate VNDR folder is displayed

My hunch is it is the first time I set the directory that is causing the issue. Subsequent changes work correctly. Does anyone have a work around. Possibly opening another directory cancelling, then opening the directory?

 

[Fluff]

Try adding this

[COLOR=#0000ff]ChDrive "G:"[/COLOR]
ChDir "G:\Inventory Management\Daily Audits\BCS"

 

[kraigt84]

Thanks that worked for myself and another individual I was writing the VBA for!

 

[Fluff]

Glad to help & thanks for the feedback