Hi,
I am hoping someone can take pitty on me for not knowing VBA and getting myself into a mess where I need programming help to solve. I have a DB (access) with numerous table and queries. I have data on 25 different applications and what I need to do is put together an excel workbook where a user can validate data for their system. Basically I want each query to be a tab in the excel workbook. Not hard in principle right. However, I already created the excel template to account for users making updates to each column and this has resulted in an extra blank column to the right of columns in the access query. For example, the first column in my access query might be 'system name' and the second column might be 'system acronym' However, in the excel sheet it would read 'system name' followed by a blank column called 'updated system name'. If the system name from the DB was wrong the user would use that extra excel column to enter the proper name and thus I could see the before/after. Rather than export to Excel and do all of this manual formatting I would like to be able to hit a command button where the logic says:
export system x (where denoted by system ID) from query y and take these fields (a, b, c, e) from query y and put them into x worksheet in x Excel workbook where query field "a" would go into excel column "b" and where query field "b" would go into excel column "d" and so forth. This way I could literally have my validation sheet be created automatically and require no after the fact formatting.
Thank you for any help on this
Evan
Sounds more confusing than it is but I'm totally stuck.