Home |
Search |
Today's Posts |
#1
|
|||
|
|||
import data with macro
I'm trying to import ten sets of data in Excel. I click on import external
data and then choose a file and press next. I add a space to separate the data into two columns and then press finish. I was wondering if it would be possible to use a macro to import the data. Possibly import the first one and then have the macro import the next 9 in succession. The files I import are always in succession, but always have slightly different names. For example, the data I collect today will be saved as 718cr1, 718cr2, 718cr3, etc. The last number represents the trial number and the first number represents today's date. Does anyone have any ideas? Thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions | |||
how do i import multiple data sets at one time? | Excel Discussion (Misc queries) | |||
Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
Macro that will add data from multiple workbooks to the 1st open r | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |