Solved

Porting and different version of components

Posted on 2007-04-03
8
221 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
Comment Utility
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
Comment Utility


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
Comment Utility
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
 

Author Comment

by:akohan
Comment Utility

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

Regards,
ak
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 15

Assisted Solution

by:dirknibleck
dirknibleck earned 215 total points
Comment Utility
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
Comment Utility
0
 
LVL 15

Assisted Solution

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

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

Author Comment

by:akohan
Comment Utility


Thanks all.

regards,
ak
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

744 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now