完善资料让更多小伙伴认识你,还能领取20积分哦, 立即完善>
我正在将数据从VEE程序记录到Excel中。
excelfile在后台工作(excel设置中的visible = false)。 我想找到一种方法,用户可以在日志记录期间打开文件的副本而不破坏原始文件如果我在资源管理器中制作副本并双击它,副本和原始文件都打开了。有谁知道一个 聪明的方法为最终用户做这个安全吗? 以上来自于谷歌翻译 以下为原文 I am logging data from a VEE-program into Excel. The excelfile is working in the background (visible = false in excel settings). I want to find a way that the user can open a copy of the file during the logging without destroying the original file If i make a copy in the explorer and double click on it both the copy and the original file is opened. Does anyone know a smart way to do this fale safe for the end user? |
|
相关推荐
5个回答
|
|
我尝试过也无法让它起作用。
使用.NET数据网格控件向用户显示数据怎么样? VEE示例 DotNET控件中有两个示例:DataGrid.vee和DataGridView.vee.-mk 以上来自于谷歌翻译 以下为原文 I tried and cannot get it to works also. What about displaying the data to user using .NET Data grid control? There are two examples in VEE ExampleDotNET Controls: DataGrid.vee and DataGridView.vee. -mk |
|
|
|
我认为我需要在excel中打开它,因为用户想要创建图表等等。解决它的方法可能是打开第二个excel会话。
因为如果我通过Windows中的开始meny打开excel然后打开工作簿的副本然后它就可以了。但我不知道如何在VEE中打开第二个会话。希望有人可以帮助我./Mathias 以上来自于谷歌翻译 以下为原文 I think i need to have it opened in excel since the user want to create charts and so on. A way to solve it could be to open a second session of excel. Because if I open excel through the start meny in windows and then open the copy of the workbook then it works. But i dont know how to open a second session within VEE. Hope that someone can help me with this. /Mathias |
|
|
|
在测试开始时在VEE公式框中设置xlApp.ignoreremoterequests = TRUE。
在测试结束时将其设置为False。使用此设置,Excel将生成一个用于打开文件的新实例(供用户查看),而不会干扰VEE使用的实例。 但请记住,这只会显示在此之前收集的数据; 此文件打开时添加的任何新数据都不会显示。 以上来自于谷歌翻译 以下为原文 Set xlApp.ignoreremoterequests = TRUE in VEE formula box at the beginning of the test. Set the same to False at the end of the test. With this setting, Excel will spawn a new instance for opening files (for viewing by the user) without disturbing the instance used by VEE. However, remember that this will only show the data collected until that time; any new data added while this file is open is not shown. |
|
|
|
这是一个好主意。核心问题是excel没有为它开启一个新任务,它只在一个正在运行的excel应用程序中打开一个新的excel书。有一种方法可以强制excel作为2个程序并行运行 - 所以2
时间ecxel - 通过并行按一个按钮excel mouseclick.It是Shift togetether with exccel start to force for 2 excel threads。原则上我们必须以类似的方式使用remote来获得2个独立的excel运行.... 关于背景的描述可能是:http://www.techrepublic.com/forum/discu ... ion-thread因此,questoin仍然是如何按下Shift键启动execl的? 以上来自于谷歌翻译 以下为原文 Thats a good idea. The core problem is that excel do not open a new task for it , it opens just a new excel book within a running excel application. There is a way to force excel to run as 2 programs in parallel - so 2 time ecxel - by pressing a button in parallel to excel mouseclick. It is Shift togetether with exccel start to force for 2 excel threads. In principle we have to do it with remote in similar way to get 2 independent excel runs.... A description about the background may be : http://www.techrepublic.com/forum/discu ... ion-thread So the questoin remains how to start execl with shift key pressed? |
|
|
|
我没有清楚地理解你的评论,但以下是我在上一篇文章中所说的内容。使用IgnoreRemoteRequests = TRUE,会打开一个全新的Excel进程。
它不是同一个Excel打开另一个工作簿。 检查任务管理器,您将看到两个Excel进程正在运行 - 两者完全独立。 您可以随时关闭VEE未使用的进程,VEE继续正常运行。换句话说,一个Excel进程专用于VEE。 我们可以继续使用Excel执行其他任务 - 甚至可以查看VEE本身正在更新的工作簿。 这个IgnoreRemoteRequests非常强大。 以上来自于谷歌翻译 以下为原文 I did not understand your comment clearly, but the following is what I was saying in a previous post. With IgnoreRemoteRequests = TRUE, a completely new Excel process is opened. It is not the same Excel opening another workbook. Check the Task manager and you would see two Excel processes running - both are totally independent. You can close the process not used by VEE any time, VEE continues normally. In other words, one Excel process is dedicated to VEE. We can continue to use Excel for other tasks - even to view the workbook being updated by VEE itself. This IgnoreRemoteRequests is pretty powerful. |
|
|
|
只有小组成员才能发言,加入小组>>
1296 浏览 0 评论
2378 浏览 1 评论
2199 浏览 1 评论
2068 浏览 5 评论
2955 浏览 3 评论
1137浏览 1评论
关于Keysight x1149 Boundary Scan Analyzer
759浏览 0评论
N5230C用“CALC:MARK:BWID?”获取Bwid,Cent,Q,Loss失败,请问大佬们怎么解决呀
946浏览 0评论
1297浏览 0评论
小黑屋| 手机版| Archiver| 电子发烧友 ( 湘ICP备2023018690号 )
GMT+8, 2024-12-28 05:07 , Processed in 1.185456 second(s), Total 56, Slave 50 queries .
Powered by 电子发烧友网
© 2015 bbs.elecfans.com
关注我们的微信
下载发烧友APP
电子发烧友观察
版权所有 © 湖南华秋数字科技有限公司
电子发烧友 (威廉希尔官方网站 图) 湘公网安备 43011202000918 号 电信与信息服务业务经营许可证:合字B2-20210191 工商网监 湘ICP备2023018690号