Johnosley
08-09-2010, 12:24 PM
I have a word document which is copy/paste to excel using VBA macro.
Basically, the word document consists of tables with data. The VBA macro get each data from specific cell and then copy the data to a specific cell in excel.
It works well. Thanks Tinbendr and Gmaxey for your great help on that.
Now I have an other problem... word character !
In word I could have: « in word » or I’m
But in excel I would like to see "in word" or I'm
The data from excel will be uploaded to an other software which doesn't recognize the « and ’ and the upload will generate errors.
Is there a way to avoid such problem. And I guess my examples are not the only one. May be. Did someone encounter that problem before ?
Thank you
I know that the substitute function works but it has to be done one specific character by one and also in VBA what could be the code for word/excel character. Are they the same ?
Basically, the word document consists of tables with data. The VBA macro get each data from specific cell and then copy the data to a specific cell in excel.
It works well. Thanks Tinbendr and Gmaxey for your great help on that.
Now I have an other problem... word character !
In word I could have: « in word » or I’m
But in excel I would like to see "in word" or I'm
The data from excel will be uploaded to an other software which doesn't recognize the « and ’ and the upload will generate errors.
Is there a way to avoid such problem. And I guess my examples are not the only one. May be. Did someone encounter that problem before ?
Thank you
I know that the substitute function works but it has to be done one specific character by one and also in VBA what could be the code for word/excel character. Are they the same ?