Correct sytax for using a range n VBA

[BRISBANEBOB]

I am trying to check if a folder exits, and if not, create it (folder name is WOD). I am then trying to save the file as the contents of a cell which is found on a different sheet from where the macro is run, the sheet being Multiple and the cell being G9. The code falls over at the Range("Multiple!G9") part so I obviously have the syntax wrong but I am not sure what it should be. Help please!

Please Login or Register  to view this content.

[protonLeah]

Filename:="C:\WOD\" & Sheets("Multiple").Range("G9").Value

[BRISBANEBOB]

Using the code I am bnnow generating a syntax tax error on line FileFormat:=52, CreateBackup:=False

Please Login or Register  to view this content.

Can anyone help?

Thanks

[shg]

You need a comma, space, and underscore on the preceding line.

[BRISBANEBOB]

Thanks a lot, I was going crazy! Works perfectly now.

[shg]

You're welcome.