Search found 9 matches

by wodzu
27 Feb 2022, 16:07
Forum: Ask for Help (v1)
Topic: PDFCreator 3.2 + COM Interface Topic is solved
Replies: 3
Views: 600

Re: PDFCreator 3.2 + COM Interface Topic is solved

flyingDman , my bad, didn't explain what I intend to do. I need to create a formatted table document. Excel isn't an option, because on the target PC there's no Office. Figured that I would create a formatted HTML document and then convert it into PDF. I was also thinking about making a RTF documen...
by wodzu
27 Feb 2022, 13:10
Forum: Ask for Help (v1)
Topic: PDFCreator 3.2 + COM Interface Topic is solved
Replies: 3
Views: 600

PDFCreator 3.2 + COM Interface Topic is solved

Hi everyone, I'm trying to convert an example code of the VBA Word file to AHK script, unfortunately cannot find nothing on the web, just this topic which seems to show scripts that are working with some older versions of PDFCreator: https://www.autohotkey.com/board/topic/63736-createconvert-to-pdf-...
by wodzu
03 Feb 2020, 15:30
Forum: Ask for Help (v1)
Topic: CDO COM - slow script execution when sending email to multiple recipients
Replies: 4
Views: 846

Re: CDO COM - slow script execution when sending email to multiple recipients

How long does it take? Also you are presumably using (i.e. in quotes) ListOfUsers := "abc@abc.com; def@def.com; qwe@qwe.com; tyu@tyu.com; iop@iop.com" It takes about 3-4 minutes for ca. 30 recipients. If i set it between quotes I'll become an error message: 0x8004020C - At least one recipient is re...
by wodzu
03 Feb 2020, 13:17
Forum: Ask for Help (v1)
Topic: CDO COM - slow script execution when sending email to multiple recipients
Replies: 4
Views: 846

CDO COM - slow script execution when sending email to multiple recipients

Hi all, I'm using the CDO Com scripting for sending emails using a corresponding SMTP server. Bunch of recipients (ca. 30) are stored in a variable: ListOfUsers := abc@abc.com; def@def.com; qwe@qwe.com; tyu@tyu.com; iop@iop.com; etc. and then triggered by a standard command: pmsg.To := ListOfUsers U...
by wodzu
28 Jan 2020, 02:13
Forum: Ask for Help (v1)
Topic: Publishing Excel sheet to .html using VBA/COM Topic is solved
Replies: 3
Views: 1043

Re: Publishing Excel sheet to .html using VBA/COM Topic is solved

Thank you both @teadrinker and @FanaticGuru, I figured it out with the values for Excel constants. @FanaticGuru , your code does exactly what I need!
by wodzu
27 Jan 2020, 08:15
Forum: Ask for Help (v1)
Topic: Publishing Excel sheet to .html using VBA/COM Topic is solved
Replies: 3
Views: 1043

Publishing Excel sheet to .html using VBA/COM Topic is solved

Hi everyone, could anyone help me with translating a VBA code to AHK? I want to publish an Excel sheet to a formatted .html file, this is how it in Excel VBA looks like: With ActiveWorkbook.PublishObjects.Add(xlSourceAutoFilter, _ "D:\mailsend-go-dir\123.htm", "Sheet1", "", xlHtmlStatic, "123_4257",...
by wodzu
26 Feb 2019, 02:10
Forum: Ask for Help (v1)
Topic: Paste range of cells from Excel to Outlook using COM Topic is solved
Replies: 3
Views: 1129

Re: Paste range of cells from Excel to Outlook using COM Topic is solved

ComObjActive("Excel.Application").Worksheets(1).Range("A4:C5").Copy Outlook := ComObjCreate("Outlook.Application") email := Outlook.Application.CreateItem(0) email.Display Outlook.ActiveInspector.WordEditor.Application.Selection.Paste Outlook := email := "" Thank you, it works perfectly! Is it poss...
by wodzu
25 Feb 2019, 10:11
Forum: Ask for Help (v1)
Topic: Paste range of cells from Excel to Outlook using COM Topic is solved
Replies: 3
Views: 1129

Paste range of cells from Excel to Outlook using COM Topic is solved

Hi all, I'm struggling with the following problem - I want to copy some range of cells in Excel and paste it as a table (with formatting) to a new e-mail in Outlook. The problem is I don't know how can I paste it in the email body. Any ideas? Or is there any possibility to do this with email.htmlbod...
by wodzu
06 Dec 2018, 02:32
Forum: Scripts and Functions (v1)
Topic: BARCODER - Create 1D and 2D Barcodes (QRCode , C39,etc)
Replies: 106
Views: 74698

Re: BARCODER - Create 1D and 2D Barcodes (QRCode , C39,etc)

First of all, I would like to thank you @Gio for this awesome script you made - brilliant job! I am using this part of your code that generates a 128 barcode. It works very good for my purpose but I need to make it bigger somehow. I'm printing this barcode on a Zebra printer and the quality is not g...

Go to advanced search