read data

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

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

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

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

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