![]() ![]() If LCase(fn) = "false" Then fn = Environ("TEMP") & Chr(92) &. InitialFileName:=Environ("USERPROFILE") & Chr(92) & ActiveSheet.Name, _įileFilter:="Comma Separated Value files (*.csv), *.csv") Parent.Path & Chr(92) & Left(.Parent.Name & Chr(46), InStr(1. If CBool(Application.CountA(.Cells)) Thenįn =. Sub no_training_wheels(Optional ws As Worksheet) Using a Personal.xlsb has been suggested embedding into a macro-enabled template is another and of course, you can simply put them into a module code sheet within the workbook you are currently processing. The best place to put the following will depend somewhat on your individual situation, of which little has been provided. ![]() However, there is nothing to stop you from expanding its usefulness by assigning a new Save-As-CSV to Ctrl+ Shift+ S. If you are using Ctrl+ s habitually, then it is probably unwise to rewrite that keystroke combination. ![]()
0 Comments
Leave a Reply. |