Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Jonseya
-
How to create a macro that saves a spreadsheet under a new name
cheers for the help its all sorted now. Thank you- Jonseya
- Post #6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
How to create a macro that saves a spreadsheet under a new name
The only code that I have is below which is just a basic recording of save as Sub save2() ActiveWorkbook.SaveAs Filename:="C:\part1.xls" End Sub- Jonseya
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
How to create a macro that saves a spreadsheet under a new name
Hi Could anybody help me with a problem, I am trying to create a macro in an excel spreadsheet that will save the file under a certain name but each time the macro is run it incriments the number each time. i.e. the first time the file is run it will be Part1.xls then part2.xls and then...- Jonseya
- Thread
- Replies: 5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
How to create a macro that saves a spreadsheet under a new name
Hi Could anybody help me with a problem, I am trying to create a macro in an excel spreadsheet that will save the file under a certain name but each time the macro is run it incriments the number each time. i.e. the first time the file is run it will be Part1.xls then part2.xls and then...- Jonseya
- Thread
- Replies: 1
- Forum: Microsoft: Office
