VBA to open workbook from a selected drive

[Blunder1]

Hi,

I need to open a workbook from a selected drive. The workbook name will always be changing so i will need to choose that myself, but i would like the macro to open the drive in the correct place, ie C:London\New\........xls

thanks in advance

Blunder1

 

[wigi]

Did you look at the ChDrive and ChDir functions?

 

[Burrgogi]

Hi,

I need to open a workbook from a selected drive. The workbook name will always be changing so i will need to choose that myself, but i would like the macro to open the drive in the correct place, ie C:London\New\........xls

thanks in advance

Blunder1

Which version of Excel are you working with? If 2007 or 2010, click on the Office button (top left corner). Then click Excel Options.

Under 'Save' > Default File Location.

 

[Blunder1]

the ChDir worked, thanks for pointing me in the right direction, Wigi