Exporting a .csv File (1 Viewer)

I have created a macro that exports my query to a csv file. The plan is to set up a task to automatically run the macro at various times throughout the day, and another task that will then take the file and upload it to our vendor software. However, I need certain text to appear in cell "A1", followed by the column headers in row 2, and all of the data in row 3 and beyond. Any ideas how I can get the macro to generate in this format?

It sounds like you want to prefix a query with some data. Maybe could create a table to hold this "certain text to appear in cell "A1", followed by the column headers in row 2..." and then create a query of this table. Then join this query with the query you already have with a union query. Note that the data types of the columns need to match.