View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
onedaywhen onedaywhen is offline
external usenet poster
 
Posts: 459
Default How to provide sample workbook?

Jim,

Personally I'm not militant about attachments. For one thing I set Outlook
Express to color code large messages so it's easy to see the ones with
attachments, and I have broadband at work and at home. But I know others
operate differently. Someday I like to think, with broadband becoming for
prevalent, the "prohibition" could be lifted.


You have a point but I'd want there to be a specific 'attachments'
group so that I could opt out. I line in a rural area in England and
broadband will be unavailable for some time yet. And I prefer to read
and post from Google groups so attachments are meaningless in that
context.

Anyway, most "sample data" is simple enough that I don't mind a little
typing.


I usually do just a brief description myself. For example, in this
case I originally said:

"For example, my range is A1:C10 and I want to delete the
row which has the value 'Pies' in the first column, so
if A4="Pies" I want to delete A4:C4 by shifting cells
A5:C10 up"

I thought this was enough - after all, the actual values could be
anything - but the only reply I got asked me to send a workbook in a
personal email. (I still haven't got a reply from that one, must
follow it up...)

I think I would be put off by a macro that dumped the data; might
take me longer to check the macro than type the data.


That's what I feared. My suggestion was for the reader to create the
workbook and manually run the macro. I thought that a macro that
created a workbook etc would look 'suspicious'.

And from the poster's
side, creating the data dumping macro is a lot more trouble.


Yes, many posters to this group wouldn't have the ability to do it
(that's why they're here!) But because I can, I feel I should do all I
can to help people help me. What's ten minutes coding if I can get an
answer?

If anyone can give me suggestions on what a data dumping macro should
look like I'd be grateful to have them.

"Jim Rech" wrote in message ...

Personally I'm not militant about attachments. For one thing I set Outlook
Express to color code large messages so it's easy to see the ones with
attachments, and I have broadband at work and at home. But I know others
operate differently. Someday I like to think, with broadband becoming for
prevalent, the "prohibition" could be lifted.

Anyway, most "sample data" is simple enough that I don't mind a little
typing. I think I would be put off by a macro that dumped the data; might
take me longer to check the macro than type the data. And from the poster's
side, creating the data dumping macro is a lot more trouble.