Recent content by kcmike

Excellent! Thank you!

Exactly! That's why I'm so lucky that I already have a system-generated (mainframe) date based on a system holiday table and several other code variables... :D The table can be easily queried by either directly linking it to my current database or it can be hit via pass-through query. It's...

Currently, I'm doing a simple OutputTo statement in VBA to export query results to an Excel file and I'm appending today's date to the output file name. Private Sub Command1_Click() Dim TodaysDate As String TodaysDate = Format(DateSerial(Year(Date), Month(Date), Day(Date))...