Forum Discussion
VBA to insert data in an excel file located in sharepoint
mgouveia it is possible to map a network drive to a sharepoint folder but you have to use internet explorer to make that site a trusted site. it isn't a great way to do things if you have multiple people accessing the sheet, which is likely if you need to have the sheet in sharepoint in the first place.
There is also powerapps which I'm trying to learn and work with to see if I can use that to do something using that tool, but will watch this topic to see if someone else chimes in with more info.
mgouveia it is possible to map a network drive to a sharepoint folder but you have to use internet explorer to make that site a trusted site. it isn't a great way to do things if you have multiple people accessing the sheet, which is likely if you need to have the sheet in sharepoint in the first place.
There is also powerapps which I'm trying to learn and work with to see if I can use that to do something using that tool, but will watch this topic to see if someone else chimes in with more info.
I guess PowerApps might be the best workaround unfortunately (I mean, I already use excel and having to start using a completely new tool is a little challenging), but we will see if anybody has a better solution...
Thankyou mtarler and ExcelExciting for your time.