Tiny question about concatenating the following...

[NewbieMan]

Public SaveName as String

Set y = Workbooks.Open("C:\A\B\C\ & SaveName & ".xlsx")

Very small question please...how does one get around the "period" when concatenating the above? Because the above returns an error because of it.

Thank you

 

[Norie]

What 'period' are you referring to?

As far as I can see the only one in the posted code is in the literal string '.xlsx' and that's part of the file extension.

Do you have a period in SaveName?

 

[NewbieMan]

oops sorry...i meant in the ".xlsx"

are you saying that it is fine and not the source of the error? because thats the assumption i have been working on

 

[NewbieMan]

never mind ...found the error ..was forgettting the double quotes as C\ so it kicked out an error. I need sleep

Thanks.