automate excel import

Hey, i have been trying to import data from a website, but i can't get it to work. Does anyone have any tips or a guide on how to get it to work? Im trying to import the table seen on the first picture with all the info. The plan is to automatically import that info and update it atleast 1 time...

Hi, I got a task that are a bit over my current vba skills, and i was hoping that someone could help me out. i need to import some data regulary and update a database. what my need is, to check if the data in column A in sheet2 (new data) already is in column A in data (database). if yes it...

Hi there I have a spreadsheet with a stock ticker in A2. Let’s say for example "GRMN" which is Garmin's stock ticker. I want some code which will go to the webpage www.optionslam.com/earnings/stocks/”STOCKTICKER”. So in my example this would be: https://www.optionslam.com/earnings/stocks/GRMN...

Hi All, As a side project, I am working on creating a stock index comprised of 25 or so stocks and tracking their change. To set this up, I loaded the closing prices of the stocks for the past 6 months, and weighted each of the stocks a certain way (ex. .1, .015, .2 of the entire index) based...

Hello I am using the following code to import historical indices data for 5 different indexes in yahoo finance. Public Sub Import_Yahoo_Finance_Historical() Dim URL As String Dim dateParams As String 'Date ranges from default earliest Yahoo start date (m/d/y) to current...

I have a .txt file from monitoring data. it comes in following format Example: 3,673,49,2,43,89,8,138,45,9,49,675 etc. 1) The data is in groups of 3 .. but comes as ONE string with commas. 2) 2nd number has a reference table for description in another Excel table Say: 673 | RRRRR 43 |...

Hi all, I've got 170 csv files that I'm looking to compile into excel so as to analyse them, but am hoping to avoid having to do that one by one, adding each as a seperate tab. Does anyone have any ideas of how I could do this, e.g. a macro or script, or if there's an "add all as tabs" add-in...

Hi folks, A few times a month I receive a TSV file that I want to add to an Excel sheet. The first row is always the same, consisting of the column titles. The remaining rows vary in number. Sometimes there's just one, other times three (and in the future perhaps more). The files come with...

I need excel to open this webpage: https://www.midwestiso.org/MARKETSOPERATIONS/REALTIMEMARKETDATA/Pages/LMPContourMap.aspx then select the link to the csv file and download it, then open it in excel. I would like to automate this process to happen every 5 minutes, so that I can create a database.

I have loads of excel files to be uploaded in Access. Each file has the same field format and have 2 tabs (again with the same format) I want to automate this import process such that while importing this data with all fields to one master table, it should capture the 3 more fields 1. Time it...