Excel VBA code that use form in access, is it possible? (1 Viewer)

sparky23 · Jan 23, 2020

Hi,

I made a program in Access which has forms, tables, queries, macros and VBA code. The user need to choose multiple choices from dropdown lists in order to get the result.
My question is: Can I run macro in excel that "use in background" this form in access for me and print the result back in excel sheet?

Thank you.

Ranman256 · Jan 23, 2020

Either run everything in access (w form) then export to excel,
or
In excel, build your own Excel form that does the same thing, and run the excel macro.

Solo712 · Jan 23, 2020

sparky23 said:
Hi,

I made a program in Access which has forms, tables, queries, macros and VBA code. The user need to choose multiple choices from dropdown lists in order to get the result.
My question is: Can I run macro in excel that "use in background" this form in access for me and print the result back in excel sheet?

Thank you.

Sparky,
the technique I use for a task like this is create a template excel sheet, and then, after getting the user report parameters through multiple choices, dump the data via Access VBA into a copy of the template Excel sheet.

Best,
Jiri

Excel VBA code that use form in access, is it possible? (1 Viewer)

sparky23

New member

Ranman256

Well-known member

Solo712

Registered User.

Similar threads

Users who are viewing this thread