Export query to excel

Question

I have a routine in my database, that when I exit the database, it runs a query and copies the query data to excel. I would like for the
column labels to be protected in the excel spreadsheet. I know I can just open the spreadsheet and protect row #1, but I am not always

available to do that. Is there away I can have MS Access export / save my query and protect row #1 or the heading labels?

Answer 1

My apologies, sometimes my replies go on and on and get boring, but sometimes I have the opposite problem.

What I meant was that you could record the macro which protects row 1 in the sheet in Excel, then copy that VBA to use in the Access routine that exports the new sheet. VBA is common to both applications, all Office applications, in fact. So, with some minor adjustments in Access, you would have the code from Excel to build on.

Answer 2

I have recorded macros. But, i rewrite the excel spreadsheet with every update. I need access to do this, not excel. This is what im looking for.

Answer 3

Have you ever recorded macros in Excel? That's often the quickest way to get started.

Answer 4

Thank you, but I do not know how to automate that function in excel.

Answer 5

If you can automate that function in Excel VBA, then you can use that same VBA in Access via automation.