Funny that I am doing this at this moment. I have a utility which I wrote for a client a few years ago that relies heavily on Excel automation. It was written for Oriface 2003. In spite of my warnings, the "upgraded" to Oriface 2007. Naturally, the application won't work at all any more.
I have them the options and costs to rebuild the automation part. As a result, they now send *me* the files and I run the utility here, and send them the resulting files. Fortunately, they only need to run it once or twice per year. Incidentally, I had to move to O-2007 for other reasons, so I created a XP VM using VirtualBox to install O-2003. Ken On Fri, Apr 8, 2011 at 11:28 AM, Rick Q <[email protected]> wrote: > You will need to have version checking within your code. 2007 & newer have > different syntax. > Sent via BlackBerry by AT&T > > -----Original Message----- > From: "Jarvis, Matthew" <[email protected]> > Sender: [email protected] > Date: Fri, 8 Apr 2011 11:15:39 > To: <[email protected]> > Reply-To: ProFox Email List <[email protected]> > Subject: RE: automation in excel > >> -----Original Message----- >> From: [email protected] > [mailto:[email protected]] >> On Behalf Of Jerry Foote >> Sent: Friday, April 08, 2011 9:06 AM >> To: [email protected] >> Subject: automation in excel >> >> Anyone had any experience with excel and automation between different >> versions. Will the excel command strings I have working with excel > 2003 >> work >> with later versions? >> >> Thanks Jerry > > > M$ is notorious for changing the constants (values) used so you might > want to have a provision built in for that. > > Not so sure about 'command strings' though - can you provide an example > of what you mean? > > Thanks, > > Matthew Jarvis || Business Systems Analyst > IT Department > McKenzie-Willamette Medical Center > 1460 G Street, Springfield, OR 97477 || Ph: 541-744-6092 || Fax: > 541-744-6145 > > -------------------------------------------------------------------------- > Disclaimer: This electronic message may contain information that is > Proprietary, Confidential, or legally privileged or protected. It > is intended only for the use of the individual(s) and entity named > in the message. If you are not an intended recipient of this > message, please notify the sender immediately and delete the > material from your computer. Do not deliver, distribute or copy > this message and do not disclose its contents or take any action in > reliance on the information it contains. > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** 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.
