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

  • populate from drop list with multiple tables
    • Replies: 49
    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
    • Replies: 37
    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
    • Replies: 35
    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
    • Replies: 35
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    • Replies: 30
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    • Replies: 25
    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