Writing formatted contents to excel

yutha

New Member
Joined
Jan 19, 2010
Messages
3
Hi,

I have a problem in writing a complete block taken from a word document to excel.
I am able to do the writing of text part.
But there are portions of block with images, formatted text, flow charts etc.
Which I need to write to a cell in Excel file.

Can anybody guide me in doing this?
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
How do yu want to get this into one cell?
If you take text from word and copy it to excel, the different lines will at least end up in defferent cells.

Is this a one-off paste you are trying to achieve or does this need to be done on a regular basis and you are trying to do this with a macro?
 
Upvote 0
I am not using any macro.

I have my data in server.
The data is like uploaded through an editor capable of accepting almost any data.. text, picture, flow chart. an even files...

MY aim is to put all the visible part in a cell in Excel.. So that later i can upload it to a database directly.

I am using Visual Studio to do this....
Right now i achieved putting text part in cell. I am able to put a whole paragraph of text in one cell.
But the other chunk is not happening..

I used the CDatabase class ... created a Db with name of excel file and use INSERT query to insert data.

But not sure of the stuff taken from the editor content.....

Also I tried with OLE concept..
Not quite able to get enough documentation on it.. so dropped..

:)
 
Upvote 0
How do yu want to get this into one cell?
If you take text from word and copy it to excel, the different lines will at least end up in defferent cells.

Is this a one-off paste you are trying to achieve or does this need to be done on a regular basis and you are trying to do this with a macro?
I am not using any macro.

I have my data in server.
The data is like uploaded through an editor capable of accepting almost any data.. text, picture, flow chart. an even files...

MY aim is to put all the visible part in a cell in Excel.. So that later i can upload it to a database directly.

I am using Visual Studio to do this....
Right now i achieved putting text part in cell. I am able to put a whole paragraph of text in one cell.
But the other chunk is not happening..

I used the CDatabase class ... created a Db with name of excel file and use INSERT query to insert data.

But not sure of the stuff taken from the editor content.....

Also I tried with OLE concept..
Not quite able to get enough documentation on it.. so dropped..

:)
 
Upvote 0

Forum statistics

Threads
1,213,549
Messages
6,114,264
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top