HELP PLEASE !!! Replaced HTMLProject for sheets but Images were lost.

A

Anand

I have a peculiar problem. I am using VB.net to store the entire
content of Excel and PowerPoint. For Excel, I looped through the HTML
project items and stored the contents in a cell and saved the
worksheet/workbook. Opened the workbook ,replaced the stored data into
respective sheets using HTML project. This worked fine until i have no
images on my worksheets.

This is the object
oExcel.ActiveWorkbook.HTMLProject.HTMLProjectItems.Item(x).Text

When i worked with the images, i did the same what i did before.
Instead the images loose the data. The image frame is there and seen on
the sheet but the imagedata seems to have lost reference. But the same
procedure works fine for PowerPoint.


I also noticed that after replacing the HTMLProject for each sheet,
when I use
oExcel.ActiveWorkbook.HTMLProject.RefreshProject(True)
oExcel.ActiveWorkbook.HTMLProject.RefreshDocument(True)
the images are lost. This be a clue as to when it happens.

Also i want to know where Excel application is storing images. Can
anyone explain why this happens.

Any help or clues to solve this is really appreciated :-(
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel HTMLProject replaced on RefreshDocument iages lost 1
Excel replaced HTML Project but Images are lost 0
Excel HTMLProject replaced for sheets but Images are lost 0
Delete sheets code error requires object 2
Excel 2010 Sendmail .Display works, but not .Send --- Please help 2
OnTime Change_Event macro AND copy to sheet2 macro trouble 7
Macro to run on all files in a folder but exclude sheets with PivotTable, Pivot Charts and Charts 13
VBA-User says active cell jumps to a different sheet upon Save. Please review my code 1

Top