Adding data from a userform then saving using a date filename?

[djsouthcott]

I am reasonably new to VB and I am trying to add data to a worksheet from a userform then I want to save the data on the worksheet using a certain cell as a filename, is this at all possible?

​

 

[Andrew Poulsom]

Yes that's possible, but to get help you will need to be more specific.

 

[Fluff]

Isn't that what you're doing here?
http://www.mrexcel.com/forum/excel-...w-invoice-new-invoice-number.html#post3931125

 

[djsouthcott]

is it the same code? when I try to reuse the same code I get an error, I've changed the path and i would like to get rid of the meessage box asking me if i want to add a new record.

 

[djsouthcott]

there's a problem with this line somehow?

activeworkbook.SaveAs Filename:=path & Range("A16").Text & Range("B14"), FileFormat:=51

 

[Fluff]

What are the values of path , A16 & B14?

 

[djsouthcott]

ahhhhh i'm guessing I have so set the values in the code? otherwise they are just numeric cells within the workbook. how would I set the values for them within the code?

 

[Fluff]

You can use the cell values, it just depends on what those values are.
Do they have a special characters in them, does path end with a \ & does cell B14 end with .xlsx?