Is there anyway to write VBA inside Access file?

[VAer]

Does Access only deal with SQL?

I have a excel file, which pulls a database table into excel file (this step requires SQL), then generate a new workbook with multiple sheets for pulled database table (this step requires VBA).

It works fine, but there is an issue I am not able to fix. Here is the same issue posted by other: https://www.experts-exchange.com/que...ok-closed.html

I am thinking if it is possible to move both steps (SQL and VBA) into Access? But I am not familiar with Access, and not sure if it takes VBA? Or how to let Access manipulate Excel file.

Thanks.

[andy49]

So you want to export a file into access using SQL and then manipulate the file using VBA access?

If so, certainly possible.

[VAer]

No, I import one server database table into Access, then break the table down into multiple worksheets within one single excel file.

One table in server database --> One excel file with multiple sheets

[aytee111]

Not sure why you need VBA, a lot of calculations and data manipulation can be done through queries in Access. That being said, a query can call a VBA function, or it can be standalone. Once you have the data the way you want it then export it to Excel. This can be a straight export, or you can open an instance of Excel and populate the cells and format the worksheet using VBA in Access.

[aytee111]

(Timing issue, didn't see your second post).

Multiple worksheets are multiple queries exporting into worksheets. This can be done using a macro or VBA in Access. All these steps can be done in one procedure, either macro or VBA.

[VAer]

(Timing issue, didn't see your second post).

Multiple worksheets are multiple queries exporting into worksheets. This can be done using a macro or VBA in Access. All these steps can be done in one procedure, either macro or VBA.

Yes, that was my question, how to write VBA in Access? It is not just exporting, It is not like exporting a table to excel sheet, I still need to format that sheet, need to insert some other information (author, date, etc) in each sheet.

[aytee111]

Here are two places to get you started:
http://www.accessibledatasolutions.c...essToExcel.htm
https://www.experts-exchange.com/que...cel-cells.html