| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
excel macros truncating tabs for hidden columns.
Hi,
I have written VBA macros in Excel 2003 to generate a tab delimited text file.I have some hidden columns as well and the file is being generated fine with extra tabs for the hidden columns.Howvever for line numbers = 1985 the hidden columns are being truncated as in these extra tabs are not being generated. i process the file in my VB 6.0 application wherein i check the number of tab delimited columns that are being generated. for line number= 1985, the application gives me an error :"Invalid file format". What is it that i am missing here!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| problem:search results negative in excel docs with macros | Excel Discussion (Misc queries) | |||
| How do i copy columns of data in notepad into excel? | Excel Discussion (Misc queries) | |||
| How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
| How do you install help for excel 4.0 macros in Office 2003? | Excel Discussion (Misc queries) | |||
| Add more lines and more columns in Excel | Excel Worksheet Functions | |||
Linear Mode
