Re: Text replacement with VBA Excel in several files

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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" <p13m@xxxxxxxxxxx> wrote in message
news:1119877101.734017.34470@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> 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
>


.

Relevant Pages

  • Re: Office 2007 compatible with Office 2003
    ... Thanks DL I will keep all this printed out for when I install 2007 ... Though with Acess you may have used vba code that requires modifying ...
    (microsoft.public.office.misc)
  • Re: English Access 2003 Package install fails on German WinXP
    ... normally this should work, you have to check that access security setting allow VBA code to run, and also add error handling to your VBA code, so user can see error messages during runtime ... Install successful but when program launched no main form displayed. ...
    (microsoft.public.access.developers.toolkitode)
  • Re: Message
    ... I just needed to install it. ... I would like to use it within some other VBA code. ... "NickHK" wrote: ... Sub speaktester() ...
    (microsoft.public.excel.programming)
  • Re: The control could not be created because it is not properly licens
    ... but you can create a setup with the PDW of Visual Studio. ... Michael Bauer - MVP Outlook ... In my vba Code I reference msadodc.ocx for interaction with SQL Server ... I install the code on any other computer I get the "Subject' Error. ...
    (microsoft.public.outlook.program_forms)
  • Re: Installing printer in VBA, if not already installed
    ... What I need to do now is, install the printer if it's not matched. ... You can probably adapt the code here ... It is VB6 rather than VBA code, but if you take the code out of the Form ... module and make a separate routine of it, or you adapt the routine names so ...
    (microsoft.public.word.vba.general)