Single quite (') in character data

[vpidatala]

Hi,

I have a SQL DTS package exporting data from SQL server to Excel. When
the data is exported to excel, each cell other with character data has
a single quote and some spaces followed by actual data.

I figured out that I can copy the entire sheet and pasting with paste
special with values radio button selected in an other sheet is giving
me clean data.

I am totally new to excel programming. Will some one please let me know
how can I write a Macro to create an other excel file and then copy
each sheet from my excel file and paste using paste special with
"values" radio button selected into the new file.

My original excel file has 6 sheets with lots of data in each.

Thanks in advance.

 

[Pete_UK]

You can create a macro yourself by turning on the macro recorder (Tools
| Macro | Record New Macro, then giving it a name and a keyboard
shortcut such as CTRL-ALT-P), then carrying out the actions you need
for one sheet, ie copy to another sheet with Edit | Paste Special |
Values. Once you have completed the actions you can stop the macro
recorder and then view the resultant code by Tools | Macro | Visual
Basic Editor - from here you can run the macro again, step through one
line at a time, edit the statements etc. You will probably need to edit
the code to enable you to choose a different start and destination
sheet to enable you to re-run the macro 6 times.

Hope this helps.

Pete