I want my excel spreadsheet to be able to open a file that is saved on OneDrive, then add some information to the next available line, save and close. I think I could figure it out if I got help with opening the file that is saved on OneDrive. Does anyone know how to do that part?
Last edited by manofcheese; 06-18-2014 at 09:23 PM.
I don't know what OneDrive is, but this should do it.
Please Login or Register to view this content.
Acts 4:12
Salvation is found in no one else, for there is no other name under heaven given to mankind by which we must be saved.
OneDrive is Microsoft's cloud drive. The problem I am having is getting the file path since it is saved online.
So I tried out your code with another filepath because I think I can get it to work with my needs but it comes up with an error halfway through running it. If I press ok then it works fine but is there a way I can have it press ok for me? Here is the picture. Error Message.PNG
I just found out how. Here is your code with just a few changes. It works greatPlease Login or Register to view this content.
P.S. You can get the filepath if you download OneDrive for your computer. I ended up just using dropbox. I know I will have to change the filepath for each computer I put this on but I am okay with this solution.
Very good. FYI, if the last 2 lines in the subroutine were somewhere in the middle, they would serve a purpose. At the end, not really needed.
is it possible to open the onedrive file using a link instead of syncing the onedrive folder to your local machine?
tamparay welcome to the forum
Unfortunately your post does not comply with Rule 4 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks