Re: Trying to write Excel automation code in VFP9SP2 from Excel 2013 VBA macro code

2016-09-21 Thread mbsoftwaresolutions
On 2016-09-20 03:56, Alan Bourke wrote: Well in terms of the named parameters don't you just need to use positional parameters in the Add() instead? loListObject = loSheet.ListObjects.Add(0, "ODBC:" ... ) Or maybe I can create a template file with the macro embedded, and call the macro, pass

RE: Trying to write Excel automation code in VFP9SP2 from Excel 2013 VBA macro code

2016-09-21 Thread Kurt Wendt
I agree - that's what you should do. At my job here - there is a "Report" that's done the same way. Although strangely - the way they had it setup before I started on the system - is one spreadsheet that is the Template for the report. Then, another spreadsheet has the Macros that get called. Al

Re: [ADMIN] Help me raise money for MS Research

2016-09-21 Thread Ed Leafe
On Sep 14, 2016, at 1:17 PM, Ed Leafe wrote: > The ride is on October 1-2, and I need your help! I have a goal of $300 to > raise, and based on past experience, that should be no problem for this > generous community! If you find ProFox to be a valuable resource, I ask that > you donate whatev

RE: Trying to write Excel automation code in VFP9SP2 from Excel 2013 VBA macro code

2016-09-21 Thread mbsoftwaresolutions
On 2016-09-21 09:33, Kurt Wendt wrote: I agree - that's what you should do. At my job here - there is a "Report" that's done the same way. Although strangely - the way they had it setup before I started on the system - is one spreadsheet that is the Template for the report. Then, another spreadsh

Re: M$ giving more support to dbf?

2016-09-21 Thread mbsoftwaresolutions
On 2016-09-16 08:31, Man-wai Chang wrote: You talking about wars and peace-time conflicts? They never end. :) Keeping VFP alive without adding new features is a simple task. But Micro$oft and possibly US Government chose the Dark Side. Actually I'd wager the US Govt--if anything--had a hand i

Re: M$ giving more support to dbf?

2016-09-21 Thread Alan Bourke
On Wed, 21 Sep 2016, at 03:01 PM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: > (DR-DOS anyone?) What, DR-DOS where the pre-release version of Windows 3.1 wouldn't run on it (or any other non MS-DOS) but the check was disabled in the release version of Windows 3.1 ? -- Alan Bourke al

RE: Trying to write Excel automation code in VFP9SP2 from Excel 2013 VBA macro code

2016-09-21 Thread Kurt Wendt
Mike - Here you go. Here's some of the code in our system: tab2_macro = ssMacroName+"!Module3.Tab2" oExcel.WINDOWS(JUSTFNAME(ssName)).ACTIVATE oExcel.Sheets("Account Level").SELECT oExcel.RANGE("A2").SELECT After the above code runs - then this is the call to the

Re: M$ giving more support to dbf?

2016-09-21 Thread Ted Roche
Nah, I'll take FreeDOS, thanks. https://opensource.com/life/16/9/interview-jim-hall-freedos On Wed, Sep 21, 2016 at 10:19 AM, Alan Bourke wrote: > On Wed, 21 Sep 2016, at 03:01 PM, > mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: > >> (DR-DOS anyone?) > > What, DR-DOS where the pre-release v