Using VB to manipulate Excel
Posted on 2000-05-16
I asked a question a while back, and I know how to add values to cells, etc, but I want to know the following:
1) How do I copy a sheet and rename it using VB?
2) How can I save under a different filename?
3) How can I do a Application.Quit without having it ask me if I want to save my changes?
Basically I have a workbook with a template framework, I want a VB 6.0 app to fill in values, the 'save as' it to a different name.