Syntax question [solved]

[magice]

This doesn't work.

Code: Select all

if there is not a folder "W:/Archives/"&tYear&"/"&tMonth then create folder "W:/Archives/"&tYear&"/"&tMonth

I believe it is an issue with quotation marks, but since the folder name tMonth and tYear are variables, I am having trouble finding the right combination to make it work.

[Dixie]

Try this, putting a space between the ampersands and your variable names...

Code: Select all

if there is not a folder "W:/Archives/" & tYear & "/" & tMonth then create folder "W:/Archives/" & tYear & "/" & tMonth

or maybe..

Code: Select all

put "W:/Archives/"& tYear & "/" & tMonth into thePath
if there is not a folder thePath then create folder thePath

[Klaus]

Hi Magice,

ALWAYS use quotes around concatenated file- and object-names!

Code: Select all

...
if there is not a folder ("W:/Archives/"&tYear&"/"&tMonth) then 
   create folder ("W:/Archives/"&tYear&"/"&tMonth)
end if
...

Or use this way:

Code: Select all

...
put "W:/Archives/"&tYear&"/"&tMonth into tFolder
if there is not a folder tFolder then 
  create folder tFolder
end if
...

Best

Klaus

[magice]

Thank you both. the parenthesis are exactly what I needed.