| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code to create dbase file from text file? | Excel Discussion (Misc queries) | |||
| IT'S POSSIBLE TO CREATE UPC CODE IN EXCEL | Excel Worksheet Functions | |||
| Import VBA Code in Excel-File ? (Export VBA Code to file) | Excel Programming | |||
| Create a batch file from a number of Excel File | Excel Programming | |||
| Cant get my code work. Find file or create it | Excel Programming | |||
![ashishprem[_8_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
