At work, an Oracle database sends me emails with spreadsheets in them. These get peeled out of my email and saved in a folder on my computer using an agent in Lotus Notes (our email system). Although you ask the database to send this to you as an Excel file, it really comes through as a single file web page, even though it acts and behaves as an Excel File.
What I need is a macro to look into this folder and save any document in there as an Excel file, without changing their name, although it wouldn't be the end of the world if it did. Apparently it is not possible to save them as a certain file type when they are extracted out of my email and saved using the agent.
If it only processed non Excel files, that would be fabulous, but not that big of a deal if it didn't. MS Access won't communicate with Single File Web Pages (to my knowledge), so that is why this would be useful to have them converted to Excel files without having to go in and resave them manually.
Bookmarks