Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fast Export
I'm addressing the age-old question of exporting data from Excel to
(fill in the blank). I need speed (dealing with a large amount of data many times over) The goal of the Excel spreadsheet I've written is to take a range and save it in a file (.txt, .csv, .whatever) so that it can be read in later by another Excel spreadsheet. What I know so far is that if I (programatically via VBA) cut the range, open a new workbook, paste the values and save the workbook, this seems ? to be the fastest. However, I'm told this is not best practices. I've also tried looping through the range and assigning the values to an array then write the array out. Takes too long. Does anyone know the most efficient way to capture a range and save it to a file? All ideas are welcome. Thanks a ton. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fast Export
William, I'm exploring this code. I am unfamiliar with the -4167 parameter on the end of the Workbooks.Add. What is that doing and what are some other options? Thanks. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
You Need Fast Money ????? | Excel Worksheet Functions | |||
export re-order input fields to export file [csv] | Excel Worksheet Functions | |||
need formula help fast please!! | Excel Discussion (Misc queries) | |||
Need help fast! | Excel Discussion (Misc queries) | |||
Need help fast! Thanks! | Excel Discussion (Misc queries) |