Automation & Office 365

2021-01-15 Thread Frank Cazabon
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 an

Re: Automation & Office 365

2021-01-15 Thread Alan Bourke
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 proce

Re: Automation & Office 365

2021-01-15 Thread Frank Cazabon
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 v

Re: Automation & Office 365

2021-01-15 Thread Alan Bourke
No I've never done it but have done plenty of Excel automation. -- Alan Bourke alanpbourke (at) fastmail (dot) fm ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of thi

RE: Automation & Office 365

2021-01-15 Thread Richard Kaye
Yes. But installing the full 32 bit desktop version is a requirement. Works fine for Word, Excel and Outlook. -- rk -Original Message- From: ProfoxTech On Behalf Of Frank Cazabon Sent: Friday, January 15, 2021 9:59 AM To: profoxt...@leafe.com Subject: Re: Automation & Office 365 Than

Re: Automation & Office 365

2021-01-15 Thread Frank Cazabon
thanks Frank. Frank Cazabon On 15/01/2021 11:02 am, Alan Bourke wrote: No I've never done it but have done plenty of Excel automation. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox

Re: Automation & Office 365

2021-01-15 Thread Frank Cazabon
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- F

Re: Automation & Office 365

2021-01-15 Thread Stephen Russell
I saw this: https://support.microsoft.com/en-us/office/choose-between-the-64-bit-or-32-bit-version-of-office-2dee7807-8f95-4d0c-b5fe-6c6f49b8d261 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

Re: Automation & Office 365

2021-01-15 Thread Frank Cazabon
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-bit-version-of-office-2dee7807-8f95-4d0c-b5fe-6c6f49b8d261 It lists the reason why y

Setting Class Libraries

2021-01-15 Thread Philip Borkholder
Hi all, Quick question that I can't remember the hierarchy. Situation: Running a VFP App compiled in an EXE. This EXE has a VCX class library file compiled into it that the author used. If I have a newer version of the VCX that performs some of the methods cleaner/faster than the one the author

Re: Setting Class Libraries

2021-01-15 Thread Frank Cazabon
What is in the exe will be used Frank. Frank Cazabon On 15/01/2021 1:03 pm, Philip Borkholder wrote: Hi all, Quick question that I can't remember the hierarchy. Situation: Running a VFP App compiled in an EXE. This EXE has a VCX class library file compiled into it that the author used. If I

Re: Setting Class Libraries

2021-01-15 Thread Philip Borkholder
Thanks Frank, Second question. What if I set CLASSLIBRARY TO mynewerclass.vcx ADDITIVE IN a hook provided by the author after the EXE starts? Thanks Philip -- Original Message -- From: Frank Cazabon To: profoxt...@leafe.com Subject: Re: Setting Class Libraries Date: Fri, 15 Jan

Re: Setting Class Libraries

2021-01-15 Thread Frank Cazabon
I guess that might work depending on if your class is the same name as in other classes included in the exe and with a set classlib to earlier in the code. Frank. Frank Cazabon On 15/01/2021 2:41 pm, Philip Borkholder wrote: Thanks Frank, Second question. What if I set CLASSLIBRARY TO mynew