batch

  1. T

    MID and SEARCH formula to extract text from a larger string

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

    Add Missing Items to List

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

    Conditional Formatting Based on Font Color

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

    With VBA can i edit pdf file in batch ?

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

    VBA Excel Help: Copying and Renaming Worksheets in Bulk

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

    Multiple Excel files containing invoice data ...how to convert to one Excel?

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

    Preventing multiple Excel instances

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

    Batch completion calculation with variable input/capacity

    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=""...
  9. D

    XML file to EXCEL TABLE with BATCH file

    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?
  10. B

    Problem printing multiple sheets to one PDF file

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

    Hyperlinking each cell of Col A in Workbook 1 to the Worksheet in Workbook 2 with the same name

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

    Batch file to open and run two macros in excel

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

    Batch VBA Password Protect All Workbooks Within a folder... Missing Piece of the Puzzle

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

    Macro for protecting all the worksheets with password

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

    Copying a row of Cells in a Range

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

    batch row insert /specific cell update

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

    Batch Edit Cells Using a Macro

    I’m trying to create a simple macro where the user can batch edit cells by entering a reference number. Here is the idea. Suppose I want to track shipments for different items on my inventory. There are 4 columns on my spreadsheet (Item#, Product Description, Order Date, Delivery Date) and...
  18. L

    Running a batch file from excel visual basic

    Hello everyone, I have searched a lot in the web for the solution but I cannot find it. The issue is this: I need to open or run a batch or txt file from VB. The code I have is this: Sub Example() Dim RetVal RutaCompleta = Ruta & "\" & "texto.txt" RetVal = Shell("C:\BatchFile.txt") End Sub...
  19. A

    File Tags

    Hi. I need to: - Import all files and file properties including but not limited to path and tags for a specific directory (including subdirectories) - Then I need to add tags to files manually on the tags column - And then add those tags back to the files.(excel or batch for csv file created...
  20. D

    VBA: Importing Multiple Text Files Without Header

    Hi folks, I've seen a few similar posts to this but not one that seems to fit my needs. I'm looking to import multiple text files into the same sheet, placing subsequent text files below the previous one. I'd also like to remove the headers in the text file (just the first row) as the files...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top