Save and Print

[ninash]

Hi Everyone
I have a Excel project I am working on its spec was so easy any fool could use it.
So I have made a form that fills in the sheet and generates the graphs needed by the user but I am having trouble saving the file to a different name and auto printing the completed graph.
The file I am writing is a template and the files made from this one will need to be opened and closed to the same file name that they were given when first created.
I have made a field in the form so the user can type in what they want for a file name but after I save the file it refuses to work correctly when loaded again as for printing it I don't have a clue how to do that.

If there is anyone out there that can help me PLEASE DO
Thanks in advance

 

[RobBroekhuis]

For printing, check out the help on the chart.printout method.
For saving, you may not be specifying the correct file type to save as? Try using
activeworkbook.SaveAs (your filename),xlWorkbookNormal
If that doesn't help, please tell us more specifically what's going wrong.
Rob

 

[ninash]

the problem is with the macros really
once the sheet has been saved to the new name the macros detach from the button and it requires the macro to be assigned to the button again
I could write the code in the personnel macros but if the sheet ever gets moved to another computer then the problem is there again