| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
importing file using macro and all rows don't appear?
I've just created a macro in excel 2003 and saved it as a personal macro.
When I import new data using the macro and there are more rows than the macro remembered I only get that amount of rows. What should I do so that I can make the last row variable? Thanks! Michael |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
importing file using macro and all rows don't appear?
What do you have in your macro at the moment?
"Michael" wrote: I've just created a macro in excel 2003 and saved it as a personal macro. When I import new data using the macro and there are more rows than the macro remembered I only get that amount of rows. What should I do so that I can make the last row variable? Thanks! Michael |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
importing file using macro and all rows don't appear?
8000 rows and 22 colums. When I import a file with 14000 rows, I only get
8000 rows of the new data. "bigwheel" wrote: What do you have in your macro at the moment? "Michael" wrote: I've just created a macro in excel 2003 and saved it as a personal macro. When I import new data using the macro and there are more rows than the macro remembered I only get that amount of rows. What should I do so that I can make the last row variable? Thanks! Michael |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
importing file using macro and all rows don't appear?
Show your current code.
-- Tim Williams Palo Alto, CA "Michael" wrote in message ... 8000 rows and 22 colums. When I import a file with 14000 rows, I only get 8000 rows of the new data. "bigwheel" wrote: What do you have in your macro at the moment? "Michael" wrote: I've just created a macro in excel 2003 and saved it as a personal macro. When I import new data using the macro and there are more rows than the macro remembered I only get that amount of rows. What should I do so that I can make the last row variable? Thanks! Michael |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing CSV file with more than 65535 rows to Excel 2007 | Excel Discussion (Misc queries) | |||
| Macro for importing data from one file to another | Excel Programming | |||
| Importing Fixed Width File Macro | Excel Programming | |||
| Importing a text file into Excel with too many rows? | Excel Discussion (Misc queries) | |||
| Importing Text File with more than 65536 rows | Excel Programming | |||
Hybrid Mode
