Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
What is wrong with this
Sub Copy_FIles () Dim fPath as string, lPath as string fPath = "\\tfmafs01\corporatesecure$\Procurement Reporting\ExportReportFolder\Working\" lPath = "\\tfmafs01\corporatesecure$\Procurement Reporting\ExportReportFolder\Working\Pre_Formatted _Backup" FileCopy fPath & "*.*", lPath & "*.*" End Sub Thanks |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
Use a msgbox to see if your paths are correct before you copy it, something like this. When you get it right, rem out the message box and remove the rem from the file copy command. Dim fPath As String, lPath As String fPath = "C:\tfmafs01\corporatesecure$\ProcurementReporting \ExportReportFolder\Working\" lPath = "C:\tfmafs01\corporatesecure$\ProcurementReporting \ExportReportFolder\Working\Pre_Formatted_Backup" MsgBox fPath & "*.*" & "," & lPath 'FileCopy fPath & "*.*", lPath HTH Ken |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel files take two minutes to open. What's wrong. | Excel Discussion (Misc queries) | |||
What's wrong with my Help files? | Setting up and Configuration of Excel | |||
bmp files in Excel Hyperlinks open with wrong program | Excel Discussion (Misc queries) | |||
Hyperlinks opening wrong image files | Links and Linking in Excel | |||
Help! What's wrong with this simple copy and paste | Excel Programming |