Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Question on Excel 2003 and VBA coding

Posted on 2007-04-10
3
Medium Priority
?
385 Views
Last Modified: 2012-06-21

Hello group,

I just used my application on a machine with the same Windows (XP) and same office version (2003) but the following code causes an error:


    With userFormDesktop.cbxYear
       
        .Font.Bold = True
       
        For nYear = (Year(Date)) To 1996 Step -1           <<<<<< can't find object or library
             .AddItem Trim(CStr(nYear))
        Next

Your help will be appreciated.

regards,
ak

   
    End With
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
  • 2
3 Comments
 
LVL 16

Accepted Solution

by:
Calvin Brine earned 500 total points
ID: 18884225
Take a look at your references in the VBA editor.  I think you may have some that show up as MISSING.  If they are required for the program, you will need to get the dll/ocx and register it.  If not, just remove it and try running the code again.

HTH
Cal
0
 

Author Comment

by:akohan
ID: 18884253


Right. It was

               MISSING: fpdtc 1.0 Type Library.”

It unchecked the reference option and it is running well.

Thanks,
ak
0
 

Author Comment

by:akohan
ID: 18884257


Thank you so much.

0

Featured Post

Enroll in September's Course of the Month

This month’s featured course covers 16 hours of training in installation, management, and deployment of VMware vSphere virtualization environments. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
Cancel future meetings from user mailboxes in Office 365 using Remove-CalendarEvents
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

705 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