Search found 49 matches

by clina1j
22 Mar 2018, 17:40
Forum: Scripts and Functions
Topic: Excel_Get
Replies: 17
Views: 4190

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...
by clina1j
22 Mar 2018, 17:02
Forum: Scripts and Functions
Topic: Excel_Get
Replies: 17
Views: 4190

Re: Excel_Get

So, when I tried that, i got two new errors.

The first, when I tried to run it was:
PPTGet Error 3.png
PPTGet Error 3.png (7.41 KiB) Viewed 3185 times
The second (when i commented out the line above) was:
PPTGet Error 2.png
PPTGet Error 2.png (28.57 KiB) Viewed 3185 times
Possibly a step closer, but still a few bugs

I cannot say how GRATEFUL I am to all of you for working on this.
by clina1j
22 Mar 2018, 13:32
Forum: Scripts and Functions
Topic: Ppt_Get (like Excel_Get or Word_Get)
Replies: 8
Views: 1374

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...
by clina1j
22 Mar 2018, 13:28
Forum: Scripts and Functions
Topic: Word_Get.ahk - use instead of ComObjActive
Replies: 5
Views: 747

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!
by clina1j
22 Mar 2018, 13:26
Forum: Scripts and Functions
Topic: Excel_Get
Replies: 17
Views: 4190

Re: Excel_Get

Alright, so I gave it a try. It looked very promising, but I got the attached error.
PPTGet Error.png
PPTGet Error.png (8.77 KiB) Viewed 3218 times
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?
by clina1j
15 Feb 2018, 16:07
Forum: Ask For Help
Topic: Excel_Get is AMAZING, could someone make a PowerPoint_Get?
Replies: 5
Views: 876

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...
by clina1j
15 Feb 2018, 12:51
Forum: Ask For Help
Topic: Excel_Get is AMAZING, could someone make a PowerPoint_Get?
Replies: 5
Views: 876

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...
by clina1j
15 Feb 2018, 11:57
Forum: Ask For Help
Topic: "Enable All Features" in Adobe Acrobat (Work Around)
Replies: 8
Views: 1079

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.
by clina1j
14 Feb 2018, 20:04
Forum: Scripts and Functions
Topic: Excel_Get
Replies: 17
Views: 4190

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...
by clina1j
07 Feb 2018, 13:52
Forum: Ask For Help
Topic: "Enable All Features" in Adobe Acrobat (Work Around)
Replies: 8
Views: 1079

Re: "Enable All Features" in Adobe Acrobat

Bump for help today. Anyone have any suggestions?
by clina1j
06 Feb 2018, 14:12
Forum: Ask For Help
Topic: "Enable All Features" in Adobe Acrobat (Work Around)
Replies: 8
Views: 1079

Re: "Enable All Features" in Adobe Acrobat

I didn't see anything useful, but I could be wrong. See attached screen shot.
Window Spy Info.png
Window Spy Info.png (37.08 KiB) Viewed 1039 times
by clina1j
06 Feb 2018, 13:41
Forum: Ask For Help
Topic: "Enable All Features" in Adobe Acrobat (Work Around)
Replies: 8
Views: 1079

Re: "Enable All Features" in Adobe Acrobat

See picture below.
Protected view File.png
Protected view File.png (20.74 KiB) Viewed 785 times
When you open a file from an "unsafe location", it opens in Protected view.
by clina1j
05 Feb 2018, 14:20
Forum: Ask For Help
Topic: "Enable All Features" in Adobe Acrobat (Work Around)
Replies: 8
Views: 1079

"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 ...
by clina1j
24 Jan 2018, 19:27
Forum: Ask For Help
Topic: [SOLVED] How do you reference an iframe in IE11 with no ID? Topic is solved
Replies: 2
Views: 332

[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/...
by clina1j
21 Jun 2017, 12:31
Forum: Ask For Help
Topic: Other causes for "Error: 0x800401E3" for Microsoft Office?
Replies: 2
Views: 545

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...
by clina1j
20 Jun 2017, 13:01
Forum: Ask For Help
Topic: Other causes for "Error: 0x800401E3" for Microsoft Office?
Replies: 2
Views: 545

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...
by clina1j
14 Oct 2016, 17:47
Forum: Ask For Help
Topic: Controling a FileSelectFile with COM commands
Replies: 2
Views: 587

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 ...
by clina1j
05 Aug 2016, 17:18
Forum: Ask For Help
Topic: [SOLVED] Translate a useful Excel script from VBA to AHK
Replies: 3
Views: 973

Re: [SOLVED] Translate a useful Excel script from VBA to AHK

Thanks! Sorry, I am just nervous about the more complicated "for" syntax

Go to advanced search