AutoHotkey Community

Crashm87

I have a website with multiple frames and had many issues getting into it. After extensive forum search and alot of help, these 2 snippets of code are what work for me. IEGet(name="") { IfEqual, Name,, WinGetTitle, Name, ahk_class IEFrame ;// Get active window if no parameter Name := (Name="New Tab ...

Crashm87

Hello Forum, Wondering if anyone can lend a helping hand. I have wrote a script I use to keep a simple database to keep track of information from incoming calls at work. (vs standard pen and paper). It all works great so far relying heavily on the forums for CSV help and functions. Now I'm wondering...

Crashm87

That seems to have done the trick. Thanks alot.

Crashm87

Morning all, I stumbled accross a thread last night that suggested using functions throught scripts in place of goto, or gosub. I thought I would give it a try, I am still learning functions, so I thought I would learn as I go and see if I can replace some subs in a script I have. The script takes b...

Crashm87

Here is example code

Code: Select all

!w::
Send, ^c
Sleep 200
wiki := "https://en.wikipedia.org/wiki/"
clip = %Clipboard%
StringReplace, clip, clip, %A_Space%,_, All
;MsgBox %wiki%%clip%   ;debug
Run, chrome.exe %wiki%%Clip%
return

With this, you should be able to apply the same thing to your Amazon searches

Crashm87

Web addresses don't support spaces in them, so when you are copying more than one word, the space is seen as a new tab. You would have to StringReplace the space with either a _ and if a Wiki page exists for those words, it will load it.
Example:
https://en.wikipedia.org/wiki/Panel_painting

Crashm87

Hello everyone, I've noticed something weird lately when using ClipJump. When I try and copy text from a PDF file (Abode Reader DC), it won't transfer to Clipjump, it doesn't copy at all. Today I tried CNTRL+, I pressed it 10 times and finally it copied it to the clipjump. Next try, worked on the fi...

Crashm87

Morning Community, I have a script I have written to take information from Gui Edit boxes and push them to excel sheet to make labels. The script searches an old database to see if the label has been made before, if it has it pulls all the data to sheet from database. If it hasn't been made, it open...

Crashm87

Try this, I tested it on a workbook of mine, and it selected the cell containing my search FilePath := "..." ; ENTER WORKBOOK PATH HERE oExcel := ComObjActive("Excel.Application") oWorkbook := ComObjGet(FilePath) dataBase := oWorkbook.WorkSheets("Sheet1") InputBox, LookFor, Search, Enter Search Crit...

Crashm87

Thank you both very much. 4GForce , your last post worked perfectly. Thank you very much, I think I am starting to understand the classes for making that GUI. Yeah, Lexikos is right, I went a bit off track with this one. It was the classes I didn't understand, but it is nice to know that there is an...

Crashm87

I'm not sure if this will work, but this is the first thing I thought of.

Code: Select all

oExcel := ComObjActive("Excel.Application")
range := oExcel.Range("b:b")

if range.find("p") oexcel.activecell.entirerow.cells(1,2)).select
if range.find("a") oexcel.activecell.entirerow.cells(1,2)).select

Crashm87

Thanks again for the help. I ran this, and it kept asking for static variable for vCNumberTxt , I removed the v from the front, and it displayed the GUI, but no information. I added the other comma after Add, Text , like this Gui CMB:Add, Text, vCNumberTxt and it showed the information. So I added t...

Crashm87

Sorry, here is the entire script. Labels in a loop :sick: Hard to fully test without the excel file but I tested the loop part and this works ... #SingleInstance Force FilePath := "C:\Users\Tammy\Desktop\2016 SUMMER TIRES FINAL.xlsx" oExcel := ComObjCreate("Excel.Application") ;~ oExcel.Workbooks.O...

Crashm87

Sorry, here is the entire script. #SingleInstance Force FilePath := "C:\Users\Tammy\Desktop\2016 SUMMER TIRES FINAL.xlsx" oExcel := ComObjCreate("Excel.Application") ;~ oExcel.Workbooks.Open(FilePath) ;~ oExcel.Visible := true oWorkbook := ComObjGet(FilePath) dataBase := oWorkbook.WorkSheets("Sheet1...

Crashm87

How about: framecount := document.parentWindow.frames.length framecount -= 1 ; subtract 1 to get the right number of the array myFrame := wb.document.parentWindow.frames[framecount].document.body.innerHTML msgbox % myFrame This will always target the last frame on the page. That's assuming, of cour...

Crashm87

Thanks for the answers. @Helgef, that is working, it displays the messagebox, however doesn't continue looping when I press no, which I can't figure out. @4GForce, I implemented yours into the middle of my loop, and same thing, I can get a msgbox to appear, but I can't get loop to continue when pres...

Crashm87

enter8 wrote:There may be a better way, but you can get the number of frames with

document.parentWindow.frames.length

Thank you, that helps alot.

Maybe I'll implement an IF statement and store number of frames in a variable.

Crashm87

Hello, I made a custom GUI to replace my messagebox so I could change the font, but I can't get the controls of the buttons to work the same way they do when inside a loop. My messagebox code is: MsgBox,3, Customer Storage Information ,% "Row number: " c.row "`n" . "Customer Number : " cnumber "`n" ...

Crashm87

Thank you. That pointed me EXACTLY where I needed to go. I was able to figure out what the problem is from your post, and not sure if there is way to 'work around' this or not. What's happening is, the frame count changes depending on how my browser reaches the screen. If it is the first time I go t...

Crashm87

are you trying to close a window by pressing Up+&?

Search found 48 matches

Re: IE iframe and frame

Listview from GUI to Email

Re: Assistance with Functions Topic is solved

Assistance with Functions Topic is solved

Re: Need help with Run, %clipboard% command

Re: Need help with Run, %clipboard% command

Re: [Looking for Maintainers/Successors] Clipjump : The Ultimate Clipboard Manager

Gui data to Excel Sheet

Re: How to find multipal letters in a column in ms excel by these codes?

Re: Custom GUI to replace Msgbox

Re: How to find multipal letters in a column in ms excel by these codes?

Re: Custom GUI to replace Msgbox

Re: Custom GUI to replace Msgbox

Re: Custom GUI to replace Msgbox

Re: Frames and COM Topic is solved

Re: Custom GUI to replace Msgbox

Re: Frames and COM Topic is solved

Custom GUI to replace Msgbox

Re: Frames and COM Topic is solved

Re: Script doesn't work