Search found 25 matches

by maitresin
23 Aug 2019, 14:07
Forum: Ask For Help
Topic: Excel Com / Variable - Add an extra number into a cell.value
Replies: 2
Views: 292

Excel Com / Variable - Add an extra number into a cell.value

In my B column of Excel I have a number like 1111. I need to add an "8" to the end of each number in that column. Like 1111 need to be 11118 in my Cell.Value - How do I add this to the below?? Find(Cell.Value)

Code: Select all

Wb2.ActiveSheet.Columns("B").Find(Cell.Value).OffSet(0,7).Value := Cell.OffSet(0,8).Value
by maitresin
02 Aug 2019, 11:14
Forum: Ask For Help
Topic: Excel com & copy cell value from 1 excel file to another
Replies: 4
Views: 394

Re: Excel com & copy cell value from 1 excel file to another

ok did not work because of

Code: Select all

Cellpos := A
that should be

Code: Select all

Cellpos = A
Thanks!
by maitresin
01 Aug 2019, 16:39
Forum: Ask For Help
Topic: Excel com & copy cell value from 1 excel file to another
Replies: 4
Views: 394

Excel com & copy cell value from 1 excel file to another

Hi, I need to know why it is not pasting in the second file? Wb2.ActiveSheet.Range(%Cellpos%%Cellpos2%).Cell.Value ; should paste the cell.value into this workbook but it is not... Rangevalue1 := "path...\Output2.csv" GetOrderTracking := "path...\URL.xlsx" Xl := ComObjCreate("Excel.Application") ; O...
by maitresin
25 Jul 2018, 14:41
Forum: Ask For Help
Topic: Excel Com & loop search
Replies: 5
Views: 852

Re: Excel Com & loop search

Ok I have something like this but... How to handle 2 excel file at same time? How to make the Excel2value variable? How to make the value found paste in the correct cells in column G of Excel2 file? I did try but I am not enought confortable with the below Excel com.... any help please? PathExcel1 =...
by maitresin
05 May 2018, 20:51
Forum: Scripts and Functions
Topic: [Library] Chrome.ahk - Automate Google Chrome using native AutoHotkey. No Selenium!
Replies: 164
Views: 56605

Re: [Library] Chrome.ahk - Automate Google Chrome using native AutoHotkey. No Selenium!

Hi, I got 2 questions: 1-How I could save my profil and cookies? I mean if I log into a website I want to be able to launch this chrome and still be logged in my account. 2-How I could download an .html page like the exemple .pdf but .html. It also need to be save cookies and keep connection active ...
by maitresin
08 Apr 2018, 21:41
Forum: Ask For Help
Topic: RegReplace last `n line
Replies: 3
Views: 539

RegReplace last `n line

Why does it delete my last line of value and my last `n ?

Is not supose to delete only last blank line `n ?

Code: Select all

FileRead, FileContents, ID.txt
FileDelete, ID.txt
FileAppend, % RegExReplace(FileContents, "\v+\V+\v*$"), ID.txt
by maitresin
01 Apr 2018, 13:19
Forum: Ask For Help
Topic: Help with if !FileExist
Replies: 31
Views: 2631

Re: Help with if !FileExist

loop, parse, No1, `n, `r

Everything work great now!

All this for an , `r

Thanks so much! headaches are gone!
by maitresin
31 Mar 2018, 23:41
Forum: Ask For Help
Topic: Help with if !FileExist
Replies: 31
Views: 2631

Re: Help with if !FileExist

If my List.txt have only 1 line the fileexist work. If my List.txt have more than 1 line, fileexist does not work. I did a run, %FileFullPath% in the label right before the fileexist. It opened the file (if only 1 line was in the List.txt) If the List.txt contain more than 1 line, it does not open t...
by maitresin
31 Mar 2018, 22:47
Forum: Ask For Help
Topic: Help with if !FileExist
Replies: 31
Views: 2631

Re: Help with if !FileExist

If I'm understanding this, you're saying that, for each file in List.txt (via the call inside the loop, of course), it creates a file of the same name and puts it in a subfolder of the script folder called folder1. Is all of that right? Yes. Is there a way I can check if there is "hidden" characters...
by maitresin
31 Mar 2018, 16:21
Forum: Ask For Help
Topic: Help with if !FileExist
Replies: 31
Views: 2631

Re: Help with if !FileExist

it is file001 no extension
by maitresin
31 Mar 2018, 15:49
Forum: Ask For Help
Topic: Help with if !FileExist
Replies: 31
Views: 2631

Re: Help with if !FileExist

Well, the gosub inside a loop, parse seem to be problematic. Everything work fine in the msgbox debugging but the fileexist seem to not work. add this code into a loop, parse... currentfile variable is the A_LoopField in the loop parse. I dont know why, I run this without the loop, parse thing and i...
by maitresin
31 Mar 2018, 15:23
Forum: Ask For Help
Topic: Help with if !FileExist
Replies: 31
Views: 2631

Re: Help with if !FileExist

FileExist1: CurrentFile = file001 FileFullPath:=A_Scriptdir . "\folder1\" . CurrentFile MsgBox,,debugging,fileexist1 entered for file`n%FileFullPath% sleep, 500 if !FileExist(FileFullPath) { msgbox, file %Currentfile% not exist! [b];it send this message![/b] run, notepad.exe [b]; notepad open![/b] ...
by maitresin
31 Mar 2018, 14:46
Forum: Ask For Help
Topic: Help with if !FileExist
Replies: 31
Views: 2631

Re: Help with if !FileExist

Ignore last reply.

Debugging msgbox appear with the good path and filename.
by maitresin
31 Mar 2018, 14:37
Forum: Ask For Help
Topic: Help with if !FileExist
Replies: 31
Views: 2631

Re: Help with if !FileExist

!FileExist seem to do a FileExist and not a FileNotExist

I did test with a random filename in the folder and it return me the file exist while it is not... O.O
by maitresin
31 Mar 2018, 14:33
Forum: Ask For Help
Topic: Help with if !FileExist
Replies: 31
Views: 2631

Re: Help with if !FileExist

Probably there is something wrong with the path you piece together. What happens when you hardcode an absolute path in !FileExist(...) ? What is the content of List.txt ? What is file.exe doing? Some file operation? We don't have enough information to reproduce your issue, it seems... can you give ...
by maitresin
31 Mar 2018, 14:05
Forum: Ask For Help
Topic: Help with if !FileExist
Replies: 31
Views: 2631

Re: Help with if !FileExist

Yes it is work because as said in previous reply: "The file is in the folder1 with exactly the same name and it keep telling me the msgbox like if the file was not in the folder1" It does work but does not find the file... that is really weird. file is in the folder1, then the gosub execute. The !fi...
by maitresin
31 Mar 2018, 10:21
Forum: Ask For Help
Topic: Help with if !FileExist
Replies: 31
Views: 2631

Re: Help with if !FileExist

I did Joe solution but It still not working. file.exe create a file with exactly the same name as the value in the list.txt if !FileExist(A_Scriptdir . "\folder1\" . CurrentFile) ; C:\....scriptdir\folder1\file001 please note file001 is the file and not a folder. { msgbox, %Currentfile% ; show the A...
by maitresin
30 Mar 2018, 22:23
Forum: Ask For Help
Topic: Help with if !FileExist
Replies: 31
Views: 2631

Help with if !FileExist

fileread, No1, List.txt loop, parse, No1, `n { Runwait %comspec% /c ""%A_Scriptdir%\file.exe" "Folder1"",,hide sleep, 200 gosub, fileexist1 sleep, 100 Traytip, FileNow1, Loop: %A_LoopField% Sleep, 100 } msgbox, done! exitapp return fileexist1: if !FileExist(A_Scriptdir . "\folder1\" . A_LoopField) ...
by maitresin
26 Mar 2018, 22:00
Forum: Gaming
Topic: Timer into a loop, parse
Replies: 1
Views: 299

Timer into a loop, parse

Hello,

Could you give an exemple of a timer inside a loop, parse please?

I mean, I need to do 5 time the loop and pause 5 minutes... until the full loop, parse is done.

Thanks!
by maitresin
23 Mar 2018, 21:08
Forum: Ask For Help
Topic: Help with Excel Com
Replies: 1
Views: 303

Help with Excel Com

Hi, I have a .txt file with many of the following value: 11111111111111 a1b2c3d4e5f6g ; There is 2 value separated by a space And I have an Excel sheet with the same or different value in column A and B. It is the same lenght. What I need to do is look into the .txt the first sequence of data (11111...

Go to advanced search