Syntax for wildcards. 1

[PALman]

Can anyone correct the code below to enable me to copy a known file which has variable characters added to the file name after the first 5 characters?
e.g. Filename = C1234 but actual filename = "C1234 UT" or actual filename = "C1234 MP LP"
I assume use of wildcard * or % is used but how is it added to line of code?

filename = NDnumber (ND number + * ???)
FileCopy "\\dept-01\filename", "\\C:\Jobs Folder\" + filename

Any help much appreciated!

 

[PHV]

Have a look at the Dir function ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[TheAceMan1]

How are ya PALman . . .

Have you tried

[blue]   filename = NDnumber & "*"[/blue]

See Ya! . . . . . .

 

[PALman]

Sorry,
filename = NDnumber & "*"
produces "Bad Filename or Number" error.
What it actually does is append asteris (*) to the first 5 characters, thus...
C1234*
So the asteris is not functioning as wildcard.

 

[PHV]

Seems you didn't read my previous post:
filename = Dir("\\dept-01\" & NDnumber & "*")
FileCopy "\\dept-01\" & filename, "C:\Jobs Folder\" & filename

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[PALman]

Sorry PHV
I had to leave my coding problem for a week or so.
However I have just tried your answer and you were spot on.
Your coding works great.
To take things further I need to know how to code wildcards in paths so that a file may be found in any one of a number of folder/paths. So I have started a new thread for this.
Thanks again,
PALman