Macro in excel to save to an unmapped drive !
Help...
Can anybody hlep me out here... I am trying to construct a macro part
of which will save a file to an unmapped drive, i can do this when the
filename is static but I need to change the filename
cellvalue2 = Sheets("explanations").Range("F1").Text
myvalue = cellvalue2
ActiveWorkbook.SaveAs Filename:=myvalue
I can also do it when I have a mapped drive by using CHDRIV "E:"
but not to an unmapped one !
Can anybody help?
|