Forum Discussion
RobAshman
Mar 25, 2025Copper Contributor
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
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.
- RobAshmanCopper 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
- RobAshmanCopper 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