String to excel need " removed

Started by Lars-Erik, June 04, 2008, 02:45:00 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Lars-Erik

I use this code:
appExcel.ActiveCell.Cells(10 + i, 3) = collShapes.Item(i).CellsSRC(visSectionProp, n, visCustPropsValue).FormulaU
to send some data to my excel (creating a custom BOM, pain in the ass :O)

anyway, its working but showing up as "value" in excel with quotes. cant get them removed using replace function.
Any thoughts anyone?

- Lars

Visio Guy

Hmmm. Guesss:

ExcelCell.Value =
ExcelCell.Value2 =
ExcelCell.Text =

shp.Cells(...).ResultStr(visNoCast)
For articles, tips and free content, see the Visio Guy Website at http://www.visguy.com
Get my Visio Book! Using Microsoft Visio 2010