onedrive

My code opens another file on Onedrive, do stuff and save it. It is something like this: Code: Dim xl0 As New Excel.Application Dim xlw As New Excel.Workbook Set xlw = xl0.Workbooks.Open("https://d.docs.live.net/679d4848dd/Something.xlsx") 'DO STUFF xlw.Save xlw.Close Set xl0 =...

Hi folks. This is my first post and it looks like this forum will be very useful. I have a workbook (Excel 2016) that is stored in MS Onedrive. I need the workbook to be auto saved (to Onedrive) one a regular basis, say every 30 min. How can I do this?

Hi, I feel like I've done quite a bit of research to not have found an answer to this - please help! Using Office 2013 Background: I work for a company that has about 20 facilities with an employee at each that performs general data entry multiple times per week for about 300 items each time...

Hi Guys, I have created a Workbook which is due to be used by ~100 users. Each user will have their own copy of this Workbook, which contains a Userform which allows them to update/add/remove a selection of records (these records are just rows in a worksheet which sits behind the Userform)...

I have macro that creates an invoice from a job card entry, prints the invoice, clears the job card for the next job and saves the file. This macro was working fine with XP and Excel 2007, but a recent 'upgrade' to Win 8.1 and Excel 2013 has resulted in a lengthy delay to the macro, while it...

Hello, I have created a database in excel with multiple sheets with various functions and stored on OneDrive which allows others to see it. What I require is for it to show the Time and Date it was last saved in a particular cell in a worksheet. I have done various searchers across the net...