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

Watch MrExcel Video

Learn Excel - Place People on Bell Curve - Podcast 2217

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top