ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Please help me with this error (https://www.excelbanter.com/excel-programming/311102-please-help-me-error.html)

Alvin Hansen[_2_]

Please help me with this error
 
Hi!!
I have a macro he
Sub copy()
'
' copy Makro
' Makro indspillet 07-09-2004 af Alvin Hansen
'


Dim FSO As Object
Dim FromPath As String
Dim ToPath As String


FromPath = "h:\city breaks"
ToPath = "C:\city breaks"

Set FSO = CreateObject("scripting.filesystemobject")

If FSO.FolderExists(FromPath) = False Then
MsgBox "From Folder doesn't exist"
Exit Sub
End If

If FSO.FolderExists(ToPath) = False Then
MsgBox "To Folder doesn't exist"
Exit Sub
End If
FSO.CopyFolder Source:=FromPath, Destination:=ToPath

End Sub

I have no trouble with thid before to day
now i get a persmission dennied error why ??
I dont belive i have change anything on my pc??

Best regards
Alvin



All times are GMT +1. The time now is 05:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com