Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Our User group would like a button in an Excel workbook that saves a copy of
the workbook in MSSQL database. We have done something similiar in a Web app using C#. The excel workbook is stored in MSSQL db as an image. That app has access to the workbook as a saved file, not as an active workbook during that process. Converts the file to byte then image. I can't duplicate the process successfully in VBA code. The workbook object doesn't seem to support the Savepicture or CopyAsPicture functions. In order to use the byte conversion I need the Length of the file(workbook), another property I am unable to use with the workbook object. Any help would be appreciated. I am using VBA 6.3. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Trying to use VBA to save a copy of a workbook | Excel Discussion (Misc queries) | |||
Connection between MSSQL from/to Excel | Excel Programming | |||
Save copy of workbook | Excel Programming | |||
How can I save an editable copy of a protected excel workbook? | Excel Discussion (Misc queries) | |||
Database Filtering and Import or Copy to Remote Client Workbook | Excel Programming |