Problem with Excel ActiveWorkbook.SaveAs

S

strivedi

Joined
Aug 8, 2007
Messages
1
Reaction score
0
Iam trying to generate cvs file using the command ActiveWorkbook.SaveAs. The excel sheet has 100 rows and 30 columns. Last 2 columns are empty in all the rows.
The command is working in very weired manner. It is generating first couple of rows (about 18) correctly, but after that not including last 2 columns.
All the rows should end with last two comma (as last 2 columns has no data) but only 18 rows are displayed like that, rest are ending with text of 28th column.

Can any body help me with this pls.

Thanks!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Breaking One Row into Multiple Rows using VBA Macro? 2
Excel VBA help: Text file formatting 19
Copy columns and paste with blank column between 5
Problem with offsetting one row down 2
VBA comparing sheets and cells 1
this code is VERY slow, is it the code or perhaps a worksheet issue 32
Error 1004 SaveAs Object workbook failed 19
Ron de Bruin - Merge cells from all worksheets 0

Back
Top