code to create new excel file
 

Hi,
I want to create an excel file and rename the excel file. Please tel
me the code for the same.
Regards,
Ashis

--
ashishpre
-----------------------------------------------------------------------
ashishprem's Profile: http://www.excelforum.com/member.php...fo&userid=3148
View this thread: http://www.excelforum.com/showthread.php?threadid=51712

code to create new excel file
 

Hi Ashish,

Try something like:

'=============
Public Sub Tester001()
Dim WB As Workbook

Set WB = Workbooks.Add

WB.SaveAs Filename:="My Workbook" & ".xls", _
FileFormat:=xlWorkbookNormal

End Sub
'<<=============


---
Regards,
Norman


"ashishprem" wrote
in message ...

Hi,
I want to create an excel file and rename the excel file. Please tell
me the code for the same.
Regards,
Ashish


--
ashishprem
------------------------------------------------------------------------
ashishprem's Profile:
http://www.excelforum.com/member.php...o&userid=31485
View this thread: http://www.excelforum.com/showthread...hreadid=517122