Path name invalid when trying to save a workbook - VBA

Hi Guys,

I'm currently trying to write a macro to save an excel file under a path name (folder) but i'm not having any luck! hoping you guys can help!!

Below is my macro so far...

Sub SaveJournal()
Dim Path As String
Dim FileName1 As String
Dim FileName2 As String
Path = "S:\accounts\TREASURY\VISIN Journal Import\China Posted Journals\"
FileName1 = Range("C8")
FileName2 = Range("C11")
ActiveWorkbook.SaveAs Filename:=Path & FileName1 & " -" & FileName2 & ".xls", FileFormat:=xlNormal
End Sub

The above VBA DOES work! but under this path (folder) there are sub folders which i am wanting the workbook to save to depending on th value in cell C8! just in case that confuses things.. the following folder S:\accounts\TREASURY\VISIN Journal Import\China Posted Journals\ has 3 folders within named JCA, SCA and FNE. and i'm wanting the workbook to save to the above path and also the sub folder which will be in C8 (c8 for example will have JCA) so i want the end product to save under the path S:\accounts\TREASURY\VISIN Journal Import\China Posted Journals\JCA but i'm having no luck trying to do this!

Can anyone help?

I look forward to hearing your repsonses!

Cheers
Jamie

Unfortunately not.. I should of stated above that i am afte something to add at the end of the 'path' name to look at cell C8 to determine which folder it needs to be saved in.
so far i have
Path = "S:\accounts\TREASURY\VISIN Journal Import\China Posted Journals\"
but i need to add on the end of this something along the lines of = Range ("C8") but it's not working.

Sorry Alan,

I think my explanations may not be very clear.

Where you have put the filenames above, These are woking fine for me but the path name itself isn't working

my final outcome of the save as feature i want should be as 'JCA (filename1) - 1256(filename2)' and i want this under the path name/ folder

HTML Code: 

and the sub folder which is in

HTML Code: 

This is the bit i'm having problems with putting on the end of my file path

Sory about the 'rules'. i'll make sur ei read them now

Jamie

haha so sorry about this!

I shall start again.

When i run the below code

HTML Code: 

It will save it into the folder named 'China Posted Journals' as JCA - 1256 (C8 - C11)

but.. What i'm wantng to do is amend the path name (below) to add in cell (C8) 'JCA' at th end as this is a folder within the 'China Posted Journals'

HTML Code: 

my attempt of this was

HTML Code: 

But this didn't work!!

I hope this helped explain.. slightly

IT WORKS!!!!

thank you so so much!!