Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
When Using Format(Now(), "yyyymmmddhhmm") get wrong number of arguments or invalid property assignment Error
I am using the following code to create a file name with a date and
time stamp. I get a "wrong number of arguments or invalid property assignment" when I run the code. For some reason the compiler doesn't like the Format(Now(), "yyyymmmddhhmm"). Can anyone tell me why? Any help would be appreciated! Connie Dim FName as String Dim VersionNo As String FName = "\Upload Hourly " & VersionNo & Format(Now(), "yyyymmmddhhmm") |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
When Using Format(Now(), "yyyymmmddhhmm") get wrong number of arguments or invalid property assignment Error
Works for me :
?Format(Now(), "yyyymmmddhhmm") 2006Nov081559 Sure the error is on that part ? What is the value of VersionNo ? And what do you expect FName to equal ? NickHK "Connie" wrote in message ups.com... I am using the following code to create a file name with a date and time stamp. I get a "wrong number of arguments or invalid property assignment" when I run the code. For some reason the compiler doesn't like the Format(Now(), "yyyymmmddhhmm"). Can anyone tell me why? Any help would be appreciated! Connie Dim FName as String Dim VersionNo As String FName = "\Upload Hourly " & VersionNo & Format(Now(), "yyyymmmddhhmm") |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
When Using Format(Now(), "yyyymmmddhhmm") get wrong number of arguments or invalid property assignment Error
Thanks for your response, Nick. I figured out that I have a macro
named Format which was causing the inconsistency. Thanks again. Connie NickHK wrote: Works for me : ?Format(Now(), "yyyymmmddhhmm") 2006Nov081559 Sure the error is on that part ? What is the value of VersionNo ? And what do you expect FName to equal ? NickHK "Connie" wrote in message ups.com... I am using the following code to create a file name with a date and time stamp. I get a "wrong number of arguments or invalid property assignment" when I run the code. For some reason the compiler doesn't like the Format(Now(), "yyyymmmddhhmm"). Can anyone tell me why? Any help would be appreciated! Connie Dim FName as String Dim VersionNo As String FName = "\Upload Hourly " & VersionNo & Format(Now(), "yyyymmmddhhmm") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compile Error: Wrong arguments or Invalid property | Excel Discussion (Misc queries) | |||
Error: Wrong number of argument or invalid property assignment? | Excel Programming | |||
Wrong number of arguments or invalid property assignment | Excel Programming | |||
Wrong Number of Arguments or Invalid Property Assignment??? | Excel Programming | |||
Wrong number of Arguments or Invalid property assignment | Excel Programming |