create a workbook

  • Thread starter Thread starter Astik
  • Start date Start date
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
 
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
 
Back
Top