Yepp. No OLE-Automation from VFP x64 to any 32Bit product. And no admin would install the Office x64 version, since it even states in the setup, that you should use that x64 only if you have really, really, really big XLSX files etc. Bigger than 2 Gb. And it also states that Com/OLE problems.
https://support.office.com/en-us/article/choose-between-the-64-bit-or-32-bit...
You can check the version of your installed office somewhere under File / Options
wOOdy
-----Ursprüngliche Nachricht----- Von: ProFox profox-bounces@leafe.com Im Auftrag von MB Software Solutions, LLC Gesendet: Freitag, 17. April 2020 15:21 An: profox@leafe.com Betreff: Office automation using VFP 10 64-bit version
(Renamed subject for this specific question for easier archive searching later in life...)
wOOdy -- Charlie had responded to your answer on my 64-bit thread. What do you think?
On 4/16/2020 2:50 PM, Charlie Coleman wrote:
Quick question. Are you all saying there is no Automation available to MS Office products in the 64-bit world?
I recently wrote a quick VFP app to 'automate' Outlook (ref: createobject('outlook.application')) to generate and send a bunch of emails. The Outlook 365 was 64-bit (I think). Are you saying I would not have been able to do that if I would have used the 'VFP 10' runtimes, etc? I understand ActiveX/FLLs that were compiled 32-bit would be an issue - if they did not have a 64-bit version included.
-Charlie
On Thu, Apr 16, 2020 at 1:30 PM MB Software Solutions, LLC < mbsoftwaresolutions@mbsoftwaresolutions.com> wrote:
Ah yes, the automation angle. Temporarily forgot about that. Thanks, wOOdy!
On 4/16/2020 1:24 PM, Jürgen Wondzinski wrote:
You are correct, there is no reason to have a 64bit FoxPro application
for a regular Desktop app. It is different for building the middle-tier of a distributed app or a Webserver extension. But on a regular desktop you gain nothing, but inherit a lot of problems: No support for regular 32bit ActiveX or FLL components. No COM-control of Office or other 32Bit stuff.
Thus you better use the 32Bit version of VFPA, which is really highly
recommended, since it cures a lot of old bugs.
wOOdy
-----Ursprüngliche Nachricht----- Von: ProFox profox-bounces@leafe.com Im Auftrag von MB Software
Solutions, LLC
Gesendet: Donnerstag, 16. April 2020 17:28 An: ProFox Email List profox@leafe.com Betreff: 64-bit app via the Chen version
I finally I downloaded the VFPA runtime files and am going to use that
IDE and develop/deploy with this "VFP 10" version since many here have spoken of it without much negativity.
Question: what would be the benefit of using the 64-bit version IF I'M
NOT USING DBFS (because in my MBSS apps, I use MariaDB/MySQL as the backend, not VFP). I just don't see the benefit other than for marketing my apps to say "they're 64-bit using the VC++ 10 runtimes."
tia, --Mike
-- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus
[excessive quoting removed by server]