Thread: code to create new excel file
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
  
Posts: 5,302
Default 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



Reply With QuoteReply With Quote