Search results for query: *

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.

PHV, I think I could get it work with Outlook, but I am writing a piece of software that should be of general use (and not everybody is using Outlook, but use Lotus Notes instead ...). Thanks anyway. I might try to send a email via MS Word that could be an alternative.

Well the title says already what I want to do. Ideally I would like to open the default email editor on a computer when a command buten is pressed. Second question: can I insert the email address in the To field of the email? Many thanks for reading.

Hi, I used the two lines of code to display the data in a form. And I want to display the current time as well. How can I do that? Thanks for reading til here. Sheets("my Sheet").Cells(130, 22).value = Date Label6.Caption = Sheets("my Sheet").Cells(130, 22)

This is the code that worked best for me. With ActiveDocument.InlineShapes(ActiveDocument.InlineShapes.Count) .Fill.Visible = msoFalse .Fill.Solid .Fill.Transparency = 0# .Line.Weight = 0.75 .Line.Transparency = 0# .Line.Visible = msoFalse .LockAspectRatio = msoTrue...

Thanks for the many suggestions. I will test them and will report back. Thanks again.