| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A problem with creating a workbook by VBA
Hi
I know example1 is right, example2 is wrong. Please tell me, why is the second example wrong? Following is my code: Example(1) Public Sub CreatWB() Set NewBook = Workbooks.Add NewBook.SaveAs Filename:="D:\111" End Sub Example(2) Public Sub CreatWB() Set Newbook = Workbooks Newbook.Add Newbook.SaveAs Filename:="D:\111" End Sub Thanks in advance for any help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a workbook | Excel Discussion (Misc queries) | |||
| Creating a drop box in a workbook. | Excel Discussion (Misc queries) | |||
| creating directory for workbook | Excel Discussion (Misc queries) | |||
| Creating a log in a workbook | Excel Discussion (Misc queries) | |||
| Creating a new workbook. | Excel Programming | |||
Threaded Mode
