Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please help me with this error
Sorry
I have found out why one of my file was write proteced Alvin "Alvin Hansen" skrev: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
I have Error 1919 Error Configuring ODBC dataSource Database | Excel Discussion (Misc queries) | |||
Automation Error, Unknown Error. Error value - 440 | Excel Programming | |||
Syntax Error Runtime Error '424' Object Required | Excel Programming |