I've re-read my post above and it seems a little jumbled!! Here'
another try at explaining my problem....
When I open the OrderForm.xls file from the folder itself, I want
macro within it to set the folder it is in to the current directory.
At the moment when I open the file this way the current director
remains as 'My Documents'.
I know the current directory changes if I open the file via the Fil
menu in Excel, but ideally I'd like it to change in both situations...
--
Message posted from
http://www.ExcelForum.com