Solved

Microsoft VBScript runtime error: Object required: 'objfso' in (50, 13)

Posted on 2009-03-31
7
1,416 Views
Last Modified: 2013-11-25
I have been modifying a script to create and map a drive if it does not exist. I am not able to get past the error indicated above. Any help would be greatly appreciated. The code is as follows:


Set objGroupRFTime = GetObject("LDAP://CN=RFEM Time,OU=Department-function distribution groups,OU=RFEM,DC=RFEK,DC=com")
 
For Each oUser In objGroupRFTime.Members
      
   If oUser.Class = "user" Then
 
   Set objNet = WScript.CreateObject("WScript.Network")
   Set FSO = CreateObject("scripting.filesystemobject")
 
   sUserName = objNet.UserName
   sDomainName= objNet.UserDomain
 
   If LCase(oUser.samAccountName) = LCase(sUserName) Then
      folderToCheckFor = "\\rfaccount\d$\OLMS\Orion\RFEMTime\" & sUserName
      If (FSO.FolderExists(folderToCheckFor)) = False Then
         FSO.CreateFolder(folderToCheckFor)
         Set WshShell = WScript.CreateObject("WScript.Shell")
         
         for i=1 to 15
            if objfso.folderexists(folderToCheckFor)<>0 then
               Call WshShell.Run("CACLS " & folderToCheckFor & " /T /E /C /G " & sDomainName & "\" & sUserName & ":F",2,True)  
               exit for
            end if
            WScript.Sleep 1000
         next
         
         Set WshShell = Nothing      
      End If
      
      a="\\rfaccount\d$\OLMS\Orion\RFEMTime\" & sUserName
      
      If FSO.DriveExists("W:") = False Then
         for i=1 to 15
            If objfso.folderexists(a)<>0 Then
               objnet.mapnetworkdrive "w:",a
               exit for
            end if
            WScript.Sleep 1000
         next
      Else
 
         objnet.removenetworkdrive "w:", True
         WScript.sleep 1000
         for i=1 to 15
            if objfso.folderexists(a)<>0 then         
               objnet.mapnetworkdrive "w:",a
               exit for
            end if
            WScript.Sleep 1000
         next
      End If
 
   End If
   Set FSO = Nothing
   Set objNet = Nothing
 
   End If
   oUser.SetInfo
   Set oUser = Nothing
Next
 
WScript.Quit
 
for i=1 to 15
  If objfso.folderexists(a)<>0 then
     objnet.mapnetworkdrive "w:",a
     Exit for
  End if
  WScript.Sleep 1000
Next

Open in new window

0
Comment
Question by:RFEMHelpdesk
  • 4
  • 3
7 Comments
 
LVL 67

Expert Comment

by:sirbounty
ID: 24032541

Set objGroupRFTime = GetObject("LDAP://CN=RFEM Time,OU=Department-function distribution groups,OU=RFEM,DC=RFEK,DC=com")
 
For Each oUser In objGroupRFTime.Members
      
   If oUser.Class = "user" Then
 
   Set objNet = WScript.CreateObject("WScript.Network")
   Set FSO = CreateObject("scripting.filesystemobject")
 
   sUserName = objNet.UserName
   sDomainName= objNet.UserDomain
 
   If LCase(oUser.samAccountName) = LCase(sUserName) Then
      folderToCheckFor = "\\rfaccount\d$\OLMS\Orion\RFEMTime\" & sUserName
      If (FSO.FolderExists(folderToCheckFor)) = False Then
         FSO.CreateFolder(folderToCheckFor)
         Set WshShell = WScript.CreateObject("WScript.Shell")
         
         for i=1 to 15
            if FSO.folderexists(folderToCheckFor)<>0 then
               Call WshShell.Run("CACLS " & folderToCheckFor & " /T /E /C /G " & sDomainName & "\" & sUserName & ":F",2,True)  
               exit for
            end if
            WScript.Sleep 1000
         next
         
         Set WshShell = Nothing      
      End If
      
      a="\\rfaccount\d$\OLMS\Orion\RFEMTime\" & sUserName
      
      If FSO.DriveExists("W:") = False Then
         for i=1 to 15
            If FSO.folderexists(a)<>0 Then
               objnet.mapnetworkdrive "w:",a
               exit for
            end if
            WScript.Sleep 1000
         next
      Else
 
         objnet.removenetworkdrive "w:", True
         WScript.sleep 1000
         for i=1 to 15
            if FSO.folderexists(a)<>0 then         
               objnet.mapnetworkdrive "w:",a
               exit for
            end if
            WScript.Sleep 1000
         next
      End If
 
   End If
   Set FSO = Nothing
   Set objNet = Nothing
 
   End If
   oUser.SetInfo
   Set oUser = Nothing
Next
 
WScript.Quit
 
for i=1 to 15
  If FSO.folderexists(a)<>0 then
     objnet.mapnetworkdrive "w:",a
     Exit for
  End if
  WScript.Sleep 1000
Next

Open in new window

0
 

Author Comment

by:RFEMHelpdesk
ID: 24032942
Please and thank you. The code works if an administrator but not as a user. I am getting the error at 29,10 Permission denied. I have shared out the location with full permissions in an effort to determine the cause with the same result. I have also granted NTFS level permissions. Still no luck, any ideas?
0
 
LVL 67

Expert Comment

by:sirbounty
ID: 24032958
Line 29 is blank...but I can tell you're trying to access an administrative/hidden share (d$) which is restricted for admins only...
0
Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

 

Author Comment

by:RFEMHelpdesk
ID: 24033169
So now that I have my mental defect out of the way! I have removed the call to the hidden share and replaced it with the share name and all works quite smoothly. Thank you for your rapid replies to this issue. In addition, so that I may learn from this, what was it that was changed in the script to make it function correctly?
Set objGroupRFTime = GetObject("LDAP://CN=RFEM Time,OU=Department-function distribution groups,OU=RFEM,DC=RFEK,DC=com")
 
For Each oUser In objGroupRFTime.Members
      
   If oUser.Class = "user" Then
 
   Set objNet = WScript.CreateObject("WScript.Network")
   Set FSO = CreateObject("scripting.filesystemobject")
 
   sUserName = objNet.UserName
   sDomainName= objNet.UserDomain
 
   If LCase(oUser.samAccountName) = LCase(sUserName) Then
      folderToCheckFor = "\\rfaccount\RFEMTime\" & sUserName
      If (FSO.FolderExists(folderToCheckFor)) = False Then
         FSO.CreateFolder(folderToCheckFor)
         Set WshShell = WScript.CreateObject("WScript.Shell")
         
         for i=1 to 15
            if FSO.folderexists(folderToCheckFor)<>0 Then
               Call WshShell.Run("CACLS " & folderToCheckFor & " /T /E /C /G " & sDomainName & "\" & sUserName & ":F",2,True)  
               exit For
            end If
            WScript.Sleep 1000
         Next
         
         Set WshShell = Nothing      
      End If
      
      a="\\rfaccount\RFEMTime\" & sUserName
      
      If FSO.DriveExists("W:") = False Then
         for i=1 to 15
            If FSO.folderexists(a)<>0 Then
               objnet.mapnetworkdrive "w:",a
               exit For
            end If
            WScript.Sleep 1000
         Next
      Else
 
         objnet.removenetworkdrive "w:", True
         WScript.sleep 1000
         for i=1 to 15
            if FSO.folderexists(a)<>0 then         
               objnet.mapnetworkdrive "w:",a
               exit For
            end If
            WScript.Sleep 1000
         Next
      End If
 
   End If
   Set FSO = Nothing
   Set objNet = Nothing
 
   End If
   oUser.SetInfo
   Set oUser = Nothing
Next
 
WScript.Quit
 
For i=1 to 15
  If FSO.folderexists(a)<>0 then
     objnet.mapnetworkdrive "w:",a
     Exit for
  End if
  WScript.Sleep 1000
Next

Open in new window

0
 

Author Comment

by:RFEMHelpdesk
ID: 24033228
I see now, on lines 34,45 and 65 the obj was removed clarifying the call to the FSO.folderexisits variable.
0
 
LVL 67

Accepted Solution

by:
sirbounty earned 500 total points
ID: 24033316
Correct - you can call the reference to the file system object anything...
For example:

Set PeanutButter = CreateObject("Scripting.FileSystemObject")

You just have to be certain you always use it as that name in your code...

Set objFolder = PeanutButter.GetFolder("C:\Folder\")
If PeanutButter.FolderExists("C:\Folder\") Then  ' ...

0
 

Author Closing Comment

by:RFEMHelpdesk
ID: 31565014
Thank You SIRBOUNTY! Sorry for the delay in closing the request.
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question