Forum Discussion

RobAshman's avatar
RobAshman
Copper Contributor
Mar 25, 2025

Compile Error: Method or Data Member Not Found

I have a very old excel work sheet that was written in 2005, trying to run this on W11 nd now getting the above error,

is anybody able to assist me please with this issue?

CAT is the output file, the CSV is the input data, the CSV file name also changes depending on the device being downloaded.

 

Many thanks for any help you can give

CAT tool

  • It looks like Sheet2 has become corrupted - see its icon in the Project Explorer:

    And the code name of the Analysis sheet is now Sheet21.

    If you replace all occurrences of Sheet2 with Sheet21, the code works again.

    Please note that - on my PC at least - ListBox1 has become ridiculously large.

    • RobAshman's avatar
      RobAshman
      Copper Contributor

      OK so all has become clear, a friend had a look at the sheet and found it needs activeX to be enabled, once done this now runs perfectly, Thank you for your valuable help and input HansVogelaar 

    • RobAshman's avatar
      RobAshman
      Copper Contributor

      That is very strange as when i open the file here i dont get the Sheet 21, 

      When i go into debug mode however it does instantly go to Listbox1

       

Resources