other workbook

  1. M

    SPEED QUESTION: EQUAL v. VLOOKUP

    Which is faster? I have two workbooks. One has all the personnel information and the other has equipment information. They team up to create picking sheets for the warehouse. Each provides information to the other one via vlookups. I was wondering if instead of doing a vlookup I could simply...
  2. R

    WorksheetFunction.Countif to Other Workbook

    Hi Guys Struggling on this one. I need to use WorksheetFunction.Countif in VBA to access info in another workbook but I cant get it to work. My Code is: t = Application.WorksheetFunction.CountIf('C:\My Directory\[Stock.xlsm]Main Stock'!$B$B, "<>") Thanks in Advance ;-)
  3. R

    send userform data to another workbook

    I have a userform that collects customer information and generates a receipt. Presently the receipt is generated in another tab within the same workbook. Each time the userform is used the receipt is over written. I would like to have the receipt put into another workbook and each receipt is put...
  4. B

    Need help with index, match in other workbook (formula via vba)

    Hi, I want to write a formula in a cell on a worksheet using <acronym title="visual basic for applications">vba</acronym>. The formula holds an path name for a certain folder. I can get the data out of the file in the folder, but it seems that excel doesn't find the file (File_Name), since I got...
  5. vinzent

    Macro Vlookup antoher book

    Sorry, mi English is poor, but a i try to explain I have one file called "NewCommit", I need the dates from another file called OldCommit Column ShipDate (Column I). These dates will be in the Column I in NewCommit I have this code, but error message appears Sub abrirArchivo() 'open...
  6. S

    Reference cells in different workbook

    Hi, I would like to copy data from a different workbook in a macro. When I do this, do you know how I can reference the other workbook? Being an amatuer, I have the following: C:\Users\Andrew\Desktop\[Book1.xlsx]Sheet1.Sheets("Sheet1").Range("A1:A5").Value =...
  7. E

    Run Macro from other wb with keystroke

    Hi, I'm new to the forum. Thank you in advance for your help and sorry if I do not follow protocol (I am still learning). I am trying to build some macros in my own workbook to be able to improve efficiency to a protected workbook that can not be changed directly. I would like to: - While in...
  8. C

    Do until Loop on another workbook

    Hi, I want to loop until the last cell in another workbook. Both workbooks are open. Here is some of my code. I can't get the loop until part to stop at the named range of Wk2. any help would be appreciated. Set Wk1 = ThisWorkbook Compare = InputBox("Favor selecionar a data para comparaçao...
  9. J

    Printing into another workbook.

    Hi, I have a feeling this may be out there somewhere, but after extensive searching, I can't find it. I want to use VBA to print cells into another workbook in the same way that you can print into another sheet in the same workbook using code similar to this: (For example if I wanted to print...
  10. sachin.acharya

    Calling Procedures From Other Workbooks

    Hi all, From within the code in an Add-In I am trying to call a procedure from the ActiveWorkbook. So my code looks somewhat like: Sub MyProcedureInAddin() 'My code here... Run ActiveWorkbook.Name & "!SomeProcedure" 'My code continues... End Sub This works fine if...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top