Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save As - Multiple Sheets fails to save as text file
Hi,
I have a VB program which saves a single column containing text from a workbook, as a text or a html file. The data source is from SQL Server 2000. I ran into a problem when the number of rows execeeded 65536, which I handled it by continuing across multiple sheets. Now I can only save the single sheet as a text / html file at a time. Is there any ideas / suggestions which would help me point in the right direction as a hack to the solution of exporting multiple sheets onto a single output file. Env: VB 6 / Excel 2000 / NT 4.0 / SQL 7 Thanks for your time and help Ravee. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save As - Multiple Sheets fails to save as text file
Use low level file IO to write a file in the format of your choosing - you
format it the way you want http://support.microsoft.com/support...eio/fileio.asp File Access with Visual Basic® for Applications -- Regards, Tom Ogilvy "Ravee Srinivasan" wrote in message ... Hi, I have a VB program which saves a single column containing text from a workbook, as a text or a html file. The data source is from SQL Server 2000. I ran into a problem when the number of rows execeeded 65536, which I handled it by continuing across multiple sheets. Now I can only save the single sheet as a text / html file at a time. Is there any ideas / suggestions which would help me point in the right direction as a hack to the solution of exporting multiple sheets onto a single output file. Env: VB 6 / Excel 2000 / NT 4.0 / SQL 7 Thanks for your time and help Ravee. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save As - Multiple Sheets fails to save as text file
Tom,
Thanks very much for your help. Let me check it out if its feasible to fudge my program to do that. Will update the status later Regards Ravee. -----Original Message----- Use low level file IO to write a file in the format of your choosing - you format it the way you want http://support.microsoft.com/support...ontent/fileio/ fileio.asp File Access with Visual Basic® for Applications -- Regards, Tom Ogilvy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel fails on Save/Save As | Excel Discussion (Misc queries) | |||
vba for selecting multiple sheets to save as a new book | Excel Worksheet Functions | |||
copy the same raws of all sheets from about a 100 file to a new sheet of a book and save the file | Setting up and Configuration of Excel | |||
Excel fails to save | Excel Discussion (Misc queries) | |||
Excel fails to save properly | Excel Discussion (Misc queries) |