run-time error '5' excel

[Rashed.R]

Hi All,

I want to create backup of my working folder. after the folder is copied I would like to set the name of the folder like "FE-26 DAILY FX POSITION-" & Current Date-1 & Current Month & Current Year. I want to set "date part" of the folder name (or rename) as "dd-mm-yyyy".

I am running the following code:

Please Login or Register  to view this content.

After running the code I got run-time error '5' - Invalid Procedure Call or Argument. When I want to debug the code, I found the value of the variable "mDate" is "Empty"

I want the backup folder for the date 14 Feb 2010 to be named as, FE-26 DAILY FX POSITION-14 02 2010
Please help to resolve the problem

[DonkeyOte]

A few points:

Please Login or Register  to view this content.

in VBA with the above statement only dDate is declared as a Date type all others will be Variants... all variables must be explicitly declared (via As) if they are not intended to be Variants.
(also I don't think you really want the last three to be Date values anyway)

"mm" & "dd" are not valid DatePart values - you would need m & d

The equivalent of Today() in VBA is Date ... you don't need to use Now.

Given you're only using the date to formalise your present date string I would suggest just using:

Please Login or Register  to view this content.

[Rashed.R]

Thank you for the reply.

I am testing the code and revert to you

[Rashed.R]

Thank you for the reply.

I am testing the code and revert to you

I have tested the code. I am not getting the result what I want to. For Example, I want the backup folder for the date 15 Feb 2010 to be named as "FE-26 DAILY FX POSITION-15 02 2010" but the resultant folder name is "15-Feb-10". I am getting error in the code line:
[CODE]
Name OldName As NewName ' Rename file.
[CODE]
File Not found. I understand that since the file is renamed with the line of code
[CODE]
FSO.CopyFolder Source:=FromPath, Destination:=ToPath & Format(Date - 1, "DD-MMM-YY")
The line of code
[CODE]
Name OldName As NewName ' Rename file.
gives the 'File Not Found' Error.
So can you please help me to set the folder name as I desire.

[Rashed.R]

Thank you for the reply.

I am testing the code and revert to you

I have tested the code. I am not getting the result what I want to. For Example, I want the backup folder for the date 15 Feb 2010 to be named as "FE-26 DAILY FX POSITION-15 02 2010" but the resultant folder name is "15-Feb-10". I am getting error in the below line of code:

Please Login or Register  to view this content.

File Not found. I understand that since the file is renamed with the below line of code

Please Login or Register  to view this content.

The below line of code

Please Login or Register  to view this content.

gives the 'File Not Found' Error.
So can you please help me to set the folder name as I desire.