batch

  1. S

    A convenient way to batch rename ( not caption ) multiple command buttons on Userform ?

    Hi, I am creating an Userform with several command buttons on it. Is there a way to batch rename them as : cbButton1 cbButton2 cbButton3 cbButton4 cbButton5 … ? Note: I hope to give new names to them. not to change their captions. The way I am using now, is simply click on them 1-by-1, and...
  2. J

    Open, insert data , rename, save and print batch

    Hi Guru's/Geniuses, I have a template which uses VLookup to get data from a master spreadsheet. All of the lookup data is from a list of code numbers on the master spreadsheet. I need to be able to: 1. Open the template 2. Insert the code number 3. Save the file as the code number (plus...
  3. M

    VBA to trigger multiple batch files not working

    Hey everyone. I have code to trigger 6 different batch files, which then outputs a txt file, which in turn i use power query to bring the txt file list into excel. I thought it was working fine until one day I noticed the date stamp on the txt file had not changed in a week, despite running the...
  4. L

    Batch print hyperlinks in a cell range

    Hello, I have read the other threads on this topic and had no success. I am trying to batch print groups of PDF files. <colgroup><col></colgroup><tbody> Example area 1: Column K, range K8-K13 S:\Engineering\4-DFdrawings\50168B04.PDF S:\Engineering\4-DFdrawings\50000C004.pdf...
  5. R

    Set Lrow by dialog box? & Loop batch size limit

    I am compiling a register of projects and have been using VBA to Loop through 25-40 files in a batch. As the list gets longer I have been manually changing this in the macro text. 1) Does anyone know if i can use a dialog box to set the Lrow, to add to bottom of list? (So I can't forget to...
  6. J

    Batch conversion for coordinates - Northings and eastings to OS grid

    Hi Everyone, Has anyone got/seen/aware of a batch conversion tool that I can use to get the 10km OS Grid ref from a list of Northings and easting? I've a list that's 3,000 long so can't contemplate doing them manually/singularly using the tools I can see online and don't know where to start to...
  7. E

    Batch edit connections VBA

    Hi there. I want to edit the connections of the activeworkbook doing something like: Dim oCon For Each oCon In ActiveWorkbook.Connections oCon.Refresh BackgroundQuery:=False Next oCon The code above does not works. How can I do that? Thanks! EDIT: Better explain: I want to disable the...
  8. B

    Open userform upon entering data in cell

    Hi all, I got this excel sheet named "Data Gel" where i add data into. in column A is gel code (for example 1050). in column B is batch number (for example 308102). In column E and F i note a "x" for when i return the batch. E is production returns and F is other returns. Now i would like...
  9. J

    How to use SUMIFS with dynamic criteria?

    I don't even know how I'll explain this for you, here's the situation: Everyday at work we receive a "recipe" with the amount of ingredients we'll need to use that day to manufacture our products (we use the FEFO system to pick the ingredients). Today there's a person who compares the quantity...
  10. M

    Transfer of data

    Hi All Hopefully someone can point me in the right direction with this problem. We are trying to get away from having paper copies and go digital with batch cards at my work. At the end of each week we print out a weeks worth of batch cards, the operators use the cards for recording...
  11. D

    Macro to paste formulas to a 'batch' of 500 cells, wait for results to populate, then clear those formulas and paste to the NEXT batch of 500.

    I'm trying to take a snapshot of 10,000 different stock quotes using my brokerage's RTD API, *but* they limit me to 500 concurrent requests at any one time. If I exceed that, then I get booted / the API connection gets blocked. So my inelegant-but-probably-simple-solution (that I need help...
  12. L

    LookUp Batch Numbers Based on If the Cumulative Sum of the Batch Numbers is Equal or Greater to the Quantity Required for a Job Number

    Hello All, I have this complicated problem (well, complicated for my limited excel skills) which I'm having a hard time solving. I have a table in Sheet 1 listing planned production of products with different Production Order Number and Quantity. In Sheet 2, I have a list of next level Work...
  13. P

    excel extra data and match with different row

    <tbody> 1 <tbody> Date Batch 1 1st time Batch 2 2nd Time Hour 28/01/2019 AA103 BB100 6:09 AM 0.75hrs 28/01/2019 AA104 BB101 6:15 AM 1.23 hrs...
  14. D

    Importing a concatenated CSV file into Excel, but headers not on new rows(?)

    This is probably a problem with the Batch file command I'm using to combine the separate CSV files, but here is problem: I have 100 separate CSV files in a folder that I'm merging into a single CSV file with a simple .Bat batch file that I run from that folder with this code: copy /a *.csv...
  15. J

    Save batch of .xls files as .xlsb

    Hello, Is this possible through a macro? Many thanks.
  16. M

    Collection Item Attribute Change

    Hi, as I am new on this Forum, I don't know if my question has already been posted. If yes, please just show me which post. I have a collection with n classes (Batch) and I like to change attributes of the items. These attributes are strings like (Name, Adress, Phone, etc...) A create a GUI...
  17. T

    Batch update existing macro

    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
  18. M

    Batch Script - Send Keys Inside of Batch Script to Excel?

    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...
  19. P

    Returning Multiple Values based on a VLOOKUP

    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...
  20. S

    VBA inputbox - vlookup and edit

    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

Some videos you may like

This Week's Hot Topics

Top