i******r
发帖数: 323 | 1 Hi I have about 15 tabs in the same excel file, I need to read them in one
by one. I can write a simple macro that read them in one at a time, but I
need to call it for 15 times and type in the tab name. Is there any simple
way?
Also i the excel spreadsheet, if the first row is not the column name, but
second or third row is the column names, so I used getnames=No, then how can
I retain the column names?
I used transpose twice to get the variable names, I think there should be
some easier way.
T | p********a
发帖数: 5352 | 2 1. No simple way unless you use VBA to read the tab names internally
2. use range="A2:C256" and set the row numbers to macro variables |
|
