create a workbook

A

Astik

hi,
i want to add a workbook with macro but i want to have the programme take
the name from somewhere else..
Workbooks.Add
ChDir "C:\Documents and Settings\Desktop\document"
ActiveWorkbook.SaveAs Filename:= _
"C:\Documents and Settings\medyauser\document\book1.xls", _
FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
 
T

tina

are you working in Excel? if so, suggest you post to an Excel newsgroup.
this ng answers questions about building macros in MS Access relational
database software.

hth
 
Top