1. G

    Continue working while loop does batches

    Hi folks, I am unable to figure out how to solve the following problem. I have a working loop that runs down a list of names in column B (Account) and retrieves data from individual account workbooks on our network (quite a few) and puts them on the main sheet like below. My problem is that...
  2. B

    XLStart Folder

    Does anyone know if one can have a batch file copy and paste a "Master" file from a shared folder into each individuals Personal XLStart Folders? It gets a little complicated because each individuals paths aren't the same due to each individual having a designated User Number Folder so I am not...
  3. B

    Code to Insert 'x' amount of rows

    I currently have Sub FYInsertRows() Dim Rows As Variant Rows = InputBox("How many rows?") If Rows = "" Then Exit Sub ActiveCell.EntireRow.Resize(Rows).Insert End Sub which works but the issue I run into with others in my department is that we open new templates and workbooks so...
  4. O

    Code to delete unused cropped region

    Hi there, My goal is to delete the cropped space of images that is currently unused. That is, after an image has been cropped, I want to use "compress picture" function in excel/word/powerpoint to batch process this over multiple files. My problem is that I can do this just fine in excel...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. J

    Save batch of .xls files as .xlsb

    Hello, Is this possible through a macro? Many thanks.
  20. 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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back