换句话说,将字符串转换为位置 [英] In word, convert a string into a location
问题描述
我从某个网页获得了预期的上传量,该网页给了我ETA:XXXX. XXXX是国际民航组织.我有一个带有Sheet1的Excel文档,在ColA中有ICAO,在Col B中有全文.
I hav a set upput from a web page that gives me ETA: XXXX. the XXXX is an ICAO. I have a Excel doc with Sheet1 having the ICAO in ColA and the full text in Col B.
我正在寻找要搜索的代码/想法. "ETA:"然后在Excel文档中查找接下来的四个字母(国际民航组织).然后将ICAO替换为B栏中的内容,改为Doc一词.
I am looking for code/thoughts to search for "ETA:" the take the next four letters (the ICAO) look up in the excel doc. The ICAO would then be replaced it with what is in col B back into the word Doc.
我在Excel中工作,但是我是单词编码的新手.
I am worked in Excel but I am new to word coding.
请帮助
推荐答案
这些论坛适用于VB. NET问题.
Excel/word/Access中的VB是Visual Basic for Application. VBA与VB.NET的产品截然不同,在其他一些地方,您可能会更快并更好地回答您的VBA问题.
The VB within Excel/word/Access is Visual Basic for Application. VBA is a very different product from VB.NET and there are some other locations where youy will probably get a quicker and better response to your VBA questions.
Y
You may find more assistance in following which specifically deals with VBA development.
http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=74&SiteID=1
http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=74&SiteID=1
或者如果您是从Office应用程序内部使用VBA
办公自动化:office.developer.automation新闻组
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.office.developer.automation&lang=en&cr=US
或Office Newgroup
http://www.microsoft.com/office/community/en-us/default .mspx?d = 1
http://www.microsoft.com/office/community/en-us/default.mspx?d=1
希望有帮助的
这篇关于换句话说,将字符串转换为位置的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!