Tech Support Guy banner
Status
Not open for further replies.
1 - 15 of 15 Posts

·
Registered
Joined
·
15 Posts
Discussion Starter · #1 ·
Greetings. I have Excel 2003 and Windows Vista. I created a vba script and it has ran for many years. About 2 months ago the vba has had an error message that contains "Active X component can't create object" which occurs at the "Set fs..." statement below.
Dim fs, f
answr = "\300072.txt"
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.CreateTextFile(answr, True)
...
I have been searching the internet all day and I just can't find an answer to my problem. It's not my script. Now I'm getting "License information for this component not found. You do not have an appropriate license to use this functionality in the design environment." There has to be some updates I received during the month of November (OS or Office 2003) that interfered with my script. Anybody out there having a similar problem and who has found a solution? Thanks in advance.

Scott
 

·
Registered
Joined
·
4,916 Posts
Open the Workbook and press ALT + F11 to bring up the VB editor. Click TOOLS >> REFERENCES and make sure there is a checkmark in the box next to Microsoft Scripting Runtime.

Regards,
Rollin
 

·
Registered
Joined
·
4,916 Posts
Use the search feature in Windows to look to see if the needed DLL file exists >> scrrun.dll

I believe the file should be located in C:\Windows or one of its subfolders.

If the file exists you should try to re-register by opening a command prompt and then typing the following command and click OK.

regsvr32 scrrun.dll

If the file doesn't exist on your system you will need to download it to your Windows directory and then register it using the same command above. The download link is below.

http://www.microsoft.com/downloads/...25-D896-482E-A0D6-524E7E844D81&displaylang=en

Rollin
 

·
Trusted Advisor
Joined
·
6,911 Posts
Have you upgraded the system OS to Windows 7?
A lot of these options are not functioning anymore under Windos 7, I have to find other code for similar scripts
 

·
Trusted Advisor
Joined
·
6,911 Posts
Hi Starker,

Just out of curiosity, could you attach you Excel file so that I can take a look at it?
That is if it doesn't have and sensitive data, another otpion is to export the vba module that contains the routine with the problem, you'll have to zip or rar it to allow it to be attached.
 

·
Trusted Advisor
Joined
·
6,911 Posts
I just copied your part of the code and it works fine here.

Exel 2003 and Windows 7
and it works here.

It's stange that it shouldn't work.
Hav you made sure that all the Extensions are active in the VBA project?
 

·
Registered
Joined
·
4,916 Posts
The problem is that he is missing the reference to Microsoft Scripting Runtime. Not sure how it go removed since it is automatically included when MS Office was installed. It will need to be downloaded and registered again before the script will work.

Rollin
 

·
Trusted Advisor
Joined
·
6,911 Posts
He could unpack it from the Windows install folder (I386) and then copy it to the Windows\System32 folder
search for the scrrun.dl_ and use expand to unpack it ?
 

·
Registered
Joined
·
15 Posts
Discussion Starter · #14 ·
Running regsvr32 scrrun.dll after downloading the file worked! Hallelujah! I have no idea how it happened. It just stopped executing. I believe it was Windows Vista update or MS Office 2003 update that messed things up. But, thank you, Rollin! I really appreciate it.

Scott
 
1 - 15 of 15 Posts
Status
Not open for further replies.
Top