Hello experts,
today I come with a something in mid which I beleive excel is able to do, but not able to find my way through.
I have an access database, with lots of tables, queries, reports etc... that is inhireted by somone who worked long time ago.
that database is used for reporting, around 300 projects every month... when the Access Databse was programmed, the reporting mechanism was created to go into a project (using an inquiry), and finding the way into the reporting section, and print out the report, this will generate 5 PDF files, for each of them, I need to save it as... so that is 5 saves per project.
My idea is to create an excel macro, where I can select 20 projects for example in column A, path in Column B, and extract the PDF's.
the issue is that the report and the macro built in Access are dynamic, so when I run the query, report or the macro by itself in Microsoft Access, it will pop up a window asking for a project number, that pop up doesnt appear when I run the query through the pre-designed user interface, as the query is taking this input from the project I am already in.
My question is, how easy or difficult it is to create a macro in Excel to handle that, the 5 PDF documents are supposed to be merged later on in a certain order as a final report... any help would be appreciated
Bookmarks