Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Paste a file into a folder with the current dat
Hi Guys,
I have a problem with this Sub: --- Sub CopyFiles() 'Create the folder with the current date MkDir "s:\Aat\APA acc\GEOFFROY\CPI Mensuels\ALL APA Positions \Database_" & Format(Date, "yyyymmdd") 'Copy the files created with Olympic Set newDir = "s:\Aat\APA acc\GEOFFROY\CPI Mensuels\ALL APA Positions \Database_" & Format(Date, "yyyymmdd") Dim SourceFile, DestinationFile SourceFile = "Q:\Products\Aat\APA Database\Bonds Database \fapa_bonds.xls" ' Define source file name. DestinationFile = newDir FileCopy SourceFile, DestinationFile ' Copy source to target. End Sub --- I managed 'to create the folder with the current date', however, I cannot move the file to this folder. The error occurs at the line Set newDir = "......" Thanks a lot to help me guys, and please don't laugh if it is a simple "" or (), because I am a beginner... :-) Mike |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Paste a file into a folder with the current dat
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Paste a file into a folder with the current date | Excel Programming | |||
use current file and folder name | Excel Discussion (Misc queries) | |||
Macro to open most current file in folder | Excel Discussion (Misc queries) | |||
reference to current file path/folder name? | Excel Programming | |||
Copy folder and paste to another folder | Excel Programming |