02 Dec, 06:23PM in sunny Singapore!
Home → IT Support and Tech Corner →

Help in Visual Basic

Subscribe to Help in Visual Basic 4 posts

Please Login or Signup to reply.
  • tvcnq
    tvcnq's Avatar
    73 posts since Aug '07
    • 25 Jul `08, 7:36PM

      Hi all,

      I encountered this problem using a VB programme in excel. Basically, I have this excel database of people. The programme will calculate the number of people in the different departments and summarise it into a table on a separate sheet.

      This programme works fine on most computers. However, on one particular computer, it gives me a totally different set of data (wrong data). Can anyone tell me whats the problem? Is there some settings on excel that I have to take note?

      BTW, Im using excel97.

      Thanks in advance.

  • Moderator
    ndmmxiaomayi
    ndmmxiaomayi's Avatar
    53,307 posts since Aug '05
    • 25 Jul `08, 10:00PM

      Do you have the VB program codes?

      On most computers, which version of Excel are they using?

  • GIB
    GIB's Avatar
    920 posts since Dec '05
  • tvcnq
    tvcnq's Avatar
    73 posts since Aug '07
    • 26 Jul `08, 7:47PM

      Erm...

      Its not possible cos the program consists of several modules. The problematic one is ~50 pages long when printed out.

      The computers are using excel97. Since the programme can work prefectly fine on most computers, I wonder if it has something to do with the settings of that particular com. Like the Add-Ins or something?

Please Login or Signup to reply.