A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.
Sub BuildFileNameAndSave() Dim SaveStr As Variant Dim ws As Worksheet Set ws = ThisWorkbook.Worksheets("Input") 'change as needed SaveStr = False Do Until SaveStr <> False SaveStr = Application.GetSaveAsFilename(CurDir & "\LOT # " & ws.[LotNumber] & " - CUST # " & ws.[CustomerNumber] & " - " & ws.[CustomerName] & ".xlsm", "Excel Workbooks (*.xlsm), *.xlsm", , _ "Select file name and folder:") If SaveStr = False Then MsgBox "Please make a selection!", vbCritical End If Loop ThisWorkbook.SaveAs SaveStr End Sub
|using fill in Excel||6||29|
|VBA to Delete the Filtered Rows in an Excel Table||3||31|
|Change hyperlink addresses that contain a certain substring using VBA||9||40|
|Excel Split Employee Name into Lname Fname Mname||3||15|