Save as excel file based on 2 cells

[graiggoriz]

Hello,

I would like to create a Macro button that would allow me to save an excel file based on 2 cells:

E.g:
Cell A1 = C:\temp\
Cell A2 = test

So I would like once clicking on the macro button to have my excel file copied in the path: C:\temp\test.xlsm

Is it possible? I tried the attached file but got errors.. :-S

many thanks in advance,,
G

[ragulduy]

Please Login or Register  to view this content.

[graiggoriz]

Wonderful! I hope it is not too much to ask but is it possible to also save the file in the path: C:\sources

So let's say I have
Cell A1 = C:\temp\
Cell A2 = C:\sources
Cell A2 = test

That would be fantastic :P

[ragulduy]

What did you mean instead of cell A2 = test - you can't have it being both sources and test...

[graiggoriz]

To have the excel file saved twice but in to different path:
so the macro would save as the file in the below path:
C:\temp\test.xlsm
AND
C:\sources\test.xlsm

[ragulduy]

I mean for this bit:
So let's say I have
Cell A1 = C:\temp\
Cell A2 = C:\sources
Cell A2 = test
cell A2 cannot be two different values at the same time!
but assuming you have
So let's say I have
Cell A1 = C:\temp\
Cell A2 = C:\sources
Cell A3 = test

then:

Please Login or Register  to view this content.

[graiggoriz]

Super It works perfectly! Many thanks :-D

I only removed "\" in the below line as it gave me an error