Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General PowerPoint Questions / December 2007

Tip: Looking for answers? Try searching our database.

Problem creating a filesystem object

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
John Crawford - 06 Dec 2007 23:35 GMT
I created a presentation 'first slide' that can display shapes
and/or pictures randomly on the screen. It can also show a random
background picture and play either a single wav (song) file or a cd.
   The options selected are determined by a control file.
   This was created in Office 2000 on a Windows me machine. It worked
for about 2 years without a problem. I have migrated to xp, and now it
does not work. It fails at the line:

Set fs = CreateObject("Scripting.FileSystemObject")

with the message:

"Automation error. The specified module could not be found."

   Can anyone give me some direction as to what is causing the problem.

   Thanks in advance
    John Crawford
Chirag - 07 Dec 2007 03:15 GMT
Probably, PowerPoint is not able to resolve reference to Microsoft Scripting
Runtime. Check that the reference is still present:
1. In PowerPoint VBA Editor, select "Tools" | "References..." menu item.
2. Ensure that "Microsoft Scripting Runtime" item is checked.

If you don't find "Microsoft Scripting Runtime" item there, do the
following:
1. In the same References dialog box, click "Browse..." button.
2. The "Add Reference" dialog box normally opens in Windows System directory
and that is what we want.
3. Locate and select "scrrun.dll" in Windows System directory.
4. Click Open button after selecting scrrun.dll.
5. Click OK in the "References" dialog box.

See if your code now runs.

- Chirag

 PowerShow - View multiple PowerPoint slide shows simultaneously
 http://officeone.mvps.org/powershow/powershow.html

>    I created a presentation 'first slide' that can display shapes and/or
> pictures randomly on the screen. It can also show a random background
[quoted text clipped - 14 lines]
>    Thanks in advance
>     John Crawford
John Crawford - 07 Dec 2007 14:46 GMT
Chirag:
   Thanks. The reference was not set. So I set it. Same result. However
I did try the same presentation on another machine with basically the
same setup, and it worked!!
   I hate it when it is something local in my machine, especially when
it involves probably trying to get it resolved through Microsoft. If you
have anything else that I could check I would appreciate it. The error
number returned is -2147024770.
   Thanks again for getting me at least this far.
    John

> Probably, PowerPoint is not able to resolve reference to Microsoft
> Scripting Runtime. Check that the reference is still present:
[quoted text clipped - 35 lines]
>>    Thanks in advance
>>     John Crawford
Chirag - 07 Dec 2007 15:43 GMT
Hi John,

What are the differences between your machine and another machine?
Taking a long shot here: Any anti-virus running?

- Chirag

 PowerShow - View multiple PowerPoint slide shows simultaneously
 http://officeone.mvps.org/powershow/powershow.html

> Chirag:
>    Thanks. The reference was not set. So I set it. Same result. However I
[quoted text clipped - 46 lines]
>>>    Thanks in advance
>>>     John Crawford
Steve Rindsberg - 07 Dec 2007 17:43 GMT
Is it possible that scripting is disabled on your computer as a security
measure?  I believe you can do this somehow.

Also, are you doing anything complex with the control file?
From what I've seen, the FSO doesn't seem to have many, if any, features that
you can't replicate in a few lines of VB code (and by doing that, you free
yourself of dependencies on the FSO)

> Chirag:
>     Thanks. The reference was not set. So I set it. Same result. However
[quoted text clipped - 46 lines]
> >>    Thanks in advance
> >>     John Crawford

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ:  www.pptfaq.com
PPTools:  www.pptools.com
================================================
John Crawford - 08 Dec 2007 20:02 GMT
Chirag:
   The two xp machines are both at the same Windows level. One is Dell
and one Toshiba. Both machines have Office 2000 professional, at the
same level. Both are running AVG at the same level.
   One other thing that I noticed is that the presentation came from
Windows me. Again it had Windows 2000 professional. However the
scripting runtime was not checked on that version (as can been seen by
the fact that I brought the presentation over intact).

Steve:
   I will try to find some way on the machine of disabling scripting.
   What I am trying to do is open an ascii file and read the contents
to set up the parameters for the startup. Basically I am just trying to
process an input file. When I first started down this road, I could not
find a VBA method to do this in PP. I asked this forum, and the response
was FSO. If there is an easier/better way I am all for it.

   Thanks to both of you.
    John

> Is it possible that scripting is disabled on your computer as a security
> measure?  I believe you can do this somehow.
[quoted text clipped - 60 lines]
> PPTools:  www.pptools.com
> ================================================
Steve Rindsberg - 09 Dec 2007 03:16 GMT
> Steve:
>     I will try to find some way on the machine of disabling scripting.
[quoted text clipped - 3 lines]
> find a VBA method to do this in PP. I asked this forum, and the response
> was FSO. If there is an easier/better way I am all for it.

I just added this page ... have a look and see if it suits:

Use VBA to read text from a file
http://www.pptfaq.com/FAQ00913.htm

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ:  www.pptfaq.com
PPTools:  www.pptools.com
================================================
John Crawford - 09 Dec 2007 12:51 GMT
Steve:
   Actually, after I read your previous note I thought to re-look at
the problem again. Yes VBA dors have an open, and line input functions.
So I now read the file as I do in all other vb programs, and it works fine.
   I cannot find the original question that got me to the
FileSystemObject solution.
   Thanks.
    John

>>Steve:
>>    I will try to find some way on the machine of disabling scripting.
[quoted text clipped - 14 lines]
> PPTools:  www.pptools.com
> ================================================
Steve Rindsberg - 09 Dec 2007 17:40 GMT
> Steve:
>     Actually, after I read your previous note I thought to re-look at
> the problem again. Yes VBA dors have an open, and line input functions.
> So I now read the file as I do in all other vb programs, and it works fine.
>     I cannot find the original question that got me to the
> FileSystemObject solution.

No matter ... you've now found your way to Truth, Enlightenment and Freedom
from Technology of the Week. <g>

>     Thanks.
>      John
[quoted text clipped - 17 lines]
> > PPTools:  www.pptools.com
> > ================================================

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ:  www.pptfaq.com
PPTools:  www.pptools.com
================================================
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.