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
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: ProFox@leafe.com
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/672DF11D979C462EB78027E2C44CA6D1@jerryfootePC
** 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.
> -----Original Message-----
> From: profoxtech-bounces@leafe.com
[mailto:profoxtech-bounces@leafe.com]
> On Behalf Of Jerry Foote
> Sent: Friday, April 08, 2011 9:06 AM
> To: profoxtech@leafe.com
> 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.
_______________________________________________
Post Messages to: ProFox@leafe.com
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/69F310C05DD83C48A84BA3769CE1ECF8047E410C@TNTRIEXEVS02.triadhospitals.net
** 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.
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" <MatJar@mckweb.com>
Sender: profox-bounces@leafe.com
Date: Fri, 8 Apr 2011 11:15:39
To: <profox@leafe.com>
Reply-To: ProFox Email List <profox@leafe.com>
Subject: RE: automation in excel
> -----Original Message-----
> From: profoxtech-bounces@leafe.com
[mailto:profoxtech-bounces@leafe.com]
> On Behalf Of Jerry Foote
> Sent: Friday, April 08, 2011 9:06 AM
> To: profoxtech@leafe.com
> 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.
_______________________________________________
Post Messages to: ProFox@leafe.com
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/69F310C05DD83C48A84BA3769CE1ECF8047E410C@TNTRIEXEVS02.triadhospitals.net
** 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.
_______________________________________________
Post Messages to: ProFox@leafe.com
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
** 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.
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 <quilhotr@gmail.com> 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" <MatJar@mckweb.com>
> Sender: profox-bounces@leafe.com
> Date: Fri, 8 Apr 2011 11:15:39
> To: <profox@leafe.com>
> Reply-To: ProFox Email List <profox@leafe.com>
> Subject: RE: automation in excel
>
>> -----Original Message-----
>> From: profoxtech-bounces@leafe.com
> [mailto:profoxtech-bounces@leafe.com]
>> On Behalf Of Jerry Foote
>> Sent: Friday, April 08, 2011 9:06 AM
>> To: profoxtech@leafe.com
>> 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: ProFox@leafe.com
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/BANLkTimese+AHpZr5KDJy0t4OU6SKq7iKA@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.