Solved

Porting and different version of components

Posted on 2007-04-03
8
223 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
 

Author Comment

by:akohan
ID: 18884173

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

Regards,
ak
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
excel connection properties parameters grayed out 5 27
Excel Copy Macro down foe each row 4 20
Most Consistent Performer 4 21
Dynamic Filter ? 4 21
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial will demonstrate the 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.

867 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

15 Experts available now in Live!

Get 1:1 Help Now