LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I random sample from a set until every sample is selected? random sampling Excel Discussion (Misc queries) 6 April 26th 10 09:54 PM
How do I provide new sample spreadsheets to office online Dre[_2_] Excel Discussion (Misc queries) 0 April 5th 10 10:44 PM
Get Excel to provide equation for my x and y hasargent New Users to Excel 2 December 6th 07 12:01 PM
Can I provide links to different worksheets in the same workbook? Chrisinct Excel Discussion (Misc queries) 3 July 5th 06 03:44 PM
Hyperlink to provide feedback Smudger Excel Discussion (Misc queries) 6 February 4th 05 11:10 PM


All times are GMT +1. The time now is 06:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"