I have worked with importing an Excel sheet into an Access table before, but never with trying to output a report into Excel. I have a single report whose data is determined with a button click from a form, so this report is used a lot. Is it possible to export selected fields from that report into an excel sheet in a certain format?
I am sure I can export the report in its entirety by changing the format I currently use to XLS rather than PDF. If I do that however, it wont be in the correct format I would need it to be. Would it be possible to export to XLS then run code that takes the newly created workbook to either put that data into another workbook, or reconfigure the sheet to be how I need it to?
Long story short, I am trying to save people time doing data entry in our companies primary program by having my app output to Excel so it can be turned around and imported into our companies program (which supports excel imports, but in specific formats). This would make me the new favorite in the office since it would mean project managers no longer have to painstakingly entire line after line (some projects well and exceed 200 lines with 10+ columns each).
Could someone point me in the right direction?
I am sure I can export the report in its entirety by changing the format I currently use to XLS rather than PDF. If I do that however, it wont be in the correct format I would need it to be. Would it be possible to export to XLS then run code that takes the newly created workbook to either put that data into another workbook, or reconfigure the sheet to be how I need it to?
Long story short, I am trying to save people time doing data entry in our companies primary program by having my app output to Excel so it can be turned around and imported into our companies program (which supports excel imports, but in specific formats). This would make me the new favorite in the office since it would mean project managers no longer have to painstakingly entire line after line (some projects well and exceed 200 lines with 10+ columns each).
Could someone point me in the right direction?