[AccessD] MoveFile in Class -> Permission denied?

S D accessd667 at yahoo.com
Fri Apr 23 03:33:50 CDT 2004


hi group,
 
I've got some code (think from internet) that moves a file. Works like a charm. However, I've created a method in a class called .MoveFile and added the 'move-file'-code to it. Now i get the following error: 70, permission denied. 
So when I call the code in a function it works
When I call the code as a method in a class it doesn't work.
 
How come?
 
TIA
 
Sander
C O D E   I N   F O R M
         '---------------------------------------------------
         'M O V E  F I L E
         '---------------------------------------------------
         With cFile
            .DownloadDir = "D:\Temp Projecten\Access\Switch\Download\"
            .ImportDir = "D:\Temp Projecten\Access\Switch\44\"
            txtDownloadDir = .DownloadDir
            txtImportDir = .ImportDir
            Call .MoveFile(.DownloadDir, .ImportDir, GetNamePart(strFileName))
         End With

C O D E   I N   C L A S S 
'Move a file if it exists
Function MoveFile(strSourceDir As String, _
                  strDestinationDir As String, _
                  strFile As String) As Boolean
   Dim fso
   Dim file As String, sfol As String, dfol As String
   
   file = strFile ' "test.xls"   ' change to match the file name
   sfol = strSourceDir ' "C:\"   ' change to match the source folder path
   dfol = strDestinationDir ' "E:\"   ' change to match the destination folder path
   
   Set fso = CreateObject("Scripting.FileSystemObject")
   
   If Not fso.FileExists(sfol & file) Then
      MsgBox sfol & file & " does not exist!", vbExclamation, "Source File Missing"
   ElseIf Not fso.FileExists(dfol & file) Then
      fso.MoveFile (sfol & file), dfol    <<== ERROR OCCURS HERE?!!
   Else
      MsgBox dfol & file & " already exists!", vbExclamation, "Destination File Exists"
   End If
   
End Function

Public Property Get DownloadDir() As String
   DownloadDir = m_strDownloadDir
End Property
Public Property Let ImportDir(ByVal vData As String)
   m_strImportDir = vData
End Property
Public Property Get ImportDir() As String
   ImportDir = m_strImportDir
End Property

 
 
 
 

		
---------------------------------
Do you Yahoo!?
Yahoo! Photos: High-quality 4x6 digital prints for 25¢


More information about the AccessD mailing list