Recently Browsing 0 members
No registered users viewing this page.
I am trying to paste a range with a chart from excel WB to outlook new email.
The problem is i cant paste it with the formatting - it shows as text.
I am using Selection.Copy from excel and i am trying to paste it in outlook newly created mail.
If i go manually and use CTRL+V in the mail - it works. I tried the <Clipboard.au3> functions but i cant get it to work.
I also tried converting this VBA:
Sub PasteFormattedTable() Dim Doc As Word.Document Dim wdRn As Word.Range Dim Xl As Excel.Application Dim Ws As Excel.Worksheet Dim xlRn As Excel.Range Set Doc = Application.ActiveInspector.WordEditor Set wdRn = Doc.Range Set Xl = GetObject(, "Excel.Application") Set Ws = Xl.Workbooks("Mappe1.xls").Worksheets(1) Set xlRn = Ws.Range("b2", "c6") xlRn.Copy wdRn.Paste End SubAny ideas ?
I'm about to start working on a log building script and I was thinking about using an external ini file to control settings for the application that the user can edit and have the script use the new settings. Does anyone have any examples by chance of something simple? I just need an idea to help me get started.