Using Cell contents as Path

[pauluk]

Hello,

Am looking at to use a cells contents for the ChDir and also the workbook.open.

I have the path for the ChDir coded into the macro however i would like this to be in a cell on sheet2 and the macro will refer to it when need. the reason for this is so the user can change the contents of this cell in the furture to reflect the new loction of the workbook or directory of which to save the work book to.

Thanks in Advance

[mccreaso]

Hi try this,

Please Login or Register  to view this content.

mccreaso