Posts tagged Excel

Remove HTML Tags and Escape Codes from an Excel selection

0
2 years ago
in
The code below can be used to remove HTML tags and escape codes from an Excel selection.  Simply page the code into a new module, select the relevant cells to be processed, and press run. I would suggest that you copy the original cells to another sheet and then try it on the copy first, just to [...]

Error “HRESULT 0x800A03EC” when outputting data to Excel

2
3 years ago
in
Sometime ago, I wrote a Query Tool application that output data from a database into Excel.  However, in the past few days, the users have been getting the “HRESULT 0x800A03EC” exception error when running a specific query. I knew that the application was working, because other query data was being [...]
Go to Top