![]() ![]() 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. |