X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> How To Turn Off Prompts To Save As When Updating Xlsx On Sharepoint, Access 2016    
post Nov 24 2017, 01:00 PM

Posts: 848
Joined: 26-March 02
From: St.Louis, MO, USA

I use Access VBA to refresh and save an Excel file stored in SharePoint.
This has always worked without prompts on Office 2010 to open, refresh and save.
Since we upgraded to Office 2016, when running the module I now get 3 separate prompts to: "Save As", "File exists Do you want to replace?" and to "Choose Content type"
The VBA has not changed and neither has our SharePoint installation so I assume there is some option in the new Office\Excel I need to change that I am overlooking.

Any ideas?

Here is what I am doing to open, refresh and save the Excel file located in SharePoint:
DoCmd.SetWarnings False
Dim xlApp As Object
Dim xlBook As Object
Dim xlSheet As Object
Set xlApp = CreateObject("Excel.Application")
xlApp.DisplayAlerts = False
Set xlBook = xlApp.Workbooks.Open("\\collaborationtools.MyCompany.net\sites\MySite\Shared Documents\Reporting\MyFile.xlsx")
xlBook.Close True
xlApp.DisplayAlerts = True
DoCmd.SetWarnings True
Go to the top of the page
post Dec 1 2017, 07:39 AM

Posts: 786
Joined: 25-April 14

Application.DisplayAlerts = False
is the answer. But you already have it.
Go to the top of the page
post Dec 1 2017, 03:07 PM

Posts: 848
Joined: 26-March 02
From: St.Louis, MO, USA

Right...that's why I'm wondering why the pop up messages. I'm assuming they are driven through SharePoint and not the excel app which is maybe why it is being ignored?
Again, this just started when we upgraded to Office 2016.
I was thinking their were some settings in excel I could turn off but not found anything relevant.
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    14th December 2017 - 10:18 AM