VBA从“编辑”获取文本在MA之外的应用控制 [英] VBA Get text from "Edit" Control in Application outside of MA

问题描述

我通常能够研究我需要做什么，尤其是在本网站的大量帮助下。不幸的是，我在如何检索编辑中的值时画了一个空白。在Access之外的应用程序中进行控制。我已经能够做几个版本甚至通过每个打开的窗口并获得所有子窗口，但我只能在标签中返回该文本。


我找到另一个脚本它做了同样的事情，但它也没有返回所有编辑的值。控制。我尝试了各种SendMessage函数，没有运气。任何人都可以告诉我这个缺失的部分，让它一切正常吗？这是someones脚本的代码，显示了我遇到的同样问题。任何帮助将不胜感激。

I have usually been able to research what I need to do, especially with a lot of help from this website. Unfortunately I am drawing a blank on how to retrieve the value in an "Edit" control in an application outside of Access. I have been able to do a few versions that even go through every open window and get all the child windows but am only able to return that text in a label.

I located another script that did the same thing but it too doesn''t return the values for all "Edit" controls. I have tried various SendMessage functions with no luck. Can anyone please show me the missing piece to make it all work? Here is the code of someones script that shows the same issue I am having. Any help would be greatly appreciated.

展开 | 选择 | Wrap | 行号

推荐答案

嗯，我没有一个良好的开端。我从Excel中复制了版本而不是Access，但它做了同样的事情。对于那个很抱歉。我可以重新提交，如果这会引起混淆。

Well, I am not off to a good start. I copied the version from Excel not Access but it does the same thing. Sorry about that. I can resubmit if this will cause confusion.

DesktopFlyer，


欢迎来到字节！


看起来你的代码在看起来时会做很多搜索。你已经知道你在寻找什么。但是，我可能还不完全明白你想要做什么。


如果你知道你想要的应用程序，那么，你应该可以直接去它：

DesktopFlyer,

Welcome to Bytes!

It seems like your code is doing a lot of searching for something when it "seems" that you already know what you are looking for. But, I may not completely understand exactly what you are trying to do.

If you know the application that you are trying to target, then, you should be able to go directly to it:

展开 | 选择 | Wrap | 行号

感谢您的欢迎和反馈，我常常太顽固地问求助，但这个已经杀了好几天了。我可以将它转到我需要数据的一个应用程序，但这样它会滚动浏览每个打开的窗口和所有子窗口/控件。我可以看到所有的控件，但它的编辑是控制我无法检索的文本或值。


一旦我得到脚本返回文本，我将把它存储在一个表中。

Thank you for the welcome and the feedback, I''m usually too stubborn to ask for help but this one has killed several days now. I am able to have it go to the one application that I need the data from but this way it scrolls through every open window and all of their child windows/controls. I am able to see all the controls but its the "Edit" controls text or value that I cannot retrieve.

Once I get the script to return the text I will then store it in a table.

这篇关于VBA从“编辑”获取文本在MA之外的应用控制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！