No New Workbook Annoyance
- From: Stephen <Issenec@xxxxxxxxx>
- Date: Wed, 14 Jan 2009 08:59:08 -0800 (PST)
Hello,
I have this problem where after running my macro, Excel no longer
loads a new workbook automatically; the user has to either press Ctrl
+N or go to File->New... It's a minor annoyance, but I was hoping to
have my macro not need the user to do this everytime they open up
Excel. The macro code is shown below:
Sub AutoExec()
Dim file_Check As Object
Set file_Check = CreateObject("Scripting.FileSystemObject")
If file_Check.FileExists(Selection.Application.Path & "\XLSTART
\Excel2Wiki.xls") = False Then
ActiveWorkbook.SaveAs Filename:=Selection.Application.Path &
"\XLSTART\Excel2Wiki.xls", FileFormat:=xlNormal
Call DeleteMenus
Call CreateMenus
ActiveWindow.Visible = False
Application.Quit
End If
End Sub
Before running this, Excel automatically loads a new workbook. After
deleting the *.xls from the XLSTART folder, Excel is restored to
loading a new workbook. However, when the *.xls is in the XLSTART, it
is hidden, but Excel doesn't automatically load a new workbook. If
anybody can explain the cause and/or the solution, that would be
great. Thanks.
.
- Follow-Ups:
- Re: No New Workbook Annoyance
- From: Stephen
- Re: No New Workbook Annoyance
- Prev by Date: Re: Grouping Multiple Side by Side Columns
- Next by Date: Need to change the name that appears when inserting comments?
- Previous by thread: Grouping Multiple Side by Side Columns
- Next by thread: Re: No New Workbook Annoyance
- Index(es):
Relevant Pages
|
