variables in save as code

[SlinkRN]

Hi,
I want to create a macro that will allow the user to enter a month, day, and year into a userform and then use those variables in the pathway to save as a new file.
I figured it out with the variables, but I can't figure out how to put spaces between the variables.

Here's the code I have that saves it without spaces:

path = "C:\Documents and Settings\Compaq\Desktop\"
activeworkbook.saveas filename"= _
path & "Sched beg" & txtmonth & txtday & txtyear.fileformat:=xlnormal

I tried adding & " " between the variables but that doesn't work.
Thanks, Slink

 

[SydneyGeek]

Hi Slink, looks like the syntax needs cleaning up. Try:

path = "C:\Documents and Settings\Compaq\Desktop\" 
activeworkbook.saveas filename:= _ 
path & "Sched beg" & txtmonth & " " & txtday & " " & txtyear, fileformat:=xlnormal

Denis

 

[SlinkRN]

Hi Denis,
Thanks, I was SURE I had tried that, but I just tried it again and it works! Who knows what I had done before Thanks for the reply! Slink