Basic Excel Problem

[ppatin]

Hi, I'm new to Excel macro writing, and there's a task I could use some
help with. I have a spreadsheet that has data we need to export into a
text file. We don't need to export every row, so ideally I could create
a macro which would check one column, which would indicate whether that
row should be exported or not. Also, in the data we are exporting we
have an eight digit string of numbers which we need to break up into
eight seperate single digits in the text file. Suggestions or ideas
about how to do this would be appreciated. I have some programming
experience, but have never done any in Excel before.

 

[app_trainer]

I'm not sure of the macro for exporting. But your second question about
converting a string into many parts can be accomplished by using
Text-to-Columns. From the main menu, select Text-to-Columns and step
through the wizard. For your example, use FixedText. That allows you to
'slice' your data into as many parts as you'd like. Hope that helps.

 

[ppatin]

Thanks for your advice about splitting strings. I guess another thing
should have asked is if anyone can reccomend a good site that wil
teach me the basics of writing macros in Excel, since this is my firs
time creating one

 

[John Wilson]

ppatin,

should have asked is if anyone can reccomend a good site that will
teach me the basics of writing macros in Excel, since this is my first
time creating one.

Try here for a start:
http://support.microsoft.com/default.aspx?scid=/support/excel/content/vba101/default.asp

and take a look towards the bottom of this page for more:
http://www.mvps.org/dmcritchie/excel/excel.htm

John