closed workbook

Hi there, I have this code which extracts the values I want from the spreadsheet I want, however there is only one problem - hopefully an easy fix. This extracts the data from rows 5 to 28 and columns 26 to 36, but inputs these values into my sheet in the same place. I would like the macro to...

I'm trying to rewrite a COUNTIFS function so i can use it with an closed workbook, by using COUNT(IF(AND... I want to count the number of data that has B3 in column AW, E2 in column AN and D3 in column AU. The following function works for that...

Hi all, I'm new to the forum and new to VB, and was wondering if there was anyone out there who could lend a hand with a problem I'm having concerning pulling data from a closed workbook by using a macro. I have tried Google to resolve the issue, but am only getting very basic results which do...

Hello, First time posting on MrExcel. You guys have been great by helping me just by Google searching but I am hoping that you can help me with a formula. I am trying to count the criteria "Any cell that equals 10 in column K" between two dates in column A in a closed workbook. In the sheet...

Hello All, I have an array formula that is only working when the linked spreadsheet is open. I am referencing a table, is that the problem? The formula when both sheets are open: {=IF(ROWS(B$6:B6)>$G$2,"",INDEX('[Serial Number Tracking.xlsm]Serial Credit Sheet'!A$2:A$76049,SMALL(IF('Serial...

Hello, I have a VBA script to list worksheets from a closed workbook. The script works great, but I can't seem to get it to list the file location and name. Does anyone have an idea about how I could get the file path and name to show up? Thanks! Option Explicit Public Sub...

Hi all. I have a macro (see code below) that copies a worksheet (Sheet1) from a closed workbook into Sheet1 of the active workbook. So far, so good but I need the path to the closed workbook to be taken from a cell in the active workbook which is populated by a drop-down combo box. I have named...

Is it possible to write some codes to the "workbook" or "worksheet" of a closed workbook.For example : Private Sub Workbook_Open() MsgBox "Hello" End Sub It is possible to export a module to a closed workbook but I wonder if it is possible to export the code above.

I am using the function below. It works fine if I call it in the following manner; BillableHours = GetValue(fldpath, ThisDateFileName, "IngenuitE Time Card", "D16") with the "D16" hard coded. I need to search the closed file and determine where the billable hours will be stored, so I have...

Okay, I want to click on one cell, take the text from the cell next to it (let's say it's ABC-123), and use that text to search for matching text in a certain column in a closed workbook. If ABC-123 exists in the searched column, I want to insert a row below ABC-123, copy the information in the...

I am pretty new with VBA - am actually an accountant. But help is needed. As the subject says, I need data from specific cells of various cloded workbooks and the data have to show a a summary sheet at various specific cells. ie. data from A2 (closed workbook 1) must show in C3 (in another...

Hi everyone, I would really appreciate some VBA help. I would like the macro below to run automatically if the cell "BO1" Changes from its previous value. Cell "BO1" is determinded by drop down menus on another worksheet. Any help would be greatly appreciated. -Terry...

Hi everyone, I have an issue that I just need to try to find the answer for. I use an index/match/sumproduct megaformula that has worked just fine from our server since I started using it. It basically allows me to enter the formula in an open workbook (or using VBA) and pulls the lookup...

Hi! Need help with the following. Have two workbooks one (Avvik_databas.xls) is the "database" and avvikelse_rapport_fixa.xls/sheet 1. I extract data with vlookup from the "database file" (all values are from the same row) and paste the values in to avvikelse_rapport_fixa.xls/sheet1. I need to...

I need to retrieve rows of data from a closed workbook based on a number entered by a user in a cell on the open workbook. The closed workbook has a number of worksheets therefore the code will need to search each sheet and retrieve matching rows. Column a has the number to be searched...

here is a sample code: Public Function getest(esttype, yr) Dim strf As String strf = "=counta('m:\folder\mds\[rating index.xls]" & esttype & Right(yr, 2) & "'!$1:$1)" MsgBox Evaluate(strf) End Function for "sales" and 2009, what strf reads is: =counta('m:\folder\mds\[rating...

Good morning, I've been struggling since yesterday while trying to take 8 cells in a 120 different workbooks and list their values on a single spreadsheet. I have absolutely no knowledge on VBA but I've been thinking of learning how to use it for a while and that looked like a good...

I currently am using offset to reference another workbook. I have a cell that has a defined name so I reference that cell and then do my offset off of that. The formula looks like this: =IF(OFFSET('Source.xls'!Bulk_Counterparty,1,0)="","",(OFFSET(Source.xls'!Bulk_Counterparty,1,0))) Is...

Hello, I've been trying to get the right code to close multiple workbooks from inside a macro, using a FOR loop. I have say Book1.xls ... Book10.xls and I want to substitute the numeral in the following code by the i-th value but haven't been able to: For i = 1 To 10...

I am using the following VB code to check if a file exists and if so add a formula in my workbook providing data from that file. I have pre-pulled raw data in the directory "H:\BusinessRpt\Test for scripts\" which is named firstly by the day of the month and then what data it is. - i.e/...