Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
i based the following code on an example from copy files to other folder,
recorded march 31, 2006 Sub copyfolder_con() Dim strfom, strto As String Dim copyinfo As Object strfrom = "w:\adhoc \ ipa profiles \ 2006 \ power play reports for ipas \ nnyppo power play reports\ *.xls" MsgBox strfrom strto = "w:\adhoc \ ipa profiles \ 2006 \ test area" MsgBox strto Set copyinfo = CreateObject("scripting.FileSystemObject") copyinfo.copyfile strfrom, strto, False End Sub strfrom and strto have valid values. it always abends at the copyinfo.copyfile statement. yet this is exactly what is in help and what was on for march 31. so why the abends? thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Folder Contents to Excel | Excel Discussion (Misc queries) | |||
Listing the contents of a folder | Excel Discussion (Misc queries) | |||
copying data from folder to folder | New Users to Excel | |||
Copying all files in a folder to new folder | Excel Discussion (Misc queries) | |||
contents of folder | Excel Programming |