closed workbooks

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

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

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

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

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

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

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