Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening .XLS In VBA: Getting "Do You Want To Save..." Prompt...
-----------------------------------------------------------------
Dim myExcel As Excel.Application Set myExcel = CreateObject("Excel.Application") myExcel.Workbooks.Open myPath, UpdateLinks:=False, ReadOnly:=True .. .. .. (MS Access VBA scrapes data from various worksheets) .. .. set myExcel = Nothing ---------------------------------------------------------------- But I keep getting a "Do you want to save changes...." prompt. What am I missing? -- PeteCresswell |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening .XLS In VBA: Getting "Do You Want To Save..." Prompt...
What am I missing? Sorry for trashing the NG... I think I found the obvious: 2990 With mySS 2991 .Application.DisplayAlerts = False 2992 .Workbooks(1).Close 2993 .Quit 2994 .Application.DisplayAlerts = True 2999 End With |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening .XLS In VBA: Getting "Do You Want To Save..." Prompt...
Or
myss.workbooks(1).close savechanges:=false And you shouldn't see the prompt. PeteCresswell wrote: What am I missing? Sorry for trashing the NG... I think I found the obvious: 2990 With mySS 2991 .Application.DisplayAlerts = False 2992 .Workbooks(1).Close 2993 .Quit 2994 .Application.DisplayAlerts = True 2999 End With -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening .XLS In VBA: Getting "Do You Want To Save..." Prompt...
Per Dave Peterson:
Or myss.workbooks(1).close savechanges:=false And you shouldn't see the prompt. Thanks... that cleaned up my code by a few lines.... and maybe whoever looks at it will actually think I know what I'm doing.... -) -- PeteCresswell |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bypass "Save PDF File As" Prompt via VBA in Excel | Excel Programming | |||
is it possible to disable "save" prompt in excel file on web server? | Excel Discussion (Misc queries) | |||
Disallow "SAVE" only "SAVE AS" or prompt | Setting up and Configuration of Excel | |||
The "i" prompt when opening a worksheet containing links | Excel Programming | |||
How can I get "File Close" to prompt me to "Save Changes" ?? | Excel Programming |