Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

consultation about automation error

0

hello

I  need  konwing  why   show  automation error in this  line

With CreateObject("System.Collections.SortedList")
 

this  error  shows when  I  run  the  macro  at  another PC  .I  tested for  two  PC  contains  office2010,2019 works  very  well ,but  when   run at another PC   contains office2019. it populates  the  error .

has anybody  idea  why  occurs this  error?

excel
MS Office Version: 2019
posted by: Mussa (rep: 48) on Sun Jan 23, 2022 at 8:34 am
Answer
Discuss

Answers

0
Selected Answer

Mussa

I haven't encountered that problem but this answer VBA Excel macro can't create SortedList elsewhere may help.

posted by: John_Ru (rep: 6142) on Mon Jan 24, 2022 at 5:13 am
Discuss

Discussion

Mussa. Thanks for selecting my Answer- hope it worked for you.
John_Ru (rep: 6142) Jan 24, '22 at 8:04 am
Hi john,
now  I  realized   the  programm FRAME NET   is  too  necessary  for  the  PC. I've found  the  PC  is  not  available for  programm FRAME NET. that's why shows the  error . after  installing   it   work  without any error. I remember  happening  the  same  problem , but  different error  in another  forum  and  some  member  adviced  me  install   FRAME NET  and  also   solved  as  in the  link you  provide  me. actually  I no  know  what's  the  relating  for  this  programm with  work  VBA  projects. anyway  thanks  for your help  me  by  provide the  useful  link and in the future  I will make  sure  installing the FRAME NET  before use VBA  projects.
Mussa (rep: 48) Jan 24, '22 at 8:17 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login