?
Solved

Porting and different version of components

Posted on 2007-04-03
8
Medium Priority
?
235 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 140 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

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 860 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 860 total points
ID: 18884714
0
 
LVL 15

Assisted Solution

by:dirknibleck
dirknibleck earned 860 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

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Cancel future meetings from user mailboxes in Office 365 using Remove-CalendarEvents
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

752 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