Help with Macro
 

Hi. I used a macro once, when someone from here helped me. Sorry to say I
can't find my original post or document. Can someone with this:
Need a macro (it was vb last time)
To search a column and remove the double quote. It will always be in the
same character position, for instance, in column A, it will always end up in
position 27.
I have tried doing a simple edit and replace (replace it with nothing) but
then the text is replaced with scientic notation, even if I format with text.
Thank you for your help.

Help with Macro
 

See the post you tacked onto.

http://tinyurl.com/2xcj73

Is that what you are referring to?


Gord Dibben MS Excel MVP

On Thu, 31 Jan 2008 15:59:01 -0800, Abbey Normal
wrote:

Hi. I used a macro once, when someone from here helped me. Sorry to say I
can't find my original post or document. Can someone with this:
Need a macro (it was vb last time)
To search a column and remove the double quote. It will always be in the
same character position, for instance, in column A, it will always end up in
position 27.
I have tried doing a simple edit and replace (replace it with nothing) but
then the text is replaced with scientic notation, even if I format with text.
Thank you for your help.

Help with Macro
 

Actually, that one is working for me. Thanks, now my question(s) a
1. is there a way I can make this easy for the user to do? or automate it
somewhat?
I am sending her a CSV file via email as an on-request basis, when she ships
to that customer, so she will have to fiddle with this spreadsheet everytime.
2. Is there also a way to format a column as text first? If i don't do that
before I run the macro, the number is replaced in scientific notation.
Thanks for any help you can provide....
"Gord Dibben" wrote:

See the post you tacked onto.

http://tinyurl.com/2xcj73

Is that what you are referring to?


Gord Dibben MS Excel MVP

On Thu, 31 Jan 2008 15:59:01 -0800, Abbey Normal
wrote:

Hi. I used a macro once, when someone from here helped me. Sorry to say I
can't find my original post or document. Can someone with this:
Need a macro (it was vb last time)
To search a column and remove the double quote. It will always be in the
same character position, for instance, in column A, it will always end up in
position 27.
I have tried doing a simple edit and replace (replace it with nothing) but
then the text is replaced with scientic notation, even if I format with text.
Thank you for your help.

Help with Macro
 

I just saw your other post regarding the personal.xls worksheet, and that
works just fine for me. Now the only other question i have is can is there a
way I can have a macro auto'lly change the format of a column to text so this
macro wont change it to sci notation? Thanks a whole bunch!

"Gord Dibben" wrote:

See the post you tacked onto.

http://tinyurl.com/2xcj73

Is that what you are referring to?


Gord Dibben MS Excel MVP

On Thu, 31 Jan 2008 15:59:01 -0800, Abbey Normal
wrote:

Hi. I used a macro once, when someone from here helped me. Sorry to say I
can't find my original post or document. Can someone with this:
Need a macro (it was vb last time)
To search a column and remove the double quote. It will always be in the
same character position, for instance, in column A, it will always end up in
position 27.
I have tried doing a simple edit and replace (replace it with nothing) but
then the text is replaced with scientic notation, even if I format with text.
Thank you for your help.

Help with Macro
 

Make change to one line

c.Value = "'" & re.Replace(c.Text, "")

That adds an apostrophe to each cell.


Gord


On Fri, 1 Feb 2008 15:29:17 -0800, Abbey Normal
wrote:

I just saw your other post regarding the personal.xls worksheet, and that
works just fine for me. Now the only other question i have is can is there a
way I can have a macro auto'lly change the format of a column to text so this
macro wont change it to sci notation? Thanks a whole bunch!

"Gord Dibben" wrote:

See the post you tacked onto.

http://tinyurl.com/2xcj73

Is that what you are referring to?


Gord Dibben MS Excel MVP

On Thu, 31 Jan 2008 15:59:01 -0800, Abbey Normal
wrote:

Hi. I used a macro once, when someone from here helped me. Sorry to say I
can't find my original post or document. Can someone with this:
Need a macro (it was vb last time)
To search a column and remove the double quote. It will always be in the
same character position, for instance, in column A, it will always end up in
position 27.
I have tried doing a simple edit and replace (replace it with nothing) but
then the text is replaced with scientic notation, even if I format with text.
Thank you for your help.