VBA newbie here, please forgive if my structure and code is poor. Feel free to make suggestions or send me links to improve my learning/conventions and coding style.
Background: I’ve been piecing together several modules to perform certain web scraping tasks and eventually assembling the data collected into a table format in order to do further analysis. The attached excel doc has a couple of modules in it, which I left in case it helps with background info for how I get the data - perhaps there is something more efficient I’m unaware of. My challenge is in the Module “READ_CSV_Files”. Working off this blog post (https://sites.google.com/a/madrocket...svs-to-1-sheet ) I’ve modified the code a bit and desire to modify it even more.
As of now I can read in the data from separate csv’s downloaded from my retrieval modules and have the associated filename (in this case the file name is also the ticker symbol) linked to the records assembled by adding a column with this entry (“MasterCSV” tab). What I want to do is have the data transposed and add additional columns with parameter data of the web scrape associated with each record. See the tab with desired output. The parameters I want recorded are in various places in the input tab, I’ve assigned most of the variables with Range designations, but I’m challenged with how to associate description and sector from the input tab. I can always do this with a vlookup in a later/separate step, but it would be nice to build it into the module.
I tried a ‘record macro’ and sort of identified the “Transpose:=True” line and I believe I have to rearrange the order of the ‘read in’ steps. Such that the data is transposed before assigning the filename(ticker) However, as I’ve played around with variations in the code it I can’t seem to get it to work the way I envision.
Bookmarks