batch

Hello, I have a few thousand Excel workbooks that each contain a macro that needs to be updated. Is there any way that I can do this a batch fashion and not need to open each and every workbook? Thank you in advance. Tom Furst

Is there a way to send keys inside of a batch script (.bat file) on Windows 10 to Excel 2016? For example, this link below provides an example on how to send keys in a batch script (.bat) to Word using the following commands: Link...

Hi Guys, I am hopeful you can help me. I am currently putting together a form which will draw information from a log based on a unique indicator (in this case OIF ID). Please see below for the form: <tbody> A B C D E F G H I J K L OIF Type: OIF Sender OIF Receiver OIF ID...

I need an inputbox to vlookup "part number" and then replace/update its current batch number "batch". part number batch 0501322391 0529765 0501218232 0539866 4464335010 4699467 4464335009 6204844

I have a data sheet that has multiple entries for Batch Number. Meaning a batch will have multiple expense entries but there will be only one batch number for those. Example: A receipt would be a batch and the items bought would be the entries. I want to create a userform with a listbox to...

Hi, On my excel sheet i press trl + K which brings up the Insert Hyperlink box. I have many Hyperlinks on my sheet and i wish to change the text that is in the the field named Text To Display. As opposed to going through each link & manually editing them is there a batch edit version etc. I...

Is it possible to set a table up so that records are sorted into batch numbers automatically... maybe using AutoNumber? E.g. I want the first 100 records to be Batch 1 and then the next 200 records to be Batch 2 and so on...

G'day! I currently have : =SUM(IF(FREQUENCY(A8:A1000,A8:A1000)>0,1)) It batches column A with re-occurring values and gives the number of batches this works great! However, I now want to look at column H:H and see how many batches from A:A have the value "MG" in column B. See example below...

Hi, I have this Thisworkbook.cls that i need to launch once i open my excel file, Pleae help how can i do this. In my batch file I have this command: start Excel.exe "myExcel.xls" One my batch file execute and open my excel file, I need my Thisworkbook.cls also to be executed. Thanks and...

Hi, I'm trying to get a count from excel based on certain criteria. The table i'm trying to get data from is similar to the below:- <tbody> A B C D 1 Simple Simon Pending Easy 2 Simple Gary Batch 77 Hard 3 Complex Clare Holding Hard 4 Simple Graham Batch 77 Hard 5 Complex Paul...

Hello all, long time reader, first time poster. I have been slowly, but surely, upgrading the sheets we use at work. These little upgrades have simplified things and removed many issues of error. Now, I want to add one for laziness. A have a batch of cells A2:U20 (for example) that we fill...

Hi Everyone, Hope you can help with this, I am trying to make a list of products, the formula I need is this I have my products in batch numbers from 1 on I need to make a list of this batch numbers but miss out the numbers that have zero products at the moment So for example In Sheets "...

Hello there I'm a Excel newbie so i would really appreciate your help I have a data sheet with the following data Date User Type 1 2 3 4 5 6 7 14-01-2018 Brandon Batch No No No No No No No 14-03-2018 Danny...

Good evening, I hope this is the right place to post this? I want to run the below command in a batch script. It does actually work fine but I have to press "OK" for it to continue or "Cancel" to not. How can I adapt the script below so it automatically presses the "OK" for me in the script...

Hi, I've been using a Vlookup for a while now and it has worked really well so far and given men the results I expect. However the data in the column of the Vlookup range has now changed slightly and i'm needing to find the most common number from the column. The data looks a little like below...

Hi guys, I need to find the smallest batch size of a product that is made on particular equipment So on the right I have Equipment 1 (Cell K4) and on this equipment, Product A and Product are made What are the smallest batch sizes of these products? The source table is on the left The results...

Hi, Can someone help me with a batch search replace script? I get a fixed a list of names in column A every month. I have a fixed list of 100 people but each month, the amount of people reporting is different. Chris Dean John farmer Tony Smith I need to batch search and replace these names so...

Hello, I have a spreadsheet i'm using to make something. I have a total batch size that's in grams. I have 3 columns, one is percentage, one is actual amount, and finally how much of a teaspoon those equate to. I'm trying to see if it's 1/8, 1/16, 1/4, etc. Here are my formulas Cell G47 is the...

Hi all, I have proudly created my first macro (albeit using the Record feature in Excel). I have a master data with about 100,000 rows of data and about 50 columns. The master data sheet contains account information and related owners. The objective is to split this data by batches and send...

Hi All, I just replied to a previous post, but in hindsight, should have started a new topic. I have a list of Names that are Named Ranges. Is it possible to use the list to batch delete the Named ranges instead of looping through each one? Thanks, Keith