shockerfest
06-03-2010, 06:47 AM
Hello there, I am new to these forums and in search of some help.
I am currently working on a project that involves running a macro off access to export an excel file with the appropriate queries. So far I have been successful in doing that. The next step is where I am stuck, well a couple of things.
1. Is there a way to automatically open your exported excel file after running your macro off access?
2. After the export is complete all of the data is arranged how I want on 2 worksheets. However, I need a way to enable a macro to automatically format the information (which I have created, but don't know how/where to save it appropriately). But the thing is, since the database is being constantly updated, and I need to export information from that database several times a day, and the formatting macro needs to be applied everytime I export this file (which isn't a problem if I was the only user). Also, other people are exporting the same information but without the formatting because they don't have the right formatting macro that I have created. Is there a way to integrate the formatting macro I have created to this specific file for every user that tries to export this same file?
I am currently working on a project that involves running a macro off access to export an excel file with the appropriate queries. So far I have been successful in doing that. The next step is where I am stuck, well a couple of things.
1. Is there a way to automatically open your exported excel file after running your macro off access?
2. After the export is complete all of the data is arranged how I want on 2 worksheets. However, I need a way to enable a macro to automatically format the information (which I have created, but don't know how/where to save it appropriately). But the thing is, since the database is being constantly updated, and I need to export information from that database several times a day, and the formatting macro needs to be applied everytime I export this file (which isn't a problem if I was the only user). Also, other people are exporting the same information but without the formatting because they don't have the right formatting macro that I have created. Is there a way to integrate the formatting macro I have created to this specific file for every user that tries to export this same file?