read data

  1. W

    Read/import online weather data into an excel sheet.

    He Guys, I am trying to read/import(actuel) weather data into an excel sheet. So i surfed the web for quite some time, but i am hoping you can help me out. I have some experience with vba, but not with reading data into excel. So i will explain what my idea is, I want to read/import actuel...
  2. T

    Open a workbook and copy the first sheet into a defined sheet in excel vba

    Hi, I am trying to write some code to load a sheet from another excel workbook into excel. But although I can open the file, I get a 400 error and the sheet does not copy. Code: Application.ScreenUpdating = False Dim MyFile As String MyFile = Application.GetOpenFilename()...
  3. J

    Read the data from a text file and reshape the data

    I have a data set for different time intervals. The data has three comment lines before data for each time interval. For each time interval there are 500 data points. I want to change the dataset such that I have the following format: <code style="margin: 0px; padding: 0px; border: 0px...
  4. S

    Macro/VBA to Read ASC file

    Hello, I have been using Excel for a long time now, but I am just starting to learn the benefits of macros/VBA and I am loving it. I was hoping someone could help me with the code to import a .asc file into a workbook. I would like to create a button that the user clicks that asks them what...
  5. L

    Need to create worksheet based on data in another worksheet

    I need to create an ownership report that reports data from another worksheet. The first thing that needs to happen is that the macro needs to ask which worksheet to read from, then it needs to ask which worksheet to place the data into. Once that is established, the macro would read the...

Some videos you may like

This Week's Hot Topics