Search:

Type: Posts; User: ReeveCZE; Keyword(s):

Search: Search took 0.00 seconds.

  1. Replies
    2
    Views
    166

    Re: Excel -> Outlook embedded image

    Well, there seems to be a difference between MailItem.Close and MailItem.GetInspector.Close.
    I'm afraid I don't understand it exactly, but the the following works:


    With outMail
    ...
  2. Replies
    2
    Views
    166

    Re: Excel -> Outlook embedded image

    After some investigaiton I found out the problem is .GetInspector.
    If I comment that line I can generate 600 mails with attachments and embedded images, however, the image is not displayed properly....
  3. Replies
    2
    Views
    166

    Excel -> Outlook embedded image

    Hi guys,

    I'm having some hard time with the following.
    I have a For - Next loop in Excel that generates an Outlook MailItem drafts with embedded image using ContentID.



    Dim outApp as Object...
  4. Replies
    1
    Views
    206

    Selection -> Range -> Chart

    Hey guys,

    since I am a real loser at using range, I gotta ask you the following.

    I want to create a chart from an area of data. Please see the following code and tell me what I am doing wrong....
  5. Thread: Decimal comma

    by ReeveCZE
    Replies
    4
    Views
    397

    Re: Decimal comma

    Awesome, that works! Adding 0 to each range is enough to convert it to number.

    Thank you.
  6. Thread: Decimal comma

    by ReeveCZE
    Replies
    4
    Views
    397

    Re: Decimal comma

    Yes, that's the second part of the code. Works manually, not in a macro... it really replaces the dots with commas, but somehow messes up the cell format...


    Selection.Replace What:=".",...
  7. Thread: Decimal comma

    by ReeveCZE
    Replies
    4
    Views
    397

    Decimal comma

    Hi,

    I have a sheet full of numbers, but I need to change their format to my native (that is Czech) where we use a decimal comma instead of a decimal point. Otherwise, my Excel won't add up or...
Results 1 to 7 of 9