closed workbooks

  1. J

    VBA to pull data from closed excel workbooks to Master within sub folder structures

    Hi, I have been searching for a solution to this issue for quite some time with no luck, some findings get me a portion of the way but not quite what I need. I do not have any VBA experience but I am very competent with formula writing. I need to pull data ranges from closed, excel sheets...
  2. S

    Update Data in Closed Workbook

    VBA novice here, Is possible to update data that is queried from an external source in a closed workbook? I use the following code to retrieve stock data from Yahoo Finance: Sub GetData() Dim DataSheet As Worksheet Dim EndDate As Date Dim StartDate As Date Dim Symbol As...
  3. F

    Copy data from a folder of closed workbooks to a active workbook

    Hello all, Long story short, I have been looking for weeks on how to copy a range of cell's values from a folder full of closed workbooks into the active workbook, and then have it paste the values from each in order starting at "A2" on the active. Sadly, I have pulled up short on everything...
  4. W

    GetInfoFromClosedFile problem while looking in Subfolders

    Hello all and thank you in advance for any help you can give. My overall goal is to have a MasterLog worksheet that contains summary data from individual files. There will regularly be subfolders added and individual excel files within those subfolders. The individual files are all formatted...
  5. M

    Finding from a closed workbook

    Hi all, I am writing a VBA code to find a string from a workbook and return the number from the cell below it. The problem is that my workbook, worksheet names and the string to find are all variables and i can't open all the workbooks while running the code since I have too many workbooks...
  6. S

    Referencing A Range in Multiple Closed Workbooks

    Hello All I am a VBA virgin (pretty much) but I think that I have a requirement that can only be solved using VBA so any help you can offer would be great. I receive a spreadsheet (.xls extension) every workday and the filename is made up of the date in yyyymmdd format. I have the individual...
  7. P

    Get data from a list of CLOSED workbooks using VBA

    Here's a tricky one: I have one Master Sheet that fetches information off of 30 other workbooks. The data is uniform accross all workbooks. As of right now, I have code written that will update the master, but ONLY if the other workbooks are open. Is it possbile to get the same data off of...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    • Started by Anton1999
    • Replies: 28
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    • Started by jaym6939
    • Replies: 26
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    • Started by dpaton05
    • Replies: 24
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    • Started by MrDB4Excel
    • Replies: 23
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top