Jun 21 2020 03:55 PM
I mean... Is this possible?
If we can import using Query... Can we sort of export, or insert if you prefer, data (from a form for example) to a file located in the cloud (more specifically SharePoint) using VBA?
That would be pretty cool, wouldn't it?
Jun 26 2020 05:21 PM
Jun 27 2020 09:22 PM
Jun 29 2020 04:47 AM
@mgouveia I think I have a similar project going on and still learning how to deal with VBA to manipulate Sharepoint in the cloud. If I have a drive mapped to the Sharepoint site I can do all the things I want but if not, I have problems with creating folders and files and such. That said, if you are looking at creating/using a form to add data to a sheet on Sharepoint, have you looked at Microsoft Forms?
Jun 29 2020 06:26 AM
Hi @mgouveia
Are your trying to create SharePoint List from your desktop file to SharePoint ?
I would recommend you keeping the file on the SharePoint which is much safe & you can even manage the version history of your file without losing the data.
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more
Jun 29 2020 07:30 AM
Jun 29 2020 07:40 AM
Jun 29 2020 09:29 AM
Solution@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.
Jun 29 2020 11:59 AM
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 @Faraz Shaikh for your time.
Jun 29 2020 09:29 AM
Solution@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.