C
Chappy
Hi guys,
I'm not sure if this can even be done so please excuse my ignorance if it
can't.
I currently have a macro that is used to clean phone numbers. This is a Word
macro and is used to remove all non numerical characters.
I receive an Excel spreadsheet that contains a whack of phone numbers in a
number of fields. I want to clean these phone numbers by using a macro to
copy from excel to word, clean with the word macro, and then return back to
the relevant excel column.
The Word macro doesn't like to play ball like this. Works fine if I do it
manually (copy the column, paste it into Word, run the macro, copy it back
and then paste it into a text column) but when I try to test it with the
excel macro, it's a no go.
I receive an error message - Run-time error '1004': Pastespecial method of
Worksheet class failed.
I presume (seeing as word didn't even open) that this aspect just didn't
happen, hence causing the problem.
I can't perform the clean in Excel as it removes all leading zeros, which I
need....
Any help, or a simple 'No chance champ', is appreciated.
Thanks,
Chaps.
I'm not sure if this can even be done so please excuse my ignorance if it
can't.
I currently have a macro that is used to clean phone numbers. This is a Word
macro and is used to remove all non numerical characters.
I receive an Excel spreadsheet that contains a whack of phone numbers in a
number of fields. I want to clean these phone numbers by using a macro to
copy from excel to word, clean with the word macro, and then return back to
the relevant excel column.
The Word macro doesn't like to play ball like this. Works fine if I do it
manually (copy the column, paste it into Word, run the macro, copy it back
and then paste it into a text column) but when I try to test it with the
excel macro, it's a no go.
I receive an error message - Run-time error '1004': Pastespecial method of
Worksheet class failed.
I presume (seeing as word didn't even open) that this aspect just didn't
happen, hence causing the problem.
I can't perform the clean in Excel as it removes all leading zeros, which I
need....
Any help, or a simple 'No chance champ', is appreciated.
Thanks,
Chaps.