How can I save a picture as jpg file in MS Excel 2

[JensKKK]

What I want to do is to insert a graph into a form and present to the user.

One way of achieving that could be to use the copypicture command (I know haow to do that) and then save it to the hard disc as a jpeg file (but I don't know how to do this) and then insert it into the form property.

My questions are:

a) is that the right strategy?
b) if a)=true then how can I save the picture as jpeg file?
c) if a)=false what would you do.

Any suggestions welcome.

Thanks

 

[yogia]

Hi JensKKK:

After you copy the picture, then one way would be to ...

1) paste in a graphics program such as IrfanView, and then
2) Save it As a JPEG file

Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC

http://www.energyefficientbuild.com

 

[JensKKK]

Yes that is one way of doing it. Maybe I did not spell it out properly in my introduction, but I wnat to do that wihtin my VB code so I can present some on the fly calculated data in a form.

Thanks for suggestion.

 

[combo]

If you accept popup dialog with chart, use excel 5 dialog:
1) insert dialog sheet (right-click sheet's tab, Insert..., and choose excel 5 dialog,
2) locate your chart on this dialog,
3) customize dialog, and hide the sheet,
4) code under button on the userform:
ThisWorkbook.DialogSheets(1).Show

combo

 

[JensKKK]

Combo,

Very nice idea.

Is there a way of copy pasting a new graph into the dialog while the program is running?

Or is this dialog static?

 

[combo]

If you choosen dialog sheet as a location for the graph, it will be 'live', any change in source data will be reflected on the chart. Excel 5 dialog sheet is one of possible sheet types, so the chart will behave as on worksheet (however will be locked for edition in 'show' mode).
After some downgrading you can make it interactive - form controls ('Forms' toolbar): spinners, scrollbars etc. can be linked with worksheet and changing chart data; you will be able to control it without single line of code (except the 'Show' method).

combo

 

[combo]

And another unique feature: you can display it from modal userform and interact with both.

combo

 

[JensKKK]

Wow that was a brilliant suggestion.

I like the interactive capabillity of the dialogue.

Jens

 

[Chance1234]

learn something new every day, have a star

Chance,

F, G + _HH

 

[combo]

Thanks, however this interface is so old that MS stopped to support it.

combo