Problem with filepath

[Desmondo]

I have created a tool which generates letters from a userform. The structure of my directory is app main folder and within this there is two folders one called templates and one called archive and the main xlsm file is there to.

I am trying to create the filepaths so that no matter where the main folder is it can detect the path rather than using a constant file path and having to update that all the time.

I am trying to assign the path of where the xlsm file is to the var aPPPath & append with the directory Archive and the folder my app creates so that i can save my docs there.

I am appending like so but think its wrong

aPPPath = Application.ActiveWorkbook.Path & "\" & Archive & "\" & strFolderName & "\"

Can anyone highlight the errors of my ways also when i run MsgBox i get the saving to the following path C:\Users\desmo\Desktop\32\& name of folder i have no idea where the 32 is coming from as it should read C:\Users\desmo\Desktop\Dashboard\Archive\& Foldername.


Problem solved guys missed the double quotes on Archive

 

[Ruddles]

Tip: include an Option Explicit directive at the start of every code module. This will highlight instances where VBA thinks you've used a variable - in this case Archive - which hasn't been declared.