Search found 14 matches

by danotto94
25 Sep 2015, 12:39
Forum: Ask For Help
Topic: COM unzip in Windows 7
Replies: 1
Views: 881

COM unzip in Windows 7

I tried http://www.autohotkey.com/board/topic/6 ... ta7-ahk-l/ and another script. Both produce a new folder with a direct access to My Computer (if that's the correct translation). Any ideas?
by danotto94
16 Sep 2015, 10:26
Forum: Ask For Help
Topic: How do you install and use Xpdf?
Replies: 1
Views: 1684

How do you install and use Xpdf?

I don't understand the instructions. I downloaded the Windows version, copied the unzipped folder to a newly-created Xpdf folder in program files, pasted, and typing xpdf or one of the binary titles says command not found.
by danotto94
15 Sep 2015, 10:35
Forum: Ask For Help
Topic: Increment certain cell references by certain numbers in COM Excel?
Replies: 1
Views: 1309

Increment certain cell references by certain numbers in COM Excel?

E.g. if there are cells like C1, D1, etc. and underneath are C2, D2, etc., and I want to change all their numbers to one or two higher, what's the COM method?
by danotto94
14 Aug 2015, 11:30
Forum: Ask For Help
Topic: Download an attachment in an Outlook email (COM?)
Replies: 12
Views: 4612

Re: Download an attachment in an Outlook email (COM?)

Thanks. Where can I read about the Folder ? Folder : A_Desktop syntax? Also, I saw posts explaining how to sort sheets by currency, but I don't get how to translate

Code: Select all

With Sheets("helpsheet").Range("a1").CurrentRegion
    .Sort Key1:=Range("B1"), Order1:=xlDescending, Header:=xlYes
End With
to AHK.
by danotto94
13 Aug 2015, 12:38
Forum: Tutorials
Topic: Nice COM tutorial on MSDN
Replies: 0
Views: 3116

Nice COM tutorial on MSDN

https://msdn.microsoft.com/en-us/librar ... 92737.aspx

There's more on the sidebar on the left in the link.
by danotto94
12 Aug 2015, 17:41
Forum: Tutorials
Topic: GUI - How-to draw a line / frame
Replies: 5
Views: 6852

Re: GUI - How-to draw a line / frame

Cool, but what practical things can this be used for?
by danotto94
12 Aug 2015, 17:36
Forum: Ask For Help
Topic: Shift Left Mouse click to activate Left Mouse Click
Replies: 3
Views: 2171

Re: Shift Left Mouse click to activate Left Mouse Click

Have you searched on (other) forums for answers that may help? I don't know the answer but just asking.
by danotto94
12 Aug 2015, 12:54
Forum: Ask For Help
Topic: Download an attachment in an Outlook email (COM?)
Replies: 12
Views: 4612

Re: Download an attachment in an Outlook email (COM?)

Email I've selected. #3:: O := ComObjActive("Outlook.Application") S := "Mailing" ;The actual attachment has other characters in the end. Se := O.ActiveExplorer.Selection MailItem.Attachments := Se ; Now we can loop through each attachment. ; ie: for each Attachment in the collection... for Attachme...
by danotto94
12 Aug 2015, 12:34
Forum: Ask For Help
Topic: Download an attachment in an Outlook email (COM?)
Replies: 12
Views: 4612

Re: Download an attachment in an Outlook email (COM?)

Thanks but #3:: x := ComObjActive("Outlook.Application") S := "Mailing" ;The actual attachment has other characters in the end. A := MailItem.Attachments ; Now we can loop through each attachment. ; ie: for each Attachment in the collection... for Attachment, in A { N := Attachment.FileName if (InSt...
by danotto94
11 Aug 2015, 16:45
Forum: Ask For Help
Topic: Download an attachment in an Outlook email (COM?)
Replies: 12
Views: 4612

Re: Download an attachment in an Outlook email (COM?)

Interesting. What about the second question?
by danotto94
11 Aug 2015, 15:46
Forum: Ask For Help
Topic: Download an attachment in an Outlook email (COM?)
Replies: 12
Views: 4612

Re: Download an attachment in an Outlook email (COM?)

Thanks for replying. Why is it called Outlook.Attachment in http://stackoverflow.com/questions/1553 ... ename-them if it uses Outlook.MailItem? Also, how do you only download an attachment that has a specific string in its name?
by danotto94
11 Aug 2015, 11:20
Forum: Ask For Help
Topic: Download an attachment in an Outlook email (COM?)
Replies: 12
Views: 4612

Download an attachment in an Outlook email (COM?)

Do I have to use something like ObjMsg.Attachments?
by danotto94
11 Aug 2015, 10:40
Forum: Tutorials
Topic: MS Office COM Basics
Replies: 111
Views: 126401

Re: Basic MS Office COM

To delete columns in Excel, type for example:

Code: Select all

x1.Range("A:H").EntireColumn.Delete
To cut/paste/move cells:

Code: Select all

x1.Range("A1:C6").Select
x1.Selection.Cut
x1.Range("A10").Select
x1.ActiveSheet.Paste
Is there an easier way to do this?

Go to advanced search