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,269
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.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
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,269
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.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
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    25th September 2018 - 05:59 AM