How to save workbook in different folders depending on country code

[hanz753]

Hello,

I have the below code, I have nearly completed what I am trying to do. The final stage would be to save each workbook into different folders depending on the country code. Can you please help?




Private Sub filename_cellvalue()


Dim Path As String
Dim filename As String
Dim filename2 As String
'Dim country As String


Path = ""
filename = Range("A1")
filename2 = Range("B1")


ActiveWorkbook.SaveAs filename:=Path & filename & filename2 & ".xls", FileFormat:=xlNormal
End Sub

 

[PhilS2520]

Hi hanz753,

The SaveAs can accept a string that would evaluate to a path. Simply change that string each time you want to save the workbook in a country folder.

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...lders-depending-country-code.html#post5113325

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).