Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default Macro to work both in Excel 2002 and Excel 2003

Hello experts,

I have prepared a workbook including macros for several users. The
workbook is prepared in Excel 2002. The problem is that some of the
users are working in Excel 2003 and here the macros do not work. Is
there a way to fix so the macros work in both versions?

From HA14


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default Macro to work both in Excel 2002 and Excel 2003

The differences between those 2 versions of Excel are minimal.
Normally code written on the oldest supported system will work on the newer.

As the why "the macros do not work", I suspect it is something to do your
code, but you did not post the problem area(s), it is anyone's guess.

NickHK

"HA14" wrote in message
oups.com...
Hello experts,

I have prepared a workbook including macros for several users. The
workbook is prepared in Excel 2002. The problem is that some of the
users are working in Excel 2003 and here the macros do not work. Is
there a way to fix so the macros work in both versions?

From HA14




  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,365
Default Macro to work both in Excel 2002 and Excel 2003

Nick, I'm wondering if this is same OP of this request:
http://www.microsoft.com/office/comm...&lang=en&cr=US
and the problem is one of library referencing to non-Excel libraries?

"NickHK" wrote:

The differences between those 2 versions of Excel are minimal.
Normally code written on the oldest supported system will work on the newer.

As the why "the macros do not work", I suspect it is something to do your
code, but you did not post the problem area(s), it is anyone's guess.

NickHK

"HA14" wrote in message
oups.com...
Hello experts,

I have prepared a workbook including macros for several users. The
workbook is prepared in Excel 2002. The problem is that some of the
users are working in Excel 2003 and here the macros do not work. Is
there a way to fix so the macros work in both versions?

From HA14





  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default Macro to work both in Excel 2002 and Excel 2003

Not sure; your link is back to this NG. <g

NickHK

"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
Nick, I'm wondering if this is same OP of this request:

http://www.microsoft.com/office/comm...&lang=en&cr=US
and the problem is one of library referencing to non-Excel libraries?

"NickHK" wrote:

The differences between those 2 versions of Excel are minimal.
Normally code written on the oldest supported system will work on the

newer.

As the why "the macros do not work", I suspect it is something to do

your
code, but you did not post the problem area(s), it is anyone's guess.

NickHK

"HA14" wrote in message
oups.com...
Hello experts,

I have prepared a workbook including macros for several users. The
workbook is prepared in Excel 2002. The problem is that some of the
users are working in Excel 2003 and here the macros do not work. Is
there a way to fix so the macros work in both versions?

From HA14






  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,365
Default Macro to work both in Excel 2002 and Excel 2003

Sorry about that ... looks like you picked up on it anyhow - it's the post
just above this OPs - put up by PMC1

"NickHK" wrote:

Not sure; your link is back to this NG. <g

NickHK

"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
Nick, I'm wondering if this is same OP of this request:

http://www.microsoft.com/office/comm...&lang=en&cr=US
and the problem is one of library referencing to non-Excel libraries?

"NickHK" wrote:

The differences between those 2 versions of Excel are minimal.
Normally code written on the oldest supported system will work on the

newer.

As the why "the macros do not work", I suspect it is something to do

your
code, but you did not post the problem area(s), it is anyone's guess.

NickHK

"HA14" wrote in message
oups.com...
Hello experts,

I have prepared a workbook including macros for several users. The
workbook is prepared in Excel 2002. The problem is that some of the
users are working in Excel 2003 and here the macros do not work. Is
there a way to fix so the macros work in both versions?

From HA14







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can Excel 2003 VBA work in Excel 2002? Adrian C Excel Programming 2 January 16th 07 12:25 PM
macro which works in excel 2000 does not work in excel 2002 nnayak Excel Programming 1 June 16th 06 03:13 PM
Simple Macro, works in Excel 2002, 2003 but won't work in 2000 DJA[_2_] Excel Programming 5 September 28th 05 05:10 PM
Excel 2002/2003 Macro Compatibility issue Steve[_64_] Excel Programming 0 July 23rd 04 03:05 AM
Solver won't work in macro, Excel 2002 SP1 Martin[_11_] Excel Programming 0 November 7th 03 07:03 PM


All times are GMT +1. The time now is 07:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"