Search found 24 matches

by Bad husband
01 Oct 2018, 22:05
Forum: Ask For Help
Topic: Excel save as not always working
Replies: 3
Views: 138

Re: Excel save as not always working

I just finish running additional tests on my script and what I’m noticing is that the webpage opens the excel file but it is like it is not the active workbook therefore the script just copies the previous file therefore the data is not updated. Once the webpage opens the excel file and I move my mo...
by Bad husband
01 Oct 2018, 19:52
Forum: Ask For Help
Topic: Excel save as not always working
Replies: 3
Views: 138

Excel save as not always working

Need help to figure out how to make my script save the active workbook all the time. I have a script that I might run every 2-3 days so the table info is updated with current numbers. Basically the script opens a chrome webpage which by default opens an excel workbook. The active workbook is saved a...
by Bad husband
17 Aug 2018, 22:02
Forum: Ask For Help
Topic: Help adding a loop to this code
Replies: 0
Views: 132

Help adding a loop to this code

I found this code from member Kon that I would like to use for a small script but I just can’t understand the looping of the scripts. Is there a useful tutorial on creating loops for excel projects? Here is the code. Basically I want it to go thru each neighboring columns D & E until there is a blan...
by Bad husband
16 Aug 2018, 19:23
Forum: Ask For Help
Topic: gui question control loses selection
Replies: 2
Views: 198

gui question control loses selection

I'm playing with a Calendar script I found on this wonderful site. The GUI opens up and you have the calendar, I select the date and then select value from the dropdown list but my calendar selection becomes clear and I need to select the date again. Is there a way that it doesn't lose the first sec...
by Bad husband
11 Aug 2018, 14:16
Forum: Ask For Help
Topic: Excel loop from text file.. paste results in new spreadsheet
Replies: 0
Views: 108

Excel loop from text file.. paste results in new spreadsheet

I have an Excel table with over 2000 records. I have a text table with matching item codes that i use to lookup the values from spreadsheet. It might have only a few matching records in the spreadsheet. (eg 31901 & 31903) I want it to loop thru the excel spreadsheet and only copy the rows to a new t...
by Bad husband
06 Apr 2018, 23:47
Forum: Ask For Help
Topic: Excel copy specific cells into specific cells in different workbook
Replies: 3
Views: 208

Re: Excel copy specific cells into specific cells in different workbook

I think I found a solution. I tested it on Workbook B and it worked. I have to try different scenarios but it is late.

I have decided to modify Workbook B by adding columns at the correct position so that it matches the same structure of Workbook A. Sunday to Saturday.
by Bad husband
06 Apr 2018, 17:01
Forum: Ask For Help
Topic: Excel copy specific cells into specific cells in different workbook
Replies: 3
Views: 208

Re: Excel copy specific cells into specific cells in different workbook

Hi FG, for Workbook A the cells will always stay in the same position. Every week I just create a duplicate sheet (template) in the same workbook and just copy the weeks results and then rename the sheet to the week number. The hidden cells are info that I copy from workbook C. I just want figure th...
by Bad husband
05 Apr 2018, 20:56
Forum: Ask For Help
Topic: Excel copy specific cells into specific cells in different workbook
Replies: 3
Views: 208

Excel copy specific cells into specific cells in different workbook

Looking to automate copying info from one workbook into another weekly. Workbook A has cells to paste for the 7day week. Workbook B will have the info for the previous week. I need to paste into the correct cells for the day of the week and it needs to go In the correct row. As you can see from the ...
by Bad husband
30 Mar 2018, 22:06
Forum: Ask For Help
Topic: If excel sheet missing error in my code
Replies: 2
Views: 133

Re: If excel sheet missing error in my code

I will give it a try
by Bad husband
30 Mar 2018, 19:44
Forum: Ask For Help
Topic: If excel sheet missing error in my code
Replies: 2
Views: 133

If excel sheet missing error in my code

I’m still very new to ahk and I’ve been learning on the fly by finding code examples on this forum. Great site. This is one of the more complicated scripts that I have written. I’m sure people could probably clean this up. I have 5 Excel workbooks that I need to copy some info from each to a new wor...
by Bad husband
29 Mar 2018, 21:50
Forum: Ask For Help
Topic: Excel Cell not always in same position
Replies: 2
Views: 183

Re: Excel Cell not always in same position

Thanks for the script
by Bad husband
28 Mar 2018, 19:50
Forum: Ask For Help
Topic: Excel Cell not always in same position
Replies: 2
Views: 183

Excel Cell not always in same position

I have data in a excel spreadsheet that is not always the same. It can have more rows and columns depending on that data collected that week. In column A there is always a row called “Total”. I need to find the info in the last column for that row. A B C D Toys. 1 3 7 Flowers 6 8 0 Paint 3 3 1 Cats ...
by Bad husband
22 Mar 2018, 20:38
Forum: Ask For Help
Topic: Manufacture code date to calendar date help Topic is solved
Replies: 2
Views: 201

Manufacture code date to calendar date help Topic is solved

Working on GUI to convert a manufacturing code to the actual calendar date. Don’t know where to even start to convert the code date? We receive goods that have a 4-digit code: 7001 - the first digit will always be the year, so the example above is 2017 - the next 3 digits represents the Julian Date ...
by Bad husband
22 Mar 2018, 19:49
Forum: Ask For Help
Topic: Add date help Topic is solved
Replies: 2
Views: 191

Re: Add date help Topic is solved

Worked thanks BoBo
by Bad husband
21 Mar 2018, 23:33
Forum: Ask For Help
Topic: Add date help Topic is solved
Replies: 2
Views: 191

Add date help Topic is solved

I’m building a GUI with radio buttons and edit boxes. Basically the user will select one of the radio boxes and the enter a date (ddmmyyy). Depending on the radio button selected it will add a specific number of days to the date that they entered. I have checked the forums and have tried testing the...
by Bad husband
12 Nov 2017, 23:17
Forum: Ask For Help
Topic: if statment help with excel
Replies: 3
Views: 232

Re: if statment help with excel

I need additional help for my script. I'm inputting a text word "MAIN" in a program after tab key, but I wrote an additional if statement if (Cell_Two=30605) Send, {Tab}HOLDA{End}%Cell_Four% The problem is that script is also sending the same code from a different line at the bottom of my script wit...
by Bad husband
10 Nov 2017, 22:38
Forum: Ask For Help
Topic: if statment help with excel
Replies: 3
Views: 232

Re: if statment help with excel

Thanks jeeswg for pointing me in the correct direction. I modified my code and it is working New code: #a:: ;With your Excel file open, Press Win+A to begin objExcel := ComObjActive("Excel.Application") ; Gets an open instance of the excel application CellA5 := objExcel.Worksheets(1).Range("A5") ; S...
by Bad husband
10 Nov 2017, 18:38
Forum: Ask For Help
Topic: if statment help with excel
Replies: 3
Views: 232

if statment help with excel

I have searched and tried different methods to get an if statement to work but i'm stuck. I have an Excel spreadsheet and the info starts in column A row 5. The code is working by extracting the info and copying to a different program. but i need to add an if statement is column A has a 2 please run...
by Bad husband
03 Nov 2017, 22:18
Forum: Ask For Help
Topic: Help with ControlClick for pop-up window in program DBFPlus.exe Topic is solved
Replies: 2
Views: 293

Re: Help with ControlClick for pop-up window in program DBFPlus.exe Topic is solved

I got it to work Modified the open program script to open 2 other scripts. I found that I had to press all the way down on my hotkey for about 1-2 seconds and the magic happens. Import the excel file and update the the dbf file in one keystroke. My first real script. Time to think what else AHK can ...

Go to advanced search