Recent content by JensKKK

Thanks combo. Problem solved.

I have created a multipage on a form and I would like to select one of the tabs (page1 /page 2) when loading the form. I have tried a couple of the commands that come up when userform1.mulitpage1.xy however I cant' find the right command to select page1 or page2. Any suggestions are welcome...

I tried you code on a worksheet (with no formulas) with a resize of 100x200. Both your code and misterstick works practically instantly with xl 2007. ck1999 That is interesting. I have only one computer with ms excel 2007 and that b.. is really slow when deleting content (we are talking here...

John, Thanks for your suggestions. I tried your code, but it does not make any difference. Excel 2007 still runs very slow. It must be something else.

Thanks for your suggestion macropod, It is correct that I create the graphs in MS Excel and then send them to MS Word. I have not considered to create link, because I was not aware of them. Would you mind to give me a code example on how to make it. Cheers

Gerry, I did not copy the whole code in my post (it would have been very long). I am using selection very often and I don't use range at all. Is there an explanation why range is better than selection? Do Until weiter = False 'Text in kleinen Portionen in Word drucken If word_out Then...

Thanks simian, this is also my experience. Jens

I have written a program that generates a report that can be viewed in MS Excel and MS Word. Whereas MS Excel is happy to display a couple of 1000 graphs, MS Word goes mad when pasting in more than 100 graphs. MS Word also becomes pretty slow when pumping in so many data. Is that a limitation...

PHV that is the solution. -> replacing the " " with the % does the trick. Many thanks

Shell ("cmd.exe /c start mailto:email@address.com?Subject=""This is a test""&body=Test") give a error message. Commandline argument not valid

Subject="This is a test" Seems not compatible with the shell syntax. Shell ("cmd.exe /c start mailto:email@address.com?Subject=This is a test&body=Test")

using "_" works kind of, but does not look brilliant. Or? This_is_a_test

Tried to add the subject. Which worked partially. It displays "This" and then nothing. It looks like the that I have to replace the " " with something. What should I use?

Do you know how to write some text in the Re: and body text?

Genius. Code worked right out of the box. Thanks very much.