UtterAccess.com
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
> VBA Code To Link Sharepoint Excel File To Access, Access 2016    
 
   
mantral
post Feb 23 2018, 08:25 PM
Post#1



Posts: 156
Joined: 30-January 10
From: So Cal


Good Afternoon and Greetings,

Is it possible to use Access VBA, click and link to an Excel file in a SharePoint document library to a Access database?

How would you go about doing this?

Thank you in advance.
Go to the top of the page
 
theDBguy
post Feb 23 2018, 09:35 PM
Post#2


Access Wiki and Forums Moderator
Posts: 73,914
Joined: 19-June 07
From: SunnySandyEggo


Hi,

It depends,. Are you talking about an on-premise SharePoint or Office365? If the former, then maybe. But if the latter, maybe not.
Go to the top of the page
 
mantral
post Feb 23 2018, 10:11 PM
Post#3



Posts: 156
Joined: 30-January 10
From: So Cal


Thank you for the quick response.

Nice to see that "theDBguy" is still active.

It is an intranet / on Premise SharePoint document library.
Will this work?
Go to the top of the page
 
theDBguy
post Feb 23 2018, 10:17 PM
Post#4


Access Wiki and Forums Moderator
Posts: 73,914
Joined: 19-June 07
From: SunnySandyEggo


There may be a way using WebDAV. If you can map a drive letter pointing to the Document Library, then you should be able to link to the Excel file using Access.
Go to the top of the page
 
mantral
post Feb 23 2018, 10:30 PM
Post#5



Posts: 156
Joined: 30-January 10
From: So Cal


Hi theDBGuy,

I am not very familiar with WEBDAV.

Do I have to map the drive when I have the URL link already?

Can't I use the URL link to link the Excel file?

Or how about downloading the Excel file to a local folder and link it from there
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    9th December 2018 - 02:21 PM