Search found 49 matches
- 22 Mar 2018, 17:40
- Forum: Scripts and Functions (v1)
- Topic: Excel_Get
- Replies: 30
- Views: 14695
Re: Excel_Get
I think I chose the wrong bit to comment out. When I moved the semicolon to just after the word "return" in the problem line, it worked. Or perhaps my computer was in a mood, I just restated it for other reasons. anyway, it works! PPTGet Error 4.png I will try and upgrade my AHK version, but I menti...
- 22 Mar 2018, 17:02
- Forum: Scripts and Functions (v1)
- Topic: Excel_Get
- Replies: 30
- Views: 14695
Re: Excel_Get
So, when I tried that, i got two new errors.
The first, when I tried to run it was: The second (when i commented out the line above) was: Possibly a step closer, but still a few bugs
I cannot say how GRATEFUL I am to all of you for working on this.
The first, when I tried to run it was: The second (when i commented out the line above) was: Possibly a step closer, but still a few bugs
I cannot say how GRATEFUL I am to all of you for working on this.
- 22 Mar 2018, 13:32
- Forum: Scripts and Functions (v1)
- Topic: Ppt_Get (like Excel_Get or Word_Get)
- Replies: 8
- Views: 3374
Re: Ppt_Get (like Excel_Get or Word_Get)
Alright, so I gave it a try. It looked very promising and Excel_Get, and Word_Get work just fine. But Ppt_Get is giving the following error message PPTGet Error.png I am using Windows 7, and Office 2010 on a 64 bit computer. And my company handles people healthcare information, so the security is PA...
- 22 Mar 2018, 13:28
- Forum: Scripts and Functions (v1)
- Topic: Word_Get.ahk - use instead of ComObjActive
- Replies: 7
- Views: 2452
Re: Word_Get.ahk - use instead of ComObjActive
Worked PERFECTLY for me. Allowed me to update an existing script, rather than start from scratch when a department asked me to automate the transfer of word documents from one template to another. MANY THANKS!
- 22 Mar 2018, 13:26
- Forum: Scripts and Functions (v1)
- Topic: Excel_Get
- Replies: 30
- Views: 14695
Re: Excel_Get
Alright, so I gave it a try. It looked very promising, but I got the attached error.
I am using Windows 7, and Office 2010 on a 64 bit computer. And my company handles people healthcare information, so the security is PARANOID
Any ideas?
I am using Windows 7, and Office 2010 on a 64 bit computer. And my company handles people healthcare information, so the security is PARANOID
Any ideas?
- 15 Feb 2018, 16:07
- Forum: Ask for Help (v1)
- Topic: Excel_Get is AMAZING, could someone make a PowerPoint_Get?
- Replies: 5
- Views: 2127
Re: Excel_Get is AMAZING, could someone make a PowerPoint_Get?
My code is VERY basic. Merely doing oPPT := ComObjCreate("PowerPoint.Application") creates "Error x080080005 Server execution failed". I get the same error message when I try that with oWkbk := ComObjCreate("Excel.Application") However, oWkbk := Excel_Get() works. So far as I can tell, this is becau...
- 15 Feb 2018, 12:51
- Forum: Ask for Help (v1)
- Topic: Excel_Get is AMAZING, could someone make a PowerPoint_Get?
- Replies: 5
- Views: 2127
Excel_Get is AMAZING, could someone make a PowerPoint_Get?
So, a few months ago, so code I had for Excel stopped working after my company changed some security settings. I despaired of being able to control Excel with AHK again, when I came across "Excel_Get". It is wonderful! It saved my script, and saved me and my company hundreds of hours. However, now I...
- 15 Feb 2018, 11:57
- Forum: Ask for Help (v1)
- Topic: "Enable All Features" in Adobe Acrobat (Work Around)
- Replies: 8
- Views: 6333
Re: "Enable All Features" in Adobe Acrobat (Work Around)
I eventually found a work around. It involved using "FindClick()" to click on the "Enable All" button. It is not as reliable as I would have preferred, but it will do.
- 14 Feb 2018, 20:04
- Forum: Scripts and Functions (v1)
- Topic: Excel_Get
- Replies: 30
- Views: 14695
Re: Excel_Get
This script is AMAZING and successfully work on Excel on my company computer, despite various server-permission things that they do. HOWEVER, I am getting the exact same error messages for ComObjCreate("PowerPoint.Application") that I used to get for ComObjCreate("Excel.Application"). The ones which...
- 07 Feb 2018, 13:52
- Forum: Ask for Help (v1)
- Topic: "Enable All Features" in Adobe Acrobat (Work Around)
- Replies: 8
- Views: 6333
Re: "Enable All Features" in Adobe Acrobat
Bump for help today. Anyone have any suggestions?
- 06 Feb 2018, 14:12
- Forum: Ask for Help (v1)
- Topic: "Enable All Features" in Adobe Acrobat (Work Around)
- Replies: 8
- Views: 6333
Re: "Enable All Features" in Adobe Acrobat
I didn't see anything useful, but I could be wrong. See attached screen shot.
- 06 Feb 2018, 13:41
- Forum: Ask for Help (v1)
- Topic: "Enable All Features" in Adobe Acrobat (Work Around)
- Replies: 8
- Views: 6333
Re: "Enable All Features" in Adobe Acrobat
See picture below.
When you open a file from an "unsafe location", it opens in Protected view.- 06 Feb 2018, 13:04
- Forum: Ask for Help (v1)
- Topic: "Enable All Features" in Adobe Acrobat (Work Around)
- Replies: 8
- Views: 6333
Re: "Enable All Features" in Adobe Acrobat
Bump for help!
- 05 Feb 2018, 14:20
- Forum: Ask for Help (v1)
- Topic: "Enable All Features" in Adobe Acrobat (Work Around)
- Replies: 8
- Views: 6333
"Enable All Features" in Adobe Acrobat (Work Around)
So, I am currently working on a script to automate the downloading of a file as a PDF, then opening up the file in Adobe Acrobat, then saving it as a PowerPoint, then formatting it in PowerPoint. So far, I have managed to automate the downloading of the file, despite the fact that almost nothing on ...
- 25 Jan 2018, 12:32
- Forum: Ask for Help (v1)
- Topic: [SOLVED] How do you reference an iframe in IE11 with no ID? Topic is solved
- Replies: 2
- Views: 818
Re: [SOLVED] How do you reference an iframe in IE11 with no ID? Topic is solved
That works! Many Thanks.
- 24 Jan 2018, 19:27
- Forum: Ask for Help (v1)
- Topic: [SOLVED] How do you reference an iframe in IE11 with no ID? Topic is solved
- Replies: 2
- Views: 818
[SOLVED] How do you reference an iframe in IE11 with no ID? Topic is solved
So, I am trying to automate the pushing of a button on a website. The button that I want is within an iframe. So far, so good, I have worked with and around those before. But this one has me flumoxed. Below is the HTML defining it <iframe title="data visualization" src="http://tableau.uhc.com/views/...
- 21 Jun 2017, 12:31
- Forum: Ask for Help (v1)
- Topic: Other causes for "Error: 0x800401E3" for Microsoft Office?
- Replies: 2
- Views: 3566
Re: Other causes for "Error: 0x800401E3" for Microsoft Office?
You are right, I should have explained what code I was using, it is: [/oExcel := ComObjActive("Excel.Application") ; try to access active Workbook object code] It had been working for months until now. Then, a few weeks ago, it stopped. I tried adding the code you listed to my existing script, and i...
- 20 Jun 2017, 13:01
- Forum: Ask for Help (v1)
- Topic: Other causes for "Error: 0x800401E3" for Microsoft Office?
- Replies: 2
- Views: 3566
Other causes for "Error: 0x800401E3" for Microsoft Office?
Greetings all, I have been running an AutoHotKey Script on my company computer to control Excel successfully for the best part of a year. But, in the last few weeks, something has gone wrong. And now, every time I try to run the script, I get the "Error: 0x800401E3" message. It appears that AutoHotK...
- 14 Oct 2016, 17:47
- Forum: Ask for Help (v1)
- Topic: Controling a FileSelectFile with COM commands
- Replies: 2
- Views: 1161
Controling a FileSelectFile with COM commands
So, I am trying to automate a document upload process. First you have to enter a large amount of metadata, then you have to select the file to upload and then you are done. Inputting the metadata was far more complicated than it needed to be, but I have finally reached the second part. However, the ...
- 05 Aug 2016, 17:18
- Forum: Ask for Help (v1)
- Topic: [SOLVED] Translate a useful Excel script from VBA to AHK
- Replies: 3
- Views: 1726
Re: [SOLVED] Translate a useful Excel script from VBA to AHK
Thanks! Sorry, I am just nervous about the more complicated "for" syntax