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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Simplify save code 11
save & backup file 1
writerespassword is not working 1
Conversion from text to excel 2
Two digit dates and two digit days 3
Hiding an Excel file using VBA 1
Save with ref. to cell A1 2
Need Help with VBA SaveAs 1

Top