VBA to set Default Local File Location

[drewg]

Hi
How can I get the string value of the current folder of a workbook i think i mean curdir()
(by current folder, i mean the folder in which the workbook was just saved)
written into Options->Save->Default Local File Location?
What is the name of its Excel container and the property i need, and can I set it in this way?
Thanks very much.

 

[VBA Geek]

I think you mean:

[B]Application.DefaultFilePath[/B]

https://msdn.microsoft.com/en-us/vba/excel-vba/articles/application-defaultfilepath-property-excel

 

[drewg]

I think so too
thanks very much