Hi,
I've got an old VFP app that uses Word 2007 to do a mail merge using automation. The client has now moved to Office 365 and of course this breaks the automation. I am seeing some evidence that if the 32 bit of Office 365 is installed locally then the automation should work.
Office 365 and OLE Word Merge in Visual Foxpro Application (microsoft.com) https://social.msdn.microsoft.com/Forums/en-US/496b97f2-239b-4981-b7c5-88192d5b18eb/office-365-and-ole-word-merge-in-visual-foxpro-application?forum=visualfoxprogeneral
Has anyone actually got this to work?
If not, what alternatives are there for generating Word documents from VFP?
There's no reason why it wouldn't still work as long as you are using 32-bit Office. It's not the version, it's the bitness.
365 installs the 64-bit version of the applications by default now, which is annoying if you have Excel plugins, for example, or need to automate them from a 32-bit process.
Thanks, have you got it working?
I've asked them to uninstall the 64bit and try with the 32bit. Will report back what happens.
Frank.
Frank Cazabon
On 15/01/2021 10:53 am, Alan Bourke wrote:
There's no reason why it wouldn't still work as long as you are using 32-bit Office. It's not the version, it's the bitness.
365 installs the 64-bit version of the applications by default now, which is annoying if you have Excel plugins, for example, or need to automate them from a 32-bit process.
No I've never done it but have done plenty of Excel automation.
Yes. But installing the full 32 bit desktop version is a requirement. Works fine for Word, Excel and Outlook.
--
rk
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Frank Cazabon Sent: Friday, January 15, 2021 9:59 AM To: profoxtech@leafe.com Subject: Re: Automation & Office 365
Thanks, have you got it working?
I've asked them to uninstall the 64bit and try with the 32bit. Will report back what happens.
Frank.
Frank Cazabon
On 15/01/2021 10:53 am, Alan Bourke wrote:
There's no reason why it wouldn't still work as long as you are using 32-bit Office. It's not the version, it's the bitness.
365 installs the 64-bit version of the applications by default now, which is annoying if you have Excel plugins, for example, or need to automate them from a 32-bit process.
OK, great to hear it works. Hopefully their testing will be successful.
Thanks
Frank.
Frank Cazabon
On 15/01/2021 11:04 am, Richard Kaye wrote:
Yes. But installing the full 32 bit desktop version is a requirement. Works fine for Word, Excel and Outlook.
--
rk
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Frank Cazabon Sent: Friday, January 15, 2021 9:59 AM To: profoxtech@leafe.com Subject: Re: Automation & Office 365
Thanks, have you got it working?
I've asked them to uninstall the 64bit and try with the 32bit. Will report back what happens.
Frank.
Frank Cazabon
On 15/01/2021 10:53 am, Alan Bourke wrote:
There's no reason why it wouldn't still work as long as you are using 32-bit Office. It's not the version, it's the bitness.
365 installs the 64-bit version of the applications by default now, which is annoying if you have Excel plugins, for example, or need to automate them from a 32-bit process.
[excessive quoting removed by server]
I saw this: https://support.microsoft.com/en-us/office/choose-between-the-64-bit-or-32-b...
It lists the reason why you would choose 64/32 bit versions. I had to use this when we got newer Office and older SharePoint stuff no longer worked the same way. Editing in a data sheet instead of the list in SP.
On Fri, Jan 15, 2021 at 9:05 AM Richard Kaye rkaye@invaluable.com wrote:
Yes. But installing the full 32 bit desktop version is a requirement. Works fine for Word, Excel and Outlook.
--
rk
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Frank Cazabon Sent: Friday, January 15, 2021 9:59 AM To: profoxtech@leafe.com Subject: Re: Automation & Office 365
Thanks, have you got it working?
I've asked them to uninstall the 64bit and try with the 32bit. Will report back what happens.
Frank.
Frank Cazabon
On 15/01/2021 10:53 am, Alan Bourke wrote:
There's no reason why it wouldn't still work as long as you are using
32-bit Office. It's not the version, it's the bitness.
365 installs the 64-bit version of the applications by default now,
which is annoying if you have Excel plugins, for example, or need to automate them from a 32-bit process.
[excessive quoting removed by server]
Thanks, that's the link I put in the original post :)
Frank.
Frank Cazabon
On 15/01/2021 11:38 am, Stephen Russell wrote:
I saw this: https://support.microsoft.com/en-us/office/choose-between-the-64-bit-or-32-b...
It lists the reason why you would choose 64/32 bit versions. I had to use this when we got newer Office and older SharePoint stuff no longer worked the same way. Editing in a data sheet instead of the list in SP.
On Fri, Jan 15, 2021 at 9:05 AM Richard Kaye rkaye@invaluable.com wrote:
Yes. But installing the full 32 bit desktop version is a requirement. Works fine for Word, Excel and Outlook.
--
rk
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Frank Cazabon Sent: Friday, January 15, 2021 9:59 AM To: profoxtech@leafe.com Subject: Re: Automation & Office 365
Thanks, have you got it working?
I've asked them to uninstall the 64bit and try with the 32bit. Will report back what happens.
Frank.
Frank Cazabon
On 15/01/2021 10:53 am, Alan Bourke wrote:
There's no reason why it wouldn't still work as long as you are using
32-bit Office. It's not the version, it's the bitness.
365 installs the 64-bit version of the applications by default now,
which is annoying if you have Excel plugins, for example, or need to automate them from a 32-bit process.
[excessive quoting removed by server]
-
Alan Bourke -
Frank Cazabon -
Richard Kaye -
Stephen Russell