Can I write MS Excel Code inside MS Access module ?

[HelpMoses76]

Hi

Can I actually write MS Excel Code inside an MS Access module and have the operations done on an Excel File specified in MS Access code?

 

[Isaac]

Yes

 

[Uncle Gizmo]

Can I actually write MS Excel Code inside an MS Access module and have the operations done on an Excel File specified in MS Access code?

Yes..
See YouTube:-

Table to Many Excel Sheets - Nifty Access​

AND:-

Access Table to Many Excel Sheets

Access Table to Many Excel Sheets – Nifty Access

www.niftyaccess.com

Excel Sheets From Access Table

Make Excel Sheets From Access Table - Nifty Access

Excel Sheets From Access Table If you've ever faced the challenge of exporting data from Microsoft Access into Excel, you’re not alone! One of the most common requests is to organize data by categories, like exporting car makes into separate Excel sheets or even separate Excel files. I’ve...

www.niftyaccess.com

Show/Hide & Export to Excel

Show-Hide-Export to Excel - Nifty Access

Show/Hide & Export to Excel What started out as an answer to a question on Expert Exchange, took on a life of its own and became a pop-up form which allows you to select the columns you want to display in a datasheet. Now, this is not at all a groundbreaking technology! It's actually already

www.niftyaccess.com

Update Excel from MS Access

Update Excel from MS Access - Nifty Access

Update Excel from MS Access Before I found Bob's excellent code on the BTAB Development Web Site... (To see it Click The Button Below) ... I relied on the two links from Microsoft which you can find below.One link demonstrates the automation method to transfer data cell by cell, which is fine...

www.niftyaccess.com

I use BTAB Development Code Here:-
Export A Table Or Query To Excel – Specific Worksheet on Specific Workbook

Export A Table Or Query To Excel – Specific Worksheet on Specific Workbook | BTAB Development

Copy this code into a standard (not form or report) module. Name the module something other than this function name and make sure to set a reference to DAO if you don't already have one. Public Function SendTQ2XLWbSheet(strTQName As String, strSheetName As String, strFilePath As String) '...

btabdevelopment.com

 

[The_Doc_Man]

It is called an Excel Application Object.

If you open this, you have "real" Excel open on a real Excel-related file like .XLSX or .XLS or some similar file type. If you have the correct references for your VBA, you are able to manipulate Excel objects from an Access application. Uncle Gizmo has some great videos on the subject. For supplemental reading, look up the name I gave you in the first line of this post.

 

[MajP]

an I actually write MS Excel Code inside an MS Access module and have the operations done on an Excel File specified in MS Access code?

I fact you can write vba code in Acess to control all Office products (Outlook, Excel, Power Point, etc.)
Or vice versa.

 

[Isaac]

Take # five..

Or you can use VB script and not even use any office app to host a code that will be very similar to vba.

Yee-Haw!

 

[Uncle Gizmo]

This is an excellent article by Doug Steele:- Excelling Automatically The article has a good explanation of early and late binding and why you should use either one and when...

 

[Isaac]

Good reminder, thanks UG.
Just today actually I passed my boss a tiny MS Access tool for administrative use. I had spoiled myself with Excel early binding (which I don't often do, and not sure really why I had done it this time). I have 365 and he has 2010. The references did not backwards adjust and caused the usual problem. I switched to late binding and all was well. I'm rusty in Access..that's my excuse for my silly forgetfulness.