I see that MSFLEXGRID has a Picture property. From Intellisense, I get:

Dim grid as MSFLEXGRID
grid.Picture


I see in Intellisense that there is an image object which also has a Picture
property:

Dim img as Image
img.Picture


So, I would think I could programmatically put an Image object on a
worksheet using an Add method. Then I can transfer the picture from the
MSFLEXGRID to the image, something like this:

Set img.Picture = grid.Picture

Then, I can printout the worksheet. That is the goal, to print the picture
of the MSFLEXGRID.

So, I do not see how to connect the dots. How do I get from the MSFLEXGRID
picture to the printer?

Hi Indinfer,

> So, I do not see how to connect the dots. How do I get from the MSFLEXGRID
> picture to the printer?

Why the flexgrid and not insert a picture directly?

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

I am trying to print the image of the MSFLEXGRID. The MSFLEXGRID control has
text and different cells have different background colors to show data. So, I
need to extract what shows on the MSFLEXGRID and print it out. I also need to
save the image to an Excel worksheet.

Also, I don't see how to programmatically insert the MSFLEXGRID image
directly onto a worksheet. That would be preferable, if I would know a way to
do it.

How can I get the FLEXGRID image onto a worksheet?

"Jan Karel Pieterse" wrote:

> Hi Indinfer,
>
> > So, I do not see how to connect the dots. How do I get from the MSFLEXGRID
> > picture to the printer?
>
> Why the flexgrid and not insert a picture directly?
>
> Regards,
>
> Jan Karel Pieterse
> Excel MVP
> http://www.jkp-ads.com
> Member of:
> Professional Office Developer Association
> www.proofficedev.com
>
>

Hi Indinfer,

> So, I
> need to extract what shows on the MSFLEXGRID and print it out. I also need to
> save the image to an Excel worksheet.

Still not sure why you want to use the flexgrid, but anyway, I can't see a way
to print the contents itself. You can print a userform, but that may not be what
you need.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

I inherited this Excel program which uses MSFLEXGRID. I am supposed to debug
it.

One requirement is to print the MSFLEXGRID image.
The other requirement is to store images on a Worksheet.

You seem to think that the problem is that the program uses MSFLEXGRID.
Please tell me what control to substitute that will give me the same image
capabilities but will allow printing its image and allow storing images on a
worksheet.


"Jan Karel Pieterse" wrote:

> Hi Indinfer,
>
> > So, I
> > need to extract what shows on the MSFLEXGRID and print it out. I also need to
> > save the image to an Excel worksheet.
>
> Still not sure why you want to use the flexgrid, but anyway, I can't see a way
> to print the contents itself. You can print a userform, but that may not be what
> you need.
>
> Regards,
>
> Jan Karel Pieterse
> Excel MVP
> http://www.jkp-ads.com
> Member of:
> Professional Office Developer Association
> www.proofficedev.com
>
>

Hi Indinfer,

> You seem to think that the problem is that the program uses MSFLEXGRID.
> Please tell me what control to substitute that will give me the same image
> capabilities but will allow printing its image and allow storing images on a
> worksheet.

Well, I don't know the flexgrid control, but can't you just use a worksheet to
achieve the behaviour you need? And if this has to go on a userform, see if the
spreadsheet control of the Office web components works for you.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

take a look at: http://www.andreavb.com/tip070013.html for some sample code that prints the image of a flexgrid.

It's not quite working for me, but it's a start.

-t

> On Sunday, February 24, 2008 10:40 PM Indinfe wrote:

> I see that MSFLEXGRID has a Picture property. From Intellisense, I get:
>
> Dim grid as MSFLEXGRID
> grid.Picture
>
>
> I see in Intellisense that there is an image object which also has a Picture
> property:
>
> Dim img as Image
> img.Picture
>
>
> So, I would think I could programmatically put an Image object on a
> worksheet using an Add method. Then I can transfer the picture from the
> MSFLEXGRID to the image, something like this:
>
> Set img.Picture = grid.Picture
>
> Then, I can printout the worksheet. That is the goal, to print the picture
> of the MSFLEXGRID.
>
> So, I do not see how to connect the dots. How do I get from the MSFLEXGRID
> picture to the printer?


>> On Monday, February 25, 2008 12:14 AM Jan Karel Pieterse wrote:

>> Hi Indinfer,
>>
>>
>> Why the flexgrid and not insert a picture directly?
>>
>> Regards,
>>
>> Jan Karel Pieterse
>> Excel MVP
>> http://www.jkp-ads.com
>> Member of:
>> Professional Office Developer Association
>> www.proofficedev.com


>>> On Tuesday, February 26, 2008 11:14 PM Indinfe wrote:

>>> I am trying to print the image of the MSFLEXGRID. The MSFLEXGRID control has
>>> text and different cells have different background colors to show data. So, I
>>> need to extract what shows on the MSFLEXGRID and print it out. I also need to
>>> save the image to an Excel worksheet.
>>>
>>> Also, I don't see how to programmatically insert the MSFLEXGRID image
>>> directly onto a worksheet. That would be preferable, if I would know a way to
>>> do it.
>>>
>>> How can I get the FLEXGRID image onto a worksheet?
>>>
>>> "Jan Karel Pieterse" wrote:


>>>> On Wednesday, February 27, 2008 7:33 AM Jan Karel Pieterse wrote:

>>>> Hi Indinfer,
>>>>
>>>>
>>>> Still not sure why you want to use the flexgrid, but anyway, I can't see a way
>>>> to print the contents itself. You can print a userform, but that may not be what
>>>> you need.
>>>>
>>>> Regards,
>>>>
>>>> Jan Karel Pieterse
>>>> Excel MVP
>>>> http://www.jkp-ads.com
>>>> Member of:
>>>> Professional Office Developer Association
>>>> www.proofficedev.com


>>>>> On Sunday, March 02, 2008 9:53 AM Indinfe wrote:

>>>>> I inherited this Excel program which uses MSFLEXGRID. I am supposed to debug
>>>>> it.
>>>>>
>>>>> One requirement is to print the MSFLEXGRID image.
>>>>> The other requirement is to store images on a Worksheet.
>>>>>
>>>>> You seem to think that the problem is that the program uses MSFLEXGRID.
>>>>> Please tell me what control to substitute that will give me the same image
>>>>> capabilities but will allow printing its image and allow storing images on a
>>>>> worksheet.
>>>>>
>>>>>
>>>>> "Jan Karel Pieterse" wrote:


>>>>>> On Monday, March 03, 2008 12:46 AM Jan Karel Pieterse wrote:

>>>>>> Hi Indinfer,
>>>>>>
>>>>>>
>>>>>> Well, I don't know the flexgrid control, but can't you just use a worksheet to
>>>>>> achieve the behaviour you need? And if this has to go on a userform, see if the
>>>>>> spreadsheet control of the Office web components works for you.
>>>>>>
>>>>>> Regards,
>>>>>>
>>>>>> Jan Karel Pieterse
>>>>>> Excel MVP
>>>>>> http://www.jkp-ads.com
>>>>>> Member of:
>>>>>> Professional Office Developer Association
>>>>>> www.proofficedev.com


>>>>>> Submitted via EggHeadCafe
>>>>>> SharePoint 2010 Visual Web Parts using Visual Studio 2010, Feature Designer and Package Designer
>>>>>> http://www.eggheadcafe.com/tutorials...-designer.aspx