Posted by KEVIN ROWE on November 15, 2001 6:05 AM
I am desperately seeking help with VBE and I was hoping you could help me.
I am doing a project in Excel for A level coursework and am totally stuck and have looked everywhere for an answer. My teacher is not a programmer and does not knopw much about Visual Basic or VBA.
I have a worksheet with 11 in cell A1
in vba i have
Set newBook = Workbooks.Add
.Title = "date"
.Subject = "New Sheet"
This saves a new file when button is clicked which is great but I want the filename to be whatever is in cell A1 so if it is still 11 it would save it as u:\95krowe1\11.xls
Then as i change the cell A1 and press the button that changes too - so if i put 345 in A1 the file will be saved when clicked as
If you cant help please could you tell me where I can get help
Also please could you reply @ my home address
Treorchy Comprehensive School