使用excel VBA比较和替换visio文本 [英] compare and replace visio text using excel VBA
问题描述
我尝试比较excel和visio中的文本,如果文本匹配,则用一系列excel文本替换该visio文本。有人有任何实验吗?任何理想都将是一个很大的帮助。
谢谢
I try to compare the text in excel and visio, if the text match, then replace that visio text with a range of excel text. Do anybody have any experiment with that? any ideal will be a big help.
Thanks
推荐答案
我尝试比较excel和visio中的文本,如果文本匹配,则用一系列excel文本替换该visio文本。有人有任何实验吗?任何理想都将是一个很大的帮助。
谢谢
I try to compare the text in excel and visio, if the text match, then replace that visio text with a range of excel text. Do anybody have any experiment with that? any ideal will be a big help.
Thanks
好像我已经给了你所需要的一切,所以你不清楚你遇到了什么麻烦。 excel文本是单元格还是形状?你怎么知道使用哪种Visio形状?如何将Excel范围文本插入到Visio形状中?多行?
Seems like I''ve already given you all that you need, so it''s not clear what you having trouble with. Is the excel text in a cell or a shape? How do you know which Visio shape to use? How is the Excel Range Text inserted into the Visio shape? In multiple lines?
好像我已经把你所需要的全部都给了你,所以你不清楚你是什么遇到麻烦。 excel文本是单元格还是形状?你怎么知道使用哪种Visio形状?如何将Excel范围文本插入到Visio形状中?多行?
Seems like I''ve already given you all that you need, so it''s not clear what you having trouble with. Is the excel text in a cell or a shape? How do you know which Visio shape to use? How is the Excel Range Text inserted into the Visio shape? In multiple lines?
在visio绘图中有一个带有文本ABC的文本框,
excel单元格(一列中的两个单元格)有文本:
" ABC
DEF"。
我想要的是从excel VBA打开visio绘图后,如果是ABC ;在visio matchABC中在excel中,然后替换ABC。在visio中
" ABC
DEF"。
任何理想的?我能想到的只是替换。功能,但仍然无法找到方法。
In a visio drawing have a textbox with text "ABC",
in excel cells (two cells in one column) have text:
"ABC
DEF".
What I want is after I open the visio drawing from excel VBA, if the "ABC" in visio match "ABC" in excel, then replace the "ABC" in visio with
"ABC
DEF".
Any ideal? all i can think about is the "replace" function, but still cannot figure out a way.
这对我有用:
This works for me:
这篇关于使用excel VBA比较和替换visio文本的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!