Re: Office (Excel) automation with Office365

On Sun, 27 Aug 2017, at 04:15 PM, mbsoftwaresolutions@mbsoftwaresolutions.com wrote: VFP9SP2

Anybody doing VFP/Excel automation coding with Office365? Looks like you get Office 2016 with that subscription. I don't see why it WOULDN'T work but I wanted to check with the forum first before purchasing a subscription.

We have a lot of automation code, some of it 15 years old. All continues to work, as long as each workstation has 32-bit Office installed on their machine. O365 has a 'cloud' option, which is hosted web-based office, which you'll want to avoid, and 64-bit, which offers no noticeable advantage for the majority of users, but will screw up 32-bit automation and ODBC.