Hello,

i have a problem with a directory. The following is pre programmed
In my sheet cell a119 contains a value c:\windows\desktop

later in the vba code this value has given a variable
dir = activesheet.range("a119").value
dir is now know as c:\windows\desktop

Now i am working on a sheet that must be saved under a name in this dir
directory

chdir = dir
returns argument not optimal, does anybody knows how it schould be.

Regards,
Niek



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/