RE: Office automation using VFP 10 64-bit version
Depends on what and why the data is being returned. I was just giving an example. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Tuesday, April 21, 2020 5:13 PM To: profoxt...@leafe.com Subject: Re: Office automation using VFP 10 64-bit version Consider making the root of the XLM object singular, such as Customer with List as an element of it? On Tue, Apr 21, 2020 at 3:15 PM Tracy Pearson wrote: > For what I have been working on, it has been an Xml string that I can > process to and from a cursor with the XmlAdapter. > In C# I can process it to and from a List. > The XmlAdapter will nest related tables such as Orders and OrderItems and > bring that back to VFP cursors from the Xml string that is returned. > In C# it would be a List and has a List as one of the > properties. > > You have more functions available to you in the COM object then the VFP > OleDB Provider. > > -Original Message- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB > Software Solutions, LLC > Sent: Tuesday, April 21, 2020 3:47 PM > To: profoxt...@leafe.com > Subject: Re: Office automation using VFP 10 64-bit version > > What's the return type? An object with all of the properties? I'm sure > you're not returning single values for everything. > > > On 4/21/2020 11:23 AM, Tracy Pearson wrote: > > It could, but I just call methods in the COM object to get data. > > > > -Original Message- > > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB > > Software Solutions, LLC > > Sent: Tuesday, April 21, 2020 11:11 AM > > To: profoxt...@leafe.com > > Subject: Re: Office automation using VFP 10 64-bit version > > > > So the front end C# appit's referring to the VFP COM object > > properties in its UI? > > > > > > On 4/21/2020 11:04 AM, Tracy Pearson wrote: > >> You can write a VFP COM object that holds the business logic, and data > >> access, if you are still using VFP Tables and update the UI with a > 64-bit > >> WPF application. Or a Web project that accesses the VFP data of a VFP > >> desktop application. > >> The VFP COM object could call code in the VFP Desktop application. > >> > >> > >> -----Original Message----- > >> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB > >> Software Solutions, LLC > >> Sent: Tuesday, April 21, 2020 10:53 AM > >> To: profoxt...@leafe.com > >> Subject: Re: Office automation using VFP 10 64-bit version > >> > >> On 4/20/2020 9:15 AM, Tracy Pearson wrote: > >>> You are able to use an OUT of process COM across the 64-bit & 32-bit > >>> barrier. I showed this in my 2019 SWFox session. > >>> > >>> I was working with a 64-bit C# and accessing a VFP 9 SP 2 COM compiled > as > >> an > >>> EXE. > >>> Fun stuff. > >> What's the benefit to that? > >> > >> > > -- > This email has been checked for viruses by Avast antivirus software. > https://www.avast.com/antivirus > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/01d61823$2d754370$885fca50$@powerchurch.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Office automation using VFP 10 64-bit version
Consider making the root of the XLM object singular, such as Customer with List as an element of it? On Tue, Apr 21, 2020 at 3:15 PM Tracy Pearson wrote: > For what I have been working on, it has been an Xml string that I can > process to and from a cursor with the XmlAdapter. > In C# I can process it to and from a List. > The XmlAdapter will nest related tables such as Orders and OrderItems and > bring that back to VFP cursors from the Xml string that is returned. > In C# it would be a List and has a List as one of the > properties. > > You have more functions available to you in the COM object then the VFP > OleDB Provider. > > -Original Message- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB > Software Solutions, LLC > Sent: Tuesday, April 21, 2020 3:47 PM > To: profoxt...@leafe.com > Subject: Re: Office automation using VFP 10 64-bit version > > What's the return type? An object with all of the properties? I'm sure > you're not returning single values for everything. > > > On 4/21/2020 11:23 AM, Tracy Pearson wrote: > > It could, but I just call methods in the COM object to get data. > > > > -Original Message- > > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB > > Software Solutions, LLC > > Sent: Tuesday, April 21, 2020 11:11 AM > > To: profoxt...@leafe.com > > Subject: Re: Office automation using VFP 10 64-bit version > > > > So the front end C# appit's referring to the VFP COM object > > properties in its UI? > > > > > > On 4/21/2020 11:04 AM, Tracy Pearson wrote: > >> You can write a VFP COM object that holds the business logic, and data > >> access, if you are still using VFP Tables and update the UI with a > 64-bit > >> WPF application. Or a Web project that accesses the VFP data of a VFP > >> desktop application. > >> The VFP COM object could call code in the VFP Desktop application. > >> > >> > >> -----Original Message----- > >> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB > >> Software Solutions, LLC > >> Sent: Tuesday, April 21, 2020 10:53 AM > >> To: profoxt...@leafe.com > >> Subject: Re: Office automation using VFP 10 64-bit version > >> > >> On 4/20/2020 9:15 AM, Tracy Pearson wrote: > >>> You are able to use an OUT of process COM across the 64-bit & 32-bit > >>> barrier. I showed this in my 2019 SWFox session. > >>> > >>> I was working with a 64-bit C# and accessing a VFP 9 SP 2 COM compiled > as > >> an > >>> EXE. > >>> Fun stuff. > >> What's the benefit to that? > >> > >> > > -- > This email has been checked for viruses by Avast antivirus software. > https://www.avast.com/antivirus > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/CAJidMY+G6Z8LRSfZZ_T2VQjwRgMB_J2dSRCdOWbHVetJc=o...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Office automation using VFP 10 64-bit version
For what I have been working on, it has been an Xml string that I can process to and from a cursor with the XmlAdapter. In C# I can process it to and from a List. The XmlAdapter will nest related tables such as Orders and OrderItems and bring that back to VFP cursors from the Xml string that is returned. In C# it would be a List and has a List as one of the properties. You have more functions available to you in the COM object then the VFP OleDB Provider. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Tuesday, April 21, 2020 3:47 PM To: profoxt...@leafe.com Subject: Re: Office automation using VFP 10 64-bit version What's the return type? An object with all of the properties? I'm sure you're not returning single values for everything. On 4/21/2020 11:23 AM, Tracy Pearson wrote: > It could, but I just call methods in the COM object to get data. > > -Original Message- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB > Software Solutions, LLC > Sent: Tuesday, April 21, 2020 11:11 AM > To: profoxt...@leafe.com > Subject: Re: Office automation using VFP 10 64-bit version > > So the front end C# appit's referring to the VFP COM object > properties in its UI? > > > On 4/21/2020 11:04 AM, Tracy Pearson wrote: >> You can write a VFP COM object that holds the business logic, and data >> access, if you are still using VFP Tables and update the UI with a 64-bit >> WPF application. Or a Web project that accesses the VFP data of a VFP >> desktop application. >> The VFP COM object could call code in the VFP Desktop application. >> >> >> -Original Message- >> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB >> Software Solutions, LLC >> Sent: Tuesday, April 21, 2020 10:53 AM >> To: profoxt...@leafe.com >> Subject: Re: Office automation using VFP 10 64-bit version >> >> On 4/20/2020 9:15 AM, Tracy Pearson wrote: >>> You are able to use an OUT of process COM across the 64-bit & 32-bit >>> barrier. I showed this in my 2019 SWFox session. >>> >>> I was working with a 64-bit C# and accessing a VFP 9 SP 2 COM compiled as >> an >>> EXE. >>> Fun stuff. >> What's the benefit to that? >> >> -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/000801d61819$a8a39470$f9eabd50$@powerchurch.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Office automation using VFP 10 64-bit version
LMAO!! #BadSteve On 4/21/2020 11:51 AM, Stephen Russell wrote: You can now do this I bet. https://www.youtube.com/watch?time_continue=522=j0ng2Tp01Hc=emb_title On Tue, Apr 21, 2020 at 9:54 AM MB Software Solutions, LLC < mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: On 4/20/2020 9:15 AM, Tracy Pearson wrote: You are able to use an OUT of process COM across the 64-bit & 32-bit barrier. I showed this in my 2019 SWFox session. I was working with a 64-bit C# and accessing a VFP 9 SP 2 COM compiled as an EXE. Fun stuff. What's the benefit to that? -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/953f46c5-f69c-32f8-4285-058223d45...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Office automation using VFP 10 64-bit version
What's the return type? An object with all of the properties? I'm sure you're not returning single values for everything. On 4/21/2020 11:23 AM, Tracy Pearson wrote: It could, but I just call methods in the COM object to get data. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Tuesday, April 21, 2020 11:11 AM To: profoxt...@leafe.com Subject: Re: Office automation using VFP 10 64-bit version So the front end C# appit's referring to the VFP COM object properties in its UI? On 4/21/2020 11:04 AM, Tracy Pearson wrote: You can write a VFP COM object that holds the business logic, and data access, if you are still using VFP Tables and update the UI with a 64-bit WPF application. Or a Web project that accesses the VFP data of a VFP desktop application. The VFP COM object could call code in the VFP Desktop application. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Tuesday, April 21, 2020 10:53 AM To: profoxt...@leafe.com Subject: Re: Office automation using VFP 10 64-bit version On 4/20/2020 9:15 AM, Tracy Pearson wrote: You are able to use an OUT of process COM across the 64-bit & 32-bit barrier. I showed this in my 2019 SWFox session. I was working with a 64-bit C# and accessing a VFP 9 SP 2 COM compiled as an EXE. Fun stuff. What's the benefit to that? -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/97550470-3892-b27b-667b-ff3710bf9...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Office automation using VFP 10 64-bit version
You can now do this I bet. https://www.youtube.com/watch?time_continue=522=j0ng2Tp01Hc=emb_title On Tue, Apr 21, 2020 at 9:54 AM MB Software Solutions, LLC < mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: > On 4/20/2020 9:15 AM, Tracy Pearson wrote: > > You are able to use an OUT of process COM across the 64-bit & 32-bit > > barrier. I showed this in my 2019 SWFox session. > > > > I was working with a 64-bit C# and accessing a VFP 9 SP 2 COM compiled > as an > > EXE. > > Fun stuff. > > > What's the benefit to that? > > > -- > This email has been checked for viruses by Avast antivirus software. > https://www.avast.com/antivirus > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/cajidmyjpfq-e_2rbalgsfqtapthy6vso8xsyuc4tzy83mpa...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Office automation using VFP 10 64-bit version
It could, but I just call methods in the COM object to get data. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Tuesday, April 21, 2020 11:11 AM To: profoxt...@leafe.com Subject: Re: Office automation using VFP 10 64-bit version So the front end C# appit's referring to the VFP COM object properties in its UI? On 4/21/2020 11:04 AM, Tracy Pearson wrote: > You can write a VFP COM object that holds the business logic, and data > access, if you are still using VFP Tables and update the UI with a 64-bit > WPF application. Or a Web project that accesses the VFP data of a VFP > desktop application. > The VFP COM object could call code in the VFP Desktop application. > > > -Original Message- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB > Software Solutions, LLC > Sent: Tuesday, April 21, 2020 10:53 AM > To: profoxt...@leafe.com > Subject: Re: Office automation using VFP 10 64-bit version > > On 4/20/2020 9:15 AM, Tracy Pearson wrote: >> You are able to use an OUT of process COM across the 64-bit & 32-bit >> barrier. I showed this in my 2019 SWFox session. >> >> I was working with a 64-bit C# and accessing a VFP 9 SP 2 COM compiled as > an >> EXE. >> Fun stuff. > > What's the benefit to that? > > -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/000401d617f0$c6136cc0$523a4640$@powerchurch.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Office automation using VFP 10 64-bit version
So the front end C# appit's referring to the VFP COM object properties in its UI? On 4/21/2020 11:04 AM, Tracy Pearson wrote: You can write a VFP COM object that holds the business logic, and data access, if you are still using VFP Tables and update the UI with a 64-bit WPF application. Or a Web project that accesses the VFP data of a VFP desktop application. The VFP COM object could call code in the VFP Desktop application. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Tuesday, April 21, 2020 10:53 AM To: profoxt...@leafe.com Subject: Re: Office automation using VFP 10 64-bit version On 4/20/2020 9:15 AM, Tracy Pearson wrote: You are able to use an OUT of process COM across the 64-bit & 32-bit barrier. I showed this in my 2019 SWFox session. I was working with a 64-bit C# and accessing a VFP 9 SP 2 COM compiled as an EXE. Fun stuff. What's the benefit to that? -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/eef943f1-4f94-bf19-ffd7-36dddcf99...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Office automation using VFP 10 64-bit version
You can write a VFP COM object that holds the business logic, and data access, if you are still using VFP Tables and update the UI with a 64-bit WPF application. Or a Web project that accesses the VFP data of a VFP desktop application. The VFP COM object could call code in the VFP Desktop application. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Tuesday, April 21, 2020 10:53 AM To: profoxt...@leafe.com Subject: Re: Office automation using VFP 10 64-bit version On 4/20/2020 9:15 AM, Tracy Pearson wrote: > You are able to use an OUT of process COM across the 64-bit & 32-bit > barrier. I showed this in my 2019 SWFox session. > > I was working with a 64-bit C# and accessing a VFP 9 SP 2 COM compiled as an > EXE. > Fun stuff. What's the benefit to that? -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/000301d617ee$293eb8c0$7bbc2a40$@powerchurch.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Office automation using VFP 10 64-bit version
On 4/20/2020 9:15 AM, Tracy Pearson wrote: You are able to use an OUT of process COM across the 64-bit & 32-bit barrier. I showed this in my 2019 SWFox session. I was working with a 64-bit C# and accessing a VFP 9 SP 2 COM compiled as an EXE. Fun stuff. What's the benefit to that? -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/8c8b38d4-1956-38de-57a3-43abaacf4...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Office automation using VFP 10 64-bit version
Interesting! I have, AFAIK, the latest Office 365 running on Win 10 1909 and
mine shows Microsoft Outlook for Office
365 MSO (16.0.12624.20422) 32-bit.
Curiouser and curiouser.
John
John Weller
01380 723235
07976 393631
-Original Message-
From: ProfoxTech On Behalf Of Charlie Coleman
Sent: 20 April 2020 12:16
To: profoxt...@leafe.com
Subject: Re: Office automation using VFP 10 64-bit version
- In Outlook, I went to File, then Office Account, then clicked "About Outlook"
- Near the top of the resulting screen I saw "Microsoft Outlook for Office
365 MSO (16.0.11929.20618) 64-bit" (and of course there were "TM"s spread
around in that string).
- Then I went to VFP and opened up the code I had used a while back. The
'basic' design of it is as follows:
oOutlook = CREATEOBJECT('outlook.application')
...
oMsg = oOutlook.CreateItem(0)
oMsg.to =
oMsg.from =
oMsg.subject =
oMsg.htmlbody =
*-- maybe there was another step or two - but you get the gist
*-- then actually sent the message.
oMsg.send()
I did the above this past Friday (4/17/2020) - grabbing out some of that code
and ran lines of it from the VFP command prompt (the actual code would have
sent out about 100 emails for a 'crisis' situation that did not exist so I did
not want to trigger that - heh). But the email I created with the above process
was sent and delivered (to myself at a couple different email addresses I
have). According to the "About" VFP - I am using VFP SP2, version
09.00..5815.
Of course, this was ONLY Outlook. It was not Word, Excel, or Powerpoint.
But it does clearly call itself 64-bit. Now based on MS's past behavior I
certainly do not expect them to be honest. But trying to deceive at this level
would seem a little ridiculous even for them.
I will add that I do not know if we perhaps started with 32-bit Office at one
point and then migrated to 365 64-bit. This particular PC was set up about 11
months ago. And given MS's poor history of cleaning up after itself, there may
be 32-bit libraries hanging around.
Note that I have installed 32-bit MS SQL ODBC drivers on the machine. I kind of
doubt that would have an impact, but its hard to tell without a lot of
library-calls tracking work (which I do not feel like doing...).
I have some Powerpoint automation code around here somewhere. Maybe I'll give
that a try too.
But the thing that started this whole thread was whether or not the "VFP 10"
(64bit VFP?) version would be able to do automation into "64bit" Office stuff.
So even if my 32-bit example is 'magic' are we still thinking the 64bit VFP
would not work with 64bit Office?
Maybe it would be worth sharing/creating several code samples that we have used
for 'Office automation', store them somewhere, and then use those as a
quick-test set for any new VFP release or compatible product...
-Charlie
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message:
https://leafe.com/archives/byMID/009301d61718$b6becd60$243c6820$@johnweller.co.uk
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
RE: Office automation using VFP 10 64-bit version
You are able to use an OUT of process COM across the 64-bit & 32-bit barrier. I showed this in my 2019 SWFox session. I was working with a 64-bit C# and accessing a VFP 9 SP 2 COM compiled as an EXE. Fun stuff. Tracy -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Charlie Coleman Sent: Saturday, April 18, 2020 12:36 PM To: profoxt...@leafe.com Cc: profoxt...@leafe.com Subject: Re: Office automation using VFP 10 64-bit version Not to beat this to utter death and disfigurement... I definitely used Automation from 32-bit VFP into 64-bit Outlook. So are we saying that if I go to 64-bit VFP (the "VFP 10") that suddenly that same code would not work? -Charlie On Sat, Apr 18, 2020 at 6:37 AM Alan Bourke wrote: > It's not helped by the fact that 64-bit Office will get installed by > default now via Office 365, and you kind of have to jump through hoops to > install the 32-bit version. > > -- > Alan Bourke > alanpbourke (at) fastmail (dot) fm > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/000601d61715$d31eee20$795cca60$@powerchurch.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Office automation using VFP 10 64-bit version
LOLyeah, that's why I started this thread about using the 64-bit version "mainly for marketing hype" so that we can say "our app is using VC++ 10 runtimes and 64-bit." -- not for any other benefit than for marketing. On 4/17/2020 2:35 PM, Ted Roche wrote: On Fri, Apr 17, 2020 at 2:22 PM Jürgen Wondzinski wrote: 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. I think you give "admins" too much credit, my friend. On many clients' new Windows 10 machines, I find Win10 64-bit, of course, and Office 64-bit. When challenged, I've been told that's the right one to install on 64-bit OSes. *eyeroll* Of course, calling "the computer guy" they hired for the install-and-configure-gig on Craigslist an "admin" might be a stretch... --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/a4f5de0c-3543-b11e-f23b-50503e670...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Office automation using VFP 10 64-bit version
- In Outlook, I went to File, then Office Account, then clicked "About
Outlook"
- Near the top of the resulting screen I saw "Microsoft Outlook for Office
365 MSO (16.0.11929.20618) 64-bit" (and of course there were "TM"s spread
around in that string).
- Then I went to VFP and opened up the code I had used a while back. The
'basic' design of it is as follows:
oOutlook = CREATEOBJECT('outlook.application')
...
oMsg = oOutlook.CreateItem(0)
oMsg.to =
oMsg.from =
oMsg.subject =
oMsg.htmlbody =
*-- maybe there was another step or two - but you get the gist
*-- then actually sent the message.
oMsg.send()
I did the above this past Friday (4/17/2020) - grabbing out some of that
code and ran lines of it from the VFP command prompt (the actual code would
have sent out about 100 emails for a 'crisis' situation that did not exist
so I did not want to trigger that - heh). But the email I created with the
above process was sent and delivered (to myself at a couple different email
addresses I have). According to the "About" VFP - I am using VFP SP2,
version 09.00..5815.
Of course, this was ONLY Outlook. It was not Word, Excel, or Powerpoint.
But it does clearly call itself 64-bit. Now based on MS's past behavior
I certainly do not expect them to be honest. But trying to deceive at this
level would seem a little ridiculous even for them.
I will add that I do not know if we perhaps started with 32-bit Office at
one point and then migrated to 365 64-bit. This particular PC was set up
about 11 months ago. And given MS's poor history of cleaning up after
itself, there may be 32-bit libraries hanging around.
Note that I have installed 32-bit MS SQL ODBC drivers on the machine. I
kind of doubt that would have an impact, but its hard to tell without a lot
of library-calls tracking work (which I do not feel like doing...).
I have some Powerpoint automation code around here somewhere. Maybe I'll
give that a try too.
But the thing that started this whole thread was whether or not the "VFP
10" (64bit VFP?) version would be able to do automation into "64bit" Office
stuff. So even if my 32-bit example is 'magic' are we still thinking the
64bit VFP would not work with 64bit Office?
Maybe it would be worth sharing/creating several code samples that we have
used for 'Office automation', store them somewhere, and then use those as a
quick-test set for any new VFP release or compatible product...
-Charlie
On Sat, Apr 18, 2020 at 1:40 PM Jürgen Wondzinski
wrote:
> Are you absolutely sure that you have Office 64bit installed? Since it's
> not
> only me, but MS itself to state that it's technically impossible, I really
> doubt it. :) If yes, you would be the first to made it magically happen.
>
> wOOdy
>
>
> -Ursprüngliche Nachricht-
> Von: ProFox Im Auftrag von Charlie Coleman
> Gesendet: Samstag, 18. April 2020 18:36
> An: ProFox Email List
> Cc: profoxt...@leafe.com
> Betreff: Re: Office automation using VFP 10 64-bit version
>
> Not to beat this to utter death and disfigurement...
>
> I definitely used Automation from 32-bit VFP into 64-bit Outlook. So are we
> saying that if I go to 64-bit VFP (the "VFP 10") that suddenly that same
> code would not work?
>
> -Charlie
>
[excessive quoting removed by server]
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message:
https://leafe.com/archives/byMID/CAJGvLx2gRK9jB0=38JrYDKKfNWmMMM5=tdfeaagzpzwtoej...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
AW: Office automation using VFP 10 64-bit version
Are you absolutely sure that you have Office 64bit installed? Since it's not only me, but MS itself to state that it's technically impossible, I really doubt it. :) If yes, you would be the first to made it magically happen. wOOdy -Ursprüngliche Nachricht- Von: ProFox Im Auftrag von Charlie Coleman Gesendet: Samstag, 18. April 2020 18:36 An: ProFox Email List Cc: profoxt...@leafe.com Betreff: Re: Office automation using VFP 10 64-bit version Not to beat this to utter death and disfigurement... I definitely used Automation from 32-bit VFP into 64-bit Outlook. So are we saying that if I go to 64-bit VFP (the "VFP 10") that suddenly that same code would not work? -Charlie [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/008401d615a8$673ba720$35b2f560$@wondzinski.de ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Office automation using VFP 10 64-bit version
Not to beat this to utter death and disfigurement... I definitely used Automation from 32-bit VFP into 64-bit Outlook. So are we saying that if I go to 64-bit VFP (the "VFP 10") that suddenly that same code would not work? -Charlie On Sat, Apr 18, 2020 at 6:37 AM Alan Bourke wrote: > It's not helped by the fact that 64-bit Office will get installed by > default now via Office 365, and you kind of have to jump through hoops to > install the 32-bit version. > > -- > Alan Bourke > alanpbourke (at) fastmail (dot) fm > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/CAJGvLx1pZg0DoyQzJFfaU0X=h2dvei9weso+7wbslg+sgqk...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Office automation using VFP 10 64-bit version
It's not helped by the fact that 64-bit Office will get installed by default now via Office 365, and you kind of have to jump through hoops to install the 32-bit version. -- 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 this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ee69e18c-a713-4175-a557-57524ee36...@www.fastmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Office automation using VFP 10 64-bit version
On Fri, Apr 17, 2020 at 2:22 PM Jürgen Wondzinski wrote: > 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. > I think you give "admins" too much credit, my friend. On many clients' new Windows 10 machines, I find Win10 64-bit, of course, and Office 64-bit. When challenged, I've been told that's the right one to install on 64-bit OSes. *eyeroll* Of course, calling "the computer guy" they hired for the install-and-configure-gig on Craigslist an "admin" might be a stretch... --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/CACW6n4sX=UV-LN3+V9LM4R=wuppgyyx742tm1acgk7xu65+...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
AW: Office automation using VFP 10 64-bit version
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-version-of-office-2dee7807-8f95-4d0c-b5fe-6c6f49b8d261
You can check the version of your installed office somewhere under File /
Options
wOOdy
-Ursprüngliche Nachricht-
Von: ProFox 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 <
> mbsoftwaresoluti...@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 Im Auftrag von MB Software
>> Solutions, LLC
>>> Gesendet: Donnerstag, 16. April 2020 17:28
>>> An: ProFox Email List
>>> 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]
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message:
https://leafe.com/archives/byMID/022401d614e5$2fdbab40$8f9301c0$@wondzinski.de
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
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 <
mbsoftwaresoluti...@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 Im Auftrag von MB Software
Solutions, LLC
Gesendet: Donnerstag, 16. April 2020 17:28
An: ProFox Email List
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]
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message:
https://leafe.com/archives/byMID/e7c07b49-3acb-340d-9ab5-a21d316cb...@mbsoftwaresolutions.com
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
