save filename found in cell that is not in values

[kosherboy]

Hi,
Below is a code that saves the active workbook into a file which is specified in a cell. The issue here is that the filepath, in this case the filepath is found in cell H2, is not in values but rather in a vlookup formula. I tried the code in a different cell where the filepath in the cell is in values and the code works fine, but the code is having trouble reading a cell with a formula in it. I also added the words ".value" right after "& Range("H2")" in the code but that didn't either work.
Can anybody help me on this issue?

Please Login or Register  to view this content.

[Brendan_Floyde]

I can't duplicate your error. The code should evaluate the cell value before adding together to create the file name. Are you sure the the vlookup table has the file path correct? You may have to post a demo file.

[kosherboy]

Thank you for your reply.
Please see this attachment Book1.xlsm
Note that if you go into the macro code and change the cell that would contain the file path from "C10" to "C15" the code will work since C15 is not in values.
Thanks.

[kosherboy]

I realized my issue. The file path is on a server, when I put a regular filepath from my computer the macro works fine even if the file is in a formula.
I guess now my issue changed, thanks because now I know where my issue lies (although I still do not have an answer)

[Brendan_Floyde]

How are you refering to the server? you might need to post another example. are there spaces in the file path? Does it need enclosing in ' ' ?

[kosherboy]

Issue fixed, the file name wasn't properly named in the code. How embarrassing