Thought this might be of some interest to those who have not done it. Note: It applies to OneDrive of W10 and as all my Toshibas are W10 (including the big update in later November) I have no idea about 7 or 8.1
Firstly Excel and OneDrive are put on the iPhone. The Excel file or files are put in the computers OneDrive folder. In my case as I imagine would be the only useful way, the Excel files are created from the Access file, that is tables where data would be changed etc.
If you make a change in Excel on OneDrive it will appear straight away on Excel on the phone. Change an Excel entry on the iPhone and Excel on OneDrive changes.
In my case I have all the basic VBA made so Access will open the Excel file and then a macro on Excel will send the appropriate cell values to the appropriate Access fields. I also have the reverse where Access fields will go to the appropriate Excel cells.
Everything is the same with Word.
Also of note is OneDrive on all the computers will change and if Excel on OneDrive is changed on any of the computers it will change on the phone.
I assume all of the above would work on Android phones and the various tablets.
As a side note with the iPhone 6 Plus when you turn it on its side and everything is landscape and after doing a fair bit of typing (experimenting with Word) you become quite proficient at typing on the phone.
As I said it might be of interest to some and perhaps there are others who have done similar but taken things to a higher degree.
One thing that does not seem to work with OneDrive is putting an Access file in OneDrive and hence they would be networked. Basically it all fouls itself up.
Also I am using Access 2016 and from Office 365 and the Access files are .mdb but I don't think any of that would matter.
Firstly Excel and OneDrive are put on the iPhone. The Excel file or files are put in the computers OneDrive folder. In my case as I imagine would be the only useful way, the Excel files are created from the Access file, that is tables where data would be changed etc.
If you make a change in Excel on OneDrive it will appear straight away on Excel on the phone. Change an Excel entry on the iPhone and Excel on OneDrive changes.
In my case I have all the basic VBA made so Access will open the Excel file and then a macro on Excel will send the appropriate cell values to the appropriate Access fields. I also have the reverse where Access fields will go to the appropriate Excel cells.
Everything is the same with Word.
Also of note is OneDrive on all the computers will change and if Excel on OneDrive is changed on any of the computers it will change on the phone.
I assume all of the above would work on Android phones and the various tablets.
As a side note with the iPhone 6 Plus when you turn it on its side and everything is landscape and after doing a fair bit of typing (experimenting with Word) you become quite proficient at typing on the phone.
As I said it might be of interest to some and perhaps there are others who have done similar but taken things to a higher degree.
One thing that does not seem to work with OneDrive is putting an Access file in OneDrive and hence they would be networked. Basically it all fouls itself up.
Also I am using Access 2016 and from Office 365 and the Access files are .mdb but I don't think any of that would matter.