View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Text replacement with VBA Excel in several files

This would be true if the scripting runtime is not installed on your
machine. In the VBE in Tools=References, do you see Microsoft Scripting
Runtime in the list (scrrun.dll, usually in teh windows system directory).
If not, then you either have to install it or you can't use these commands.

--
Regards,
Tom Ogilvy


"pieros" wrote in message
ups.com...
Bob, is it possible that this code is a VB-code and not a VBA code?
When I run this macro in Excel I get the following message: 'Run-time
error 429, ActiveX component can't create object' at line 'Set objFSO'.
Can you help me with this?

Greetings,
Pieros