If you want to respond to prompts everytime you run it after the firs
time,
you like repetitious code, and you don't mind renaming the curren
workbook
to a CSV file (and losing any changes not saved before running th
macro),
then I guess you have a solution.

all i did was add a few of lines

Which 3 people took time to provided you with.

-------------------------------------------------------------------------------------------------
Tom,

You are indeed a 1st class prat, Im not sure what the bad attitude i
for in your replys to me but im guessing your someone who dosnt get ou
much and has no friends or life and therefore no real interaction wit
people in everyday life.

In all of my posts i made it clear how thankful i was with any hel
given, i made it clear as well i havnt got a clue about code so i wa
muddling thro it, i managed to get something that works for me which i
all i wanted, it dosnt matter to me how much the code is repeated etc a
long as it works, the only time it prompts me for anything is when
want it to , and i dont want to save the work which ive done s
everything works excellent for what i want.

You also take out a line "all i did was add 3 lines" which you took ou
of context and made it look like i was being ignorant or arrogant ,
guess thats more a reflection of your personality than mine, all i wa
doing in fact was saying i had solved my problem and showing how i ha
done it also by saying thanks at and of post for all help to those wh
helped me in the right direction.

Once again thanks to all those helped including Tom, but especially t
those on here who help as much as they can without leaving sarcasti
messages, thanks

--
scottymellot
-----------------------------------------------------------------------
scottymelloty's Profile: http://www.excelforum.com/member.php...nfo&userid=380
View this thread: http://www.excelforum.com/showthread.php?threadid=27150

there was no reason to muddle through.

You asked a question. Received a good solution

Ignored it,

Asked for repeated help again even though the solution had been given to
you.

Came back saying you solved the problem and showed essentially the same
solution that had been given to you several hours before.

If you ask for help, you incur a responsibility to at least attempt to use
the help provided.

If you say you don't know anything about coding, why ask for help and then
ignore it.

Yes, I get a little annoyed with people who ask for help, then don't feel
any responsibility to work through a solution. Then Ask for the same help
again when they have received a solution (so others waste their time
developing the same information already received).

So saying "thank you" doesn't exuse your ill manners. If you read my post
as sarcastic, you misinterpreted. Read it as constructive criticism.

--
Regards,
Tom Ogilvy



"scottymelloty" wrote in
message ...

If you want to respond to prompts everytime you run it after the first
time,
you like repetitious code, and you don't mind renaming the current
workbook
to a CSV file (and losing any changes not saved before running the
macro),
then I guess you have a solution.

all i did was add a few of lines

Which 3 people took time to provided you with.

--------------------------------------------------------------------------
-----------------------
Tom,

You are indeed a 1st class prat, Im not sure what the bad attitude is
for in your replys to me but im guessing your someone who dosnt get out
much and has no friends or life and therefore no real interaction with
people in everyday life.

In all of my posts i made it clear how thankful i was with any help
given, i made it clear as well i havnt got a clue about code so i was
muddling thro it, i managed to get something that works for me which is
all i wanted, it dosnt matter to me how much the code is repeated etc as
long as it works, the only time it prompts me for anything is when i
want it to , and i dont want to save the work which ive done so
everything works excellent for what i want.

You also take out a line "all i did was add 3 lines" which you took out
of context and made it look like i was being ignorant or arrogant , i
guess thats more a reflection of your personality than mine, all i was
doing in fact was saying i had solved my problem and showing how i had
done it also by saying thanks at and of post for all help to those who
helped me in the right direction.

Once again thanks to all those helped including Tom, but especially to
those on here who help as much as they can without leaving sarcastic
messages, thanks.


--
scottymelloty
------------------------------------------------------------------------
scottymelloty's Profile:
http://www.excelforum.com/member.php...fo&userid=3808
View this thread: http://www.excelforum.com/showthread...hreadid=271501