Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel HTMLProject replaced on RefreshDocument iages lost
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(T rue) 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 :-( |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel HTMLProject replaced on RefreshDocument iages lost
Anand
Sorry I dont have a proper answer but.. if you save all the html elements - where are you storing the linked stuff? Any objects embedded only have a reference tag, you would need to follow that and do something with the binary objects themselves. If you want to know where Excel is storing them then can't you look at the html in a text editor? Have you checked MSDN? What is it you are you doing? Mabe there is another way? Sorry I can' be more help cheers Simon "Anand" wrote: 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(T rue) 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 :-( |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I get old replaced excel file | Excel Discussion (Misc queries) | |||
Accidently replaced a spreadsheet that I did not want replaced | Excel Discussion (Misc queries) | |||
Excel Replaced my work with a google ad .... | Excel Discussion (Misc queries) | |||
HELP PLEASE !!! Replaced HTMLProject for sheets but Images were lost. | Excel Programming | |||
Excel replaced HTML Project but Images are lost | Excel Programming |