ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Printing Excel BLOBS (https://www.excelbanter.com/excel-programming/291494-printing-excel-blobs.html)

Al Findlay

Printing Excel BLOBS
 
Hello!

I have an MS Access database which contains a table named 'Sheets'.
Each record has a memo field that contains a BLOB representation of an
Excel sheet.

What I want to do is iterate through each record and print out the
BLOB Excel sheet in Excel.

I know how to retrieve the data from the BLOB and write it to an Excel
file, but I do not have permission to write a temporary file. Is there
any way I can use Excel to print or open an in-memory representation
of the Excel BLOB (maybe via a stream of some sort)?

Thanks,

Al


All times are GMT +1. The time now is 05:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com