batch

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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