print or row like command in excel vba
 

Dear Experts - first if you respond many thanks and im sorry if this is a
poor question

i have an excel sheet with many rows and i would like to use a loop which
processes the row in a similar manner to a classic Print statement possibly
creating an ascii file of the data , i know excel vba has a row statement
which i would like to use - even if its printing rows via a message box - to
me the sheet i work on rows are like database records and as such i want to
treat them as such - can any one help

my row numbers are row 4 to 1443 - not that i guess that helps

my logic is something like ;

for rows
do
print entire row to output file
loop
--
C Ward

print or row like command in excel vba
 

Why not just copy your data to a new workbook and then do

Files=SaveAs

and select the format you want, such as CSV or Tab Delimited or Space
Delimited.

Turn on the macro recorder while you do it manually if you want to get code
to do it.

--
Regards,
Tom Ogilvy


"christopher ward" wrote in
message ...
Dear Experts - first if you respond many thanks and im sorry if this is a
poor question

i have an excel sheet with many rows and i would like to use a loop which
processes the row in a similar manner to a classic Print statement
possibly
creating an ascii file of the data , i know excel vba has a row statement
which i would like to use - even if its printing rows via a message box -
to
me the sheet i work on rows are like database records and as such i want
to
treat them as such - can any one help

my row numbers are row 4 to 1443 - not that i guess that helps

my logic is something like ;

for rows
do
print entire row to output file
loop
--
C Ward

print or row like command in excel vba
 

Dear Tom

Yes i see this method but its not quite what i want let me explain a little
more

My user will craete the data file which is then to be sent to a sql server
database and finally analysis services - we currently use data transformation
services in sql server which can bring directly in from an excel spreedsheet
- not if sheet has an automatic macro though hence an error - i thought maybe
creating a simple ascii file might solve this issue and allow us to bring the
data in using the pre built wizard
--
C Ward


"Tom Ogilvy" wrote:

Why not just copy your data to a new workbook and then do

Files=SaveAs

and select the format you want, such as CSV or Tab Delimited or Space
Delimited.

Turn on the macro recorder while you do it manually if you want to get code
to do it.

--
Regards,
Tom Ogilvy


"christopher ward" wrote in
message ...
Dear Experts - first if you respond many thanks and im sorry if this is a
poor question

i have an excel sheet with many rows and i would like to use a loop which
processes the row in a similar manner to a classic Print statement
possibly
creating an ascii file of the data , i know excel vba has a row statement
which i would like to use - even if its printing rows via a message box -
to
me the sheet i work on rows are like database records and as such i want
to
treat them as such - can any one help

my row numbers are row 4 to 1443 - not that i guess that helps

my logic is something like ;

for rows
do
print entire row to output file
loop
--
C Ward