Solved

Porting and different version of components

Posted on 2007-04-03
8
229 Views
Last Modified: 2012-05-05

Hello group,

I'm porting an Excel Application (VBA) from Office 2003 to 2000. After checking References under Tools in VBE I see

Excel 2003 is equipped with:

Microsoft Excel 11.0 Object Library
Microsoft Office 11.0 Object Library
Microsoft Calender 11.0 Object Library
Microsoft Windows Common Control 6.0 (SP6)
fptdc 1.0 type library


and Excel 2000 has:

Microsoft Excel 9.0 Object Library
Microsoft Office 9.0 Object Library
Microsoft Calender 9.0 Object Library
Microsoft Windows Common Control 6.0 (SP4)
DOESN'T HAVE fptdc !


My question is what should I do in order to make my application to run without problem regardless of different  version of the above components?


regards,
ak
0
Comment
Question by:akohan
  • 4
  • 3
8 Comments
 
LVL 15

Expert Comment

by:dirknibleck
ID: 18847838
I suspect that your application will continue to work if you uncheck the box on fptdc in 2003. But I don't know how this would affect 2000. I would try it and see. A quick google on the library shows someone else who had a problem with this in Access, and unchecking it solved his problem.
0
 

Author Comment

by:akohan
ID: 18847966


No, I haven't unchecked it in 2003 version. What I was trying to say is that the 2000 version doesn't have it on its list. My major goal is to make the application run on Excel 2000 as well.

Thanks for your response.

regards,
ak
0
 
LVL 85

Assisted Solution

by:Rory Archibald
Rory Archibald earned 35 total points
ID: 18850170
You should develop on the earliest version you expect the code to run on, and have the references set accordingly. Calendar controls can be particularly temperamental about version issues, so you will have to test to see what works. If necessary you will need an installer and to include any specific controls you require in the package, as long as you have suitable licences to redistribute them.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:akohan
ID: 18884173

Thanks but I didn't get my answer yet. Does anybody have any advice?

Regards,
ak
0
 
LVL 15

Assisted Solution

by:dirknibleck
dirknibleck earned 215 total points
ID: 18884709
What are you using this library for?

It appears to be a FrontPage control. Unless you are doing something in your vba that utilizes FrontPage, I would be surprised if you couldn't uncheck the reference from the 2003 version and have the program run fine in both 2000 and 2003.

Otherwise, did you try Rory's answer? You can package your Excel file with the References so that it will run in any version, however it involves pushing an install file to your users.
0
 
LVL 15

Accepted Solution

by:
dirknibleck earned 215 total points
ID: 18884714
0
 
LVL 15

Assisted Solution

by:dirknibleck
dirknibleck earned 215 total points
ID: 18884729
This link provides more information on your problem as well:

http://www.mcse.ms/message2115630.html
0
 

Author Comment

by:akohan
ID: 18885416


Thanks all.

regards,
ak
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question