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.


---
Message posted from http://www.ExcelForum.com/

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.


---
Message posted from http://www.ExcelForum.com/

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

--
Message posted from http://www.ExcelForum.com

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...01/default.asp

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

John

"ppatin >" <<(E-Mail Removed)> wrote in message
news(E-Mail Removed)...
> Thanks for your advice about splitting strings. I guess another thing I
> 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.
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>