Hi guys!
Is there a way to read a shared text file hosted on my OneDrive cloud account?
Is there another cloud service that allows this?
I've tried something like:
but I get 'Run-time 52: Bad file name or number '
text_file = "https://1drv.ms/t/s!AhalvoNcBxGGlFLKQmtqXgx49usM" '' this is the actual link Open text_file For Input As #1 Do Until EOF(1) Line Input #1, textline .InsertLines LineNum, textline LineNum = .CountOfLines + 1 Loop Close #1
Thanks a bunch!!
.. and don't forget to have fun!
Bogdan.
mark SOLVED andAdd Reputation if my answer pleases you
Hi bulina2k,
You can do what you want, but you first have to map OneDrive to as a Network Drive on your computer. You probably need Administrator privileges. I was successful doing this in Windows 8.1. Each operating system is slightly different. Windows 8.1 might not allow you to map a 'Shared Area' (It is apparently a OneDrive 'feature').
For Windows 7 or 8.x:
http://www.guidingtech.com/42273/map...network-drive/
For Windows 10:
http://www.laptopmag.com/articles/ma...-network-drive
Unfortunately, this is all my OneDrive knowledge. Good luck.
Lewis
Duplicate post deleted by poster.
Last edited by LJMetzger; 12-12-2016 at 04:01 PM.
Thank you very much for your answer Lewis
I could do what you suggested but I need to share this file read-only on another (not personal) computer.
I would like that VBA from foreign computers access and read from that file.
I there a way to share/map a folder readonly?
Thanks again!
I have no experience with doing what you want.
One Drive can share files read only: https://support.office.com/en-us/art...ad=US&fromAR=1
The above option probably does not let you access the file from VBA unless you can map the file into a path and file name readable on the computer that wants to access the file (Windows computer or other computer).
I'm sorry I wasn't able to help more.
Lewis
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks