puredeadradio
New Member
- Joined
- Mar 1, 2011
- Messages
- 1
Greetings to all, I have a rather complex question that I can't seem to pin down. Basically, I'm trying to put a band-aid on a poorly designed Oracle reporting system. I'm not in IT, so I don't have access to any hard code. I only have access to the final generated report.
The only way I've found to clean up this report to something I can use is to save the generated report as an HTML file (how it's initially generated), and open the source code in Notepad and trim the top and bottom sections of code (to get rid of images, menus, etc. I then open the newly-trimmed html file in Excel (to keep the general structure) and save it as a CSV. Then I open the CSV in Notepad++ (because I can see line breaks and carriage returns) and run a find-replace macro to clean it up. I save it, then open it up in Excel again and run a series of macros to format the info, filter the results, save files based on criteria, and email the filtered results to different people.
Simply put:
1. SaveAs HTML
2. Open HTML in Notepad - Delete Header & Footer - SaveAs HTML - Close
3. Open HTML in Excel - SaveAs CSV - Close
4. Open CSV in Notepad++ - Find/Replace - SaveAs CSV - Close
5. Open CSV in Excel - Run Macros, etc.
What I'm looking to do is automate Steps 2-4. I've already got the macros for Step 5 stored in my Personal Macro Workbook, so I don't necessarily need a specific file open.
I run this report daily, so any time I can save would be awesome.
Thank you in advance for any/all assistance provided!
The only way I've found to clean up this report to something I can use is to save the generated report as an HTML file (how it's initially generated), and open the source code in Notepad and trim the top and bottom sections of code (to get rid of images, menus, etc. I then open the newly-trimmed html file in Excel (to keep the general structure) and save it as a CSV. Then I open the CSV in Notepad++ (because I can see line breaks and carriage returns) and run a find-replace macro to clean it up. I save it, then open it up in Excel again and run a series of macros to format the info, filter the results, save files based on criteria, and email the filtered results to different people.
Simply put:
1. SaveAs HTML
2. Open HTML in Notepad - Delete Header & Footer - SaveAs HTML - Close
3. Open HTML in Excel - SaveAs CSV - Close
4. Open CSV in Notepad++ - Find/Replace - SaveAs CSV - Close
5. Open CSV in Excel - Run Macros, etc.
What I'm looking to do is automate Steps 2-4. I've already got the macros for Step 5 stored in my Personal Macro Workbook, so I don't necessarily need a specific file open.
I run this report daily, so any time I can save would be awesome.
Thank you in advance for any/all assistance provided!
