How to get all users name from sharepoint excel file without opening and add to dropdown in excel file

M

m_vishal_c

Board Regular
Joined
Dec 7, 2016
Messages
209
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
HI

I do have 1 excel file on sharepoint. I just need to get all users name from that sharepoint excel file and add to dropdown in excel file which is on my computer.

I need to get all users name in dropdown when we open excel file which is located to local machine (computer)

I hope I could explain better.

Please let me know how it can be possible by vba
Heaps thanks in advance
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
You must log in or register to reply here.

Similar threads

M
  • Question
Share excel file on Sharepoint using VBA
Replies
1
Views
111
mariyarashkova
M
T
  • Question
How do you populate a list of Sharepoint Files in A combobox
Replies
0
Views
294
thardin
T
Skybluekid
  • Question
Check if Sharepoint Column exists, if add
Replies
0
Views
114
Skybluekid
Skybluekid
E
  • Question
Excel VBA to Outlook Email Draft - How to save email draft copy to sharepoint / How to use template from sharepoint?
Replies
0
Views
288
elitef
E
M
  • Question
Macro - Merge all files into one sheet
Replies
2
Views
230
MountainFog
M

Forum statistics

Threads
1,214,911
Messages
6,122,198
Members
449,072
Latest member
DW Draft

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top