batch

The server I'm pulling stock quotes from has added a request-limit of 50 quote-requests / second; if you request more than that, it disconnects you. My current code requests 500 at once, so I need to revise it so that it spaces out those requests over 10 seconds. The way the formulas are...

I have tried both a batch file and vbs to call a macro to run in a database that is already open. When the database is closed, the macro will run fine with no problems when I execute the batch file. As soon as I try to run it when its open, it fails to execute. I can see the cmd screen window...

Hello, I am trying to create a summary total for the department # BC for only the batch type R and P. I have tried multiple sumif functions found in this forum with no luck. BATCH TYPE DEPT# BATCH TOTAL P BC $1,949.14 R BC...

Hi All, I am trying to figure out how I would change a specific cell after executing a Vlookup. I have a main page where I can type in a product name and it brings up the data I require using a simple Vlookup. However, the problem comes when the stock runs out and we need to change the batch...

I have a cell (E1) with a string of text. I need to extract the batch number from the text string and put it in a seperate cell (D1) The problem I am having is the batch number ie either 7 or 8 characters in lentgh. Here is a sample of the alue in E1: BatchID - BI98C01D XMLExtraction -...

Hello, I have a list of batch numbers (column A) along with the item number for the batch (column B) and a list of what ingredients were used in the batch (column C). I then have on sheet 2 a standard ingredient list for each item which has item in column A and then a list of ingredients in...

Good evening all, I'm working on a spreadsheet for work and have a conditional formatting question. My spreadsheet is meant to store process data, with the batch ID in column A and process data in columns M through AI. The process data columns are conditionally formatted to change the font red...

Hi, Can VBA interact with pdf files in a folder ? And batch underline the first word of every line in each given file ?

Hi! Very novice VBA coder here hoping some of you experts can help me out! If I can get this macro, it will be used a lot and save a ton of time! Basically, I am hoping for a macro that can copy and rename worksheets in bulk, placing the new worksheets starting just after the selected...

I have a ton of invoices I've extracted from a couple of email addresses that I then turned into Excel documents with the Able2Extract PDF to Excel convert. The problem however, is the data looks like this: Untitled-1.jpg And I'm wanting it to have one big excel sheet with multiple columns...

Hello MrExcel-Forum, there once was a computer, who at certain times, ran a batch-file via the task-scheduler, the batch-file starts an xlsm-file, and the xlsm-file used "thisWorkbook.close false" at the end of their vba (in workbook.open. the "false" means that changes are not saved). there...

This is the example im working with. C has the input of work in hours on a particular day. E has the amount of available manhours on a day. When E<c the="" work="" goes="" to="" following="" day.="" treating="" input="" on="" a="" day="" as="" batch,="" i="" want="" find="" out="" when=""...

How do I open a .xml file as a "table" in excel from a batch file...I currently get it to start excel and open the file...but it prompts you to select how to open the xml file...I want it to open as a "table" every time?

Using Excel 2007 in Windows 10, but had the same problem in Vista. Have a workbook with about 50 sheets, half are data sheets, half are charts based on the data. To print only the charts, I hide all data sheets, right-click on a chart sheet and select all sheets. In print preview, I see 68...

I searched and searched. Now, I humbly ask. Workbook A has a column with 200 text entries; the first few cells are Tom, ****, Harry, Mary, Mickie, Moe, Dot. Workbook B has 200 worksheets, and the first 7 are called, respectively, Tom, ****, Harry, Mary, Mickie, Moe, Dot. I want to click cell...

Hi All, I want to create a batch file to open and run two different macros in excel. The reason I need a batch file is to do this automatically for me without me having to manually open the excel file. For some reason, when I use Task Scheduler to open my excel file (with macros), it simply...

Hello everyone, I was wondering if you could help me with something that would be truly invaluable to my work life! I already have the first 2 pieces of the puzzle, however, my knowledge doesn't allow me to complete the solution. 1. I already have a macro that lists all of the workbooks...

Hello, I have about over 200 xls files and was asked to protect all the worksheets with password from being able to edit and print. Is there a macro available to protect them by batch? In need of help. Thank You.

Guys, I have this code that works wonderfully for what I needed at one point: Option Explicit Sub AutoAddSheet() Dim MyCell As Range, MyRange As Range Set MyRange = Sheets("INDEX").Range("A1") Set MyRange = Range(MyRange, MyRange.End(xlDown)) For Each MyCell In MyRange Sheets(2).Copy...

I have 80 excel files in a folder. The structure of each file is the same meaning beside the file name which us different, the file content is a table which is identical in all files. The files have the same amount of rows and columns. Column headers are same. Column a is the date column. Every...