Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Neon,
You can edit Macro1 and specify a file name. As and aside, regarding best practices: I always recommend *NOT* to use copy and paste. It's a killer on performance - it could make Excel hang for some users. Also, programmatically, it's easier because you know exactly how many rows of data you've iterated through and you know exactly where to start if you need to insert more data from another CSV. I recommend that you iterate through the CSV a line at a time, but if performance is *really* important, insert the data into the worksheet in bursts of several rows at once instead of a row at a time. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Data Protection Best Practice: AKA: Real Sheet Protection | Excel Discussion (Misc queries) | |||
Best Practice - Transfer Data | Excel Programming | |||
Activate Sheet Best Practice (Y/N?) when xFer data between sheets? | Excel Programming | |||
Transfer Data from Excel 2000 to the Access data base | Excel Programming | |||
Transfer data from XL into Access: best practice | Excel Programming |