精华内容
下载资源
问答
  • 采用excel,写一小段vba代码:PrivateSubWorksheet_Change(ByValTargetAsRange)Sheets("Sheet1").Select'选择第一页面IfTime>=TimeV...我们需要得到银行的实时汇率并导入自己的数据库表中.采用excel,写一小段vba...

    我们需要得到银行的实时汇率并导入自己的数据库表中.采用excel,写一小段vba代码:PrivateSubWorksheet_Change(ByValTargetAsRange)Sheets("Sheet1").Select'选择第一页面IfTime>=TimeV...

    我们需要得到银行的实时汇率并导入自己的数据库表中.采用excel,写一小段vba代码:

    Private Sub Worksheet_Change(ByVal Target As Range)

    Sheets("Sheet1").Select '选择第一页面

    If Time >= TimeValue("08:30:00") And Time <= TimeValue("17:30:00") Then '从8:00到17:30每10分钟刷新一次

    RefreshPeriod = 10 '刷新频率为10分钟一次

    For Page = 9 To 0 Step -1 '网页共有10个页面,时间最后的为第一个页面,所有采取倒序

    Cells.Delete '清除上次的内容

    If Page > 0 Then

    page1 = "_" & Trim(Str(Page)) '第n+1个页面为http://www.boc.cn/sourcedb/whpj/index_n.html

    Else

    page1 = "" '第一个页面为 http://www.boc.cn/sourcedb/whpj/index.html

    End If

    With ActiveSheet.QueryTables.Add(Connection:= _

    "URL;http://www.boc.cn/sourcedb/whpj/index" & page1 & ".html", _

    Destination:=Cells(1, 1))

    .refresh BackgroundQuery:=False

    End With

    '将汇率写入程序的语句

    Next Page

    Else '17:30以后

    RefreshPeriod = 900 '下次刷新为15小时之后,即第二天的8:30

    End If

    End Sub

    如果将此段程序放入 Private Sub Worksheet_SelectionChange(ByVal Target As Range) 可正常运行,但放入Private Sub Worksheet_Change(ByVal Target As Range) 就会报错.请高手赐教.

    展开

    展开全文
  • vba 错误 自动化错误Much of our world today relies increasingly on automated solutions. The results often enrich our lives by enabling workers to spend less time on manual tasks and more time for ...

    vba 错误 自动化错误

    Much of our world today relies increasingly on automated solutions. The results often enrich our lives by enabling workers to spend less time on manual tasks and more time for creativity, innovation, and enjoyment.

    今天,我们世界上的许多人越来越依赖自动化解决方案。 通过使工作人员减少在手动任务上的时间,而将更多的时间用于创造力,创新和娱乐上,结果通常可以丰富我们的生活。

    Particularly relevant is the current push towards development of contact-tracing apps and other solutions that could help all of us take steps to protect our health, and that of our loved ones, while benefitting from as full and rich a life as possible. Tempted by the rewards offered by automated solutions, all of us, perhaps especially software developers and technology entrepreneurs, are susceptible to some of these common traps.

    特别重要的是,当前正在努力开发接触式跟踪应用程序和其他解决方案,这些解决方案可以帮助我们所有人保护自己和亲人的健康,同时尽可能地享受充实和丰富的生活。 受到自动化解决方案提供的奖励的诱惑,我们所有人,尤其是软件开发人员和技术企业家,都容易受到其中一些常见陷阱的影响。

    Automation for its own sake

    自动化本身

    When do we do it?

    我们什么时候做?

    This can happen when we become frustrated with a manual process that is part of our everyday lives. Perhaps a friend, colleague, or favourite online influencer has been boasting about their automation successes. We know that, when used appropriately, automation can assist humans with well understood but laborious tasks, freeing us up to tackle more complex problems. It’s understandably tempting for any individual or business adopting a tool or approach with a good reputation to assume it will bring great benefits and jump right into using it, regardless of whether it truly applies to our use case.

    当我们对日常生活中的手动过程感到沮丧时,就会发生这种情况。 也许朋友,同事或最喜欢的在线影响者一直吹嘘他们的自动化成功。 我们知道,如果使用得当,自动化可以帮助人们完成众所周知但费力的任务,使我们有更多的精力去解决更复杂的问题。 可以理解的是,任何个人或企业都采用具有良好声誉的工具或方法,认为它会带来巨大的好处并立即使用它,而不论它是否真正适用于我们的用例。

    Why shouldn’t we do it?

    我们为什么不应该这样做呢?

    When we don’t have a clearly defined problem, or we can’t really explain why the tool or process we want to use will help us solve our problem or meet our goals more efficiently, the most likely outcome is that we end up with two problems; the still sub-optimal status quo, and the added complexity of the new “solution” that didn’t actually help. Instead of accepting that automation didn’t have the miraculous results we’d hoped for, many of us are tempted to “double down” and continue to try to make the new shiny thing work as well as we want it to (see the next section on “silver bullet” syndrome).

    当我们没有明确定义的问题,或者我们无法真正解释为什么我们要使用的工具或流程可以帮助我们解决问题或更有效地实现目标时,最有可能的结果就是我们最终两个问题; 仍然不理想的现状,以及新的“解决方案”的复杂性实际上并没有帮助。 我们中的许多人不但没有接受自动化并没有取得我们希望的奇迹般的结果,反而很想“加倍努力”,并继续尝试使新的闪亮事物按我们希望的那样工作(请参阅下一篇) “银弹”综合症部分)。

    What are the consequences?

    有什么后果?

    For several years, Elon Musk’s approach to manufacturing the iconic and expensive Tesla car was a high-profile example of automation for its own sake. Musk’s dream of a futuristic, fully automated process was proven to have more style than substance when it repeatedly led to production below 50% of targets. Despite significant improvements, financial analysts have remained sceptical about Tesla’s ability to align production numbers with their valuation. Musk’s tendency to automate for its own sake also failed spectacularly in 2018 when his apparently altruistic but arguably over-engineered attempt to rescue a cave-trapped group of children and their coach was politely rebuffed in favour of a manual rescue operation led by experienced divers. While it’s not the worst suggestion Musk made during the emergency, one could argue that his impulse to over-automate appears to have caused more problems in his business than it has solved.

    多年来,埃隆·马斯克(Elon Musk)制造标志性且昂贵的特斯拉汽车的方法本身就是自动化的备受瞩目的例子。 当马斯克一再导致产量低于目标的50%时,马斯克梦想的一种具有未来主义意义的,完全自动化的过程将具有更多的风格。 尽管取得了重大进步,但金融分析师仍对特斯拉能否将生产数量与估值保持一致持怀疑态度 。 马斯克为自己的利益实现自动化的趋势在2018年也以失败告终,当时他显然是无私的,但可以说是过度设计的尝试来挽救一群被困在洞穴中的儿童 ,他们的教练被礼貌地拒绝了,转而支持由经验丰富的潜水员领导的手动救援行动。 尽管这不是马斯克在紧急情况下提出的最糟糕的建议 ,但有人可以辩称,他过度自动化的冲动似乎给他的业务造成了比解决的问题更多的问题。

    How do we avoid it?

    我们如何避免呢?

    Listen to the words you use when you pitch an automated solution to someone else. Are you clearly outlining a problem or inefficiency that you have, and a potential solution, or are you simply praising the solution’s popularity, proponents, or elegance in general terms?

    将自动解决方案推销给其他人时,请听您使用的词语。 您是否清楚地概述了存在的问题或效率低下以及可能的解决方案,还是只是在总体上称赞该解决方案的受欢迎程度,拥护者或优雅?

    Don’t say: Python_Rockstar82, clever developer person, use build tool. Me use build tool also, be rock star too.

    不要说:聪明的开发人员Python_Rockstar82,使用构建工具。 我也使用构建工具,也是摇滚明星。

    Do say: We’re losing a lot of development time due to inconsistencies in our build scripts. Each app has to be updated manually every time we become aware of a security vulnerability or simply find a better approach. I think we could save a lot of time and increase the stability of our applications if we create a command line interface that updates our scripts to the latest template.

    请说:由于我们的构建脚本不一致,我们浪费了很多开发时间。 每当我们意识到安全漏洞或只是找到更好的方法时,必须手动更新每个应用程序。 我认为,如果我们创建一个将脚本更新为最新模板的命令行界面,则可以节省大量时间并提高应用程序的稳定性。

    Seeing automated solutions as “silver-bullets” that can act alone

    将自动化解决方案视为 可以单独行动的 银子弹

    When do we do it?

    我们什么时候做?

    We’re are arguably at highest risk of this syndrome when we’ve learned just enough about an automated tool or approach to become convinced it will improve productivity and / or reduce costs. Unfortunately, at this point, we have no solid evidence that this is the case, but end up rolling it out across the business anyway in the hopes that results will reward our confidence. This often results in expectations far greater than the tool or process can ever provide. Early successes with prototypes and general enthusiasm about a solution can lead us to stop evaluating and improving the process, or even bothering to sufficiently train ourselves and others on how it works. Letting the machine take care of itself frees up humans for more creative and communications-based tasks and exploration of new ideas.

    当我们对自动工具或方法了解得足够多,使我们确信该工具或方法将提高生产率和/或降低成本时,我们面临这种综合征的风险最高。 不幸的是,在这一点上,我们没有确凿的证据证明确实如此,但是最终还是将其推广到整个企业,希望结果能回报我们的信心。 这常常导致期望远远超过工具或过程所能提供的期望。 原型的早期成功和对解决方案的普遍热情可能导致我们停止评估和改进过程,甚至不愿对自己和他人进行充分的培训。 让机器自己照顾自己可以使人们腾出更多精力进行更具创意和基于交流的任务,并探索新的思想。

    Why shouldn’t we do it?

    我们为什么不应该这样做呢?

    Any automated solution is only good as its design and training. Demonstrations of prototypes applied to limited use cases are often impressive, but widely rolling out an automated system without a plan for its ongoing evaluation, maintenance, and monitoring can result in the organisation working for the machine, rather than the other way around. If you don’t understand the extent of what your tool does, or why it’s doing it, then the tool doesn’t really know either. At that point, identifying and solving problems can become a colossal task.

    任何自动化解决方案都只有其设计和培训才能发挥作用。 应用于有限用例的原型的演示通常令人印象深刻,但是如果在没有计划进行持续评估,维护和监视的情况下广泛部署自动化系统,则会导致组织为机器工作,而不是相反。 如果您不了解工具的功能范围或执行原因,那么该工具也不知道。 到那时,识别和解决问题可能成为一项艰巨的任务。

    What are the consequences?

    有什么后果?

    US IT contractor Ibrahim Diallo was mistakenly terminated, locked out of every system he could access, and even escorted from the building by security because his former manager had failed to renew his contract. Ibrahim reported that it took the company three weeks to figure out that their own software appeared to have triggered these events without any human understanding how or why. It’s hard to say what the exact cost of this mistake was, but, it appears that through over-reliance on their automated systems to manage themselves, this organisation ended up suspending the activities of a skilled professional for the better part of a month, taking other staff away from their duties to rectify the problem, and suffering morale and reputational damage.

    美国IT承包商易卜拉欣·迪亚洛(Ibrahim Diallo)错误地终止了工作 ,被他可以访问的每个系统都锁定了,甚至由于安全原因而被护送出大楼,因为他的前任经理未能续签合同。 易卜拉欣报道说,公司花了三周的时间才弄清楚他们自己的软件似乎触发了这些事件,而没有任何人类了解如何或为什么。 很难说出这个错误的确切代价是什么,但是,看来,由于过度依赖他们的自动化系统来管理自己,这个组织最终暂停了熟练技术人员的活动,为期一个月的大部分时间,其他员工则无法纠正问题,并士气和声誉受到损害。

    How do we avoid it?

    我们如何避免呢?

    Be cautious in any new implementation, ideally rolling it out to a small group first. Monitor its effectiveness against pre-defined metrics, such as time spent debugging, number of manual tasks that require developer time, or bug reports that reference regressions or inconsistencies between systems. Always have a defined fallback plan in the event you don’t like what the numbers are telling you.

    在任何新实施中都要谨慎,最好先将其推广到一个小组。 根据预定义的指标(例如花费的调试时间,需要开发人员时间的手动任务数量或引用系统之间的回归或不一致的错误报告)来监视其有效性。 如果您不喜欢数字告诉您的内容,请务必制定定义的后备计划。

    Don’t say: I read an article that advocated a fully automated pipeline with no manual approval step. I’m sick of having to wait to get code that has passed all of our tests out to users. Let’s immediately remove the manual step for all of our apps and spend the savings we’re bound to make on an office treehouse.

    不要说:我读过一篇文章,提倡全自动流水线,无需人工批准。 我讨厌不得不等待获得将所有测试传递给用户的代码。 让我们立即删除所有应用程序的手动步骤,然后将节省下来的钱花在办公室树屋上

    Do say: We are going to try a fully automated pipeline for our most mature and well understood application for one month. If all automated tests pass in the staging environment, the pipeline will deploy automatically to production with no human intervention. During this time, we will compare our bug reports and production incident statistics with the previous month, which required a human to approve promotion of a release to production. We will also evaluate the difference in how developers and test engineers use their time to see if this could be a beneficial approach for all of our applications. If it doesn’t go well, switching the manual approval step back on is a thirty second job.

    请说:我们将为我们最成熟,最容易理解的应用程序尝试一个全自动管道,为期一个月。 如果所有自动化测试都在过渡环境中通过,则管道将自动部署到生产中,而无需人工干预。 在此期间,我们将把错误报告和生产事件统计信息与上个月进行比较,这需要人工批准将产品发布发布。 我们还将评估开发人员和测试工程师如何利用他们的时间来查看这是否对我们所有应用程序都是有益的方法的差异。 如果操作不顺利,请重新启动手动批准步骤是一项三十秒的工作。

    Implementing an automated solution before you have a good manual one

    在拥有良好的手动解决方案之前实施自动化解决方案

    When do we do it?

    我们什么时候做?

    Even when automation really does have the potential to change our lives for the better, we cannot reap the benefits without understanding how and why it does so. One of the best ways to understand an automated solution is to know how to solve the problem manually first. Anyone who has ever made a cup of coffee or vacuumed a floor can understand how a machine would go about solving the same problem, and how to recognise when the machine messes up and we need to jump in. But so many facets of our lives are now beautifully tech-enhanced that it seems like a waste of time establishing manual processes before automating them. We’re so used to great solutions from machines, we want to jump straight to that endpoint in every situation.

    即使自动化确实确实有潜力使我们的生活变得更好,但如果不了解这样做的方式和原因,我们也无法获得收益。 理解自动化解决方案的最好方法之一是先知道如何手动解决问题。 曾经喝过咖啡或用吸尘器吸过地板的任何人都可以理解机器如何解决相同的问题,以及如何识别机器何时混乱,我们需要跳进去。但是,我们生活中的许多方面现在通过精美的技术增强功能,似乎在自动建立手动流程之前浪费时间。 我们已经习惯了使用机器提供出色的解决方案,因此在每种情况下我们都希望直接跳到该端点。

    Why shouldn’t we do it?

    我们为什么不应该这样做呢?

    When automation didn’t work as well at Tesla as Musk hoped, he was able to fall back on established car manufacturing processes that have been in place for a long time. When we automate before establishing how this problem might be solved by humans using older or no technology, we have no fallback plan if the automated solution doesn’t work. At best, a working solution will be delayed, and, at worst, the problems caused by the automated solution will make solving the problem manually harder than it had to be. Using established manual approaches first, and better understanding why they work in your particular context, is also likely to inform a more appropriate, human-assistive automated process. A comparable manual process is also an effective way of explaining to users what an automated solution is trying to achieve.

    当特斯拉的自动化工作不如马斯克所希望的那样时,他便能够依靠已存在很长时间的既定汽车制造Craft.io。 当我们在确定人类如何使用较旧的技术或不使用任何技术解决此问题之前实现自动化时,如果自动化解决方案不起作用,我们将没有备用计划。 充其量,一个有效的解决方案将被延迟,而在最坏的情况下,由自动化解决方案引起的问题将使手动解决问题的难度比必须解决的困难。 首先使用已建立的手动方法,并更好地了解它们在您的特定情况下起作用的原因,也可能会为更合适的,人为辅助的自动化过程提供信息。 可比的手动过程也是向用户解释自动化解决方案要实现的有效方法。

    What are the consequences?

    有什么后果?

    Throughout April and May 2020, the UK government spoke confidently about the key role a bespoke contact tracing app would have in their response to the Covid19 pandemic. However, after a disappointing attempt to launch the app to users in a small part of the UK, the government were forced to de-prioritise the app and quickly throw resources into the training and support of human contact tracers to follow up with associates of individuals who had tested positive. Without providing potential users with clear information about the app’s goals, abilities, or expectations, uptake was low, and confusion and misinformation high. A junior health minister was forced to admit “it is probably a mistake to launch an app before you have got the public used to the idea of tracing”.

    在整个2020年4月和2020年5月,英国政府充满信心地谈到了定制的联系人跟踪应用程序在应对Covid19大流行中所起的关键作用。 但是,在尝试向英国一小部分用户推出该应用程序后,令人失望的是,政府被迫取消该应用程序的优先级,并Swift将资源投入到人类接触追踪器的培训和支持中,以跟进个人的同事谁测试阳性。 如果没有为潜在用户提供有关应用程序的目标,功能或期望的清晰信息,则普及率很低,混乱和错误信息很高。 初级卫生部长被迫承认“ 在让公众习惯追踪之前,启动应用程序可能是一个错误 ”。

    Don’t say: Our developers aren’t taking the time to write helpful commit messages. Let’s implement all of the hooks to enforce a structure, and very long PR templates. That’ll learn ’em, probably.

    不要说:我们的开发人员不会花时间来编写有用的提交消息。 让我们实现所有挂钩以强制执行结构,以及非常长的PR模板 。 可能会学到它们。

    Do say: Our developers aren’t demonstrating an understanding of how to write helpful commit messages. Let’s provide clear guidance as to what makes a great commit message, lead by example, and get feedback from the developers as we discuss potential ways to improve the quality of our shared git log, including automated solutions.

    一定要说:我们的开发人员并没有表现出对如何编写有用的提交消息的理解。 让我们提供清晰的指导 ,以指导示例为例,提供最佳的提交信息,并在讨论提高自动化git日志质量的潜在方法时,从开发人员那里获取反馈。

    Conclusion

    结论

    Technologically enhanced and automated solutions continue to be applied effectively to a wide range of problems and situations, and this is a very good thing. However, allowing automation to be its own justification is a serious business risk. Any new approach, however exciting, must be exposed to a rigorous cost benefit analysis. We all must take an evidence-based approach to evaluating the tools and processes they use over the long term to ensure that the machines work for the humans, and not the other way around!

    经过技术增强和自动化的解决方案继续有效地应用于各种问题和情况,这是一件非常好的事情。 但是,让自动化成为自己的理由是严重的业务风险。 任何新方法,无论多么令人兴奋,都必须接受严格的成本效益分析。 我们所有人都必须采取基于证据的方法来评估它们长期使用的工具和过程,以确保机器对人类有效,而不是相反!

    翻译自: https://medium.com/dev-genius/classic-automation-mistakes-2bf74ad485ad

    vba 错误 自动化错误

    展开全文
  • 跑了一个多月的程序运行时突然报错, 怎么都调不好, 换电脑之后就OK了… 要疯掉… 估计是电脑卸载了啥东西,或装了啥东西,中毒了??? 慢慢找吧[哭]

    在这里插入图片描述

    跑了一个多月的程序运行时突然报错,
    怎么都调不好,
    换电脑之后就OK了…
    要疯掉…

    估计是电脑卸载了啥东西,或装了啥东西,中毒了???
    慢慢找吧[哭]

    备注6/30,
    解决方法:将原文件copy发送到另一台电脑,能够运行之后,再发送回来替换原文件,就能运行了…
    神奇…
    在这里插入图片描述

    展开全文
  • 自动化automation错误",我的系统是由EXCEL的VBA调用ACCESS中的方法,并且传入集合等参数。 当然由于我的电脑更换了,换了OFFICE版本,导致了这个问题,但是任凭我如何重装OFFICE或者装回原来的版本,...

    最近在测试自己做的一款校验软件时发生了"自动化(automation)错误",我的系统是由EXCEL的VBA调用ACCESS中的方法,并且传入集合等参数。

    当然由于我的电脑更换了,换了OFFICE版本,导致了这个问题,但是任凭我如何重装OFFICE或者装回原来的版本,仍然无法解决这个问题。

    这个报错代码在ACCESS中,问题报错在我的collection集合上。如下代码就是报错行。

    For Each SEQ_KQ In SEQ_coll

    于是我进行调试了下,发现该集合不是一RUN到这句就报错,是循环了若干次后才报错。我网上查了很多关于这个automation的报错,都无法解决我的问题。

    在我万念俱灰时,抱着继续尝试的心态,在调用这个报错的function前,先对这个集合进行遍历,想输出看看内容。

    于是我加了一段没有意义的代码:

    For Each x In SEQ_coll
        Debug.Print
    Next x

    结果运行直接完成了!!我喜出望外!

    当然我并不清楚为什么先遍历下可以防止发生automation的这个报错。

    但是作为小白,这个也是解决的一个办法,于是我马上去愉快的玩耍了。

    如有大神可以知道其根本原因也不吝赐教!

     

    展开全文
  • 我对EXcel VBA有一些... 当我尝试单击应用程序上的按钮时,我收到“运行时错误-2147467256(80004005)自动化错误未指定错误”。以下是我的代码。 在最后一行,当我尝试调用该功能时,我收到错误。我使用的是Window...
  • VBA 自动化错误错误440)

    千次阅读 2018-11-13 13:33:23
    VBA调用示波器采集时,读取波形数据头,读取数据: instrument.WriteString ":WAVEFORM:PREamble?" ' Query for the preamble. Preamble = instrument.ReadList ' Read preamble information and ...
  • I am getting the an automation error while invoking the following objectSet IE = CreateObject("InternetExplorer.Application")The error is showingRun-time error '-2147467259 (80004005)'Automation error...
  • Unfortunately, there's a problem - it can't even make it through the "A" list before I get "Automation Error Unspecified Error" and it's never at the same spot. I've tried the "normal" steps to fix ...
  • 如何解决VBA出现Automation Error 错误

    万次阅读 2013-03-20 01:43:21
    How to solve the message "Microsoft Visual Basic: "Automation error: Unspecified error (440)" with MS Office Excel? It can happen that an export of data to Microsoft Office Excel shows the ...
  • 最近初次尝试在VBA中使用ADO对象进行参数查询,一直出现Automation error,网上总是找不到对应的解决办法,经过反复尝试,终于搞清楚了。 假设cmd是ADODB.command 对象,其设置过程省略,要点集中在CommandText...
  • Sub wjhb() Dim str As String Dim wb As Workbook str = Dir("d:\data\*.xls*") For i = 1 To 20 Set wb = Workbooks.Open("d:\data\" & str) wb.Sheets(1).Copy after:=ThisWorkbook.Sheets(ThisWorkbook.Sheets....
  • VBA运行后提示自动化错误,对象库未注册。![图片说明](https://img-ask.csdn.net/upload/201801/20/1516448533_265867.png) 在别的电脑上运行是成功的,装的office是一样的版本,搞不懂为什么自己的电脑上不行。麻烦...
  • 注意:如果在使用 Visual Basic 中的自动化功能或使用 VBA (Visual Basic for Applications) 时出现错误,则该错误并不总是包括错误消息文本。 回到顶端 更多信息 请参阅 Winerror.h ...
  • I am trying to connect to mysql using Excel VBA, I am using Excel 2013. I am new to VB, so i followed this example: Inserting Data Into MySQL From Excel Using VBAHere is my connection code:Private Sub...
  • Rose2003运行出现 -2147417848 (80010108)':Automation 错误

    千次阅读 热门讨论 2014-10-14 12:24:14
    上篇博客在结尾的时候,我提到了Ration Rose2003运行出现“-2147417848 (80010108)':Automation错误”的问题。今天这篇博客就来介绍一下如何将这个问题规避掉。  其实我们使用的Ration Rose破解版的。何为破解版...
  • 用Excel的ADO来访问SQL Server 2000,程序在本地的时候,没有任何问题。但是在一个局域网内,做如下的Insert循环的时候,在n=66时客户端始终出现下面问题,而且修改原是需要插入的数据,总是在n=66时出现。...
  • Option ExplicitPrivate mclsMidTier As clsMidTierDim rs As RecordsetDim strCmd As StringPublic LoginSucceeded As BooleanPrivate Sub cboUserName_LostFocus() 全局用户名 UserName = ...
  • vba错误编号所对应的错误信息(备查) 可捕获的错误 可捕获的错误通常发生在应用程序运行时,但也有一些会发生在开发期间或编译时间。可使用 On Error 语句与 Err 对象来探测并回应可捕获的错误。1 – 1000 之间...
  • 经过整整两年多的实践加理论学习,总算实现了一套Excel报表自动化方案。思路总结如下: 1. 使用批处理文件调用批处理文件(call batch file through batch file) 2. 在batch文件中调用sqlplus程序,同时指定要...
  • 本机运行正常的程序,在其他机器上常常会有这个提示错误,让人伤透了脑筋。检查引用文件都没有问题,让人无从下手。今天再一次调试程序,感觉是类型不认识到原因。是否是代码有问题,而不是引用或者系统的缘故?旧...
  • EXCEL编程VBA高级教程

    2015-04-16 11:40:55
    1.2EXCEL环境中基于应用程序自动化的优点................................................................................1 1.3录制简单的宏....................................................................
  • C++ 自动化操作Word

    千次阅读 2013-05-02 10:42:45
    1.添加自动化帮助类 AutoWrap. 2.初始化COM库,调用CoInitializeEx, 或 CoInitialize确保并发模型只有一个实例。 3.使用CLSIDFromProgID API获得Word COM的CLSID  4.使用CoCreateInstan获得IDispatch 接口 ...
  • Excel_VBA教程

    2014-09-22 11:36:34
    1.2 EXCEL环境中基于应用程序自动化的优点 1 1.3 录制简单的宏 2 1.4 执行宏 2 1.5 查看录制的代码 2 1.6 编辑录制的代码 3 1.7 录制宏的局限性 4 1.8 小结 4 第二课 处理录制的宏 4 2.1 为宏指定快捷键 4 2.2 决定...
  • Excel VBA 基础教程

    2019-01-01 18:51:06
    .................................................................................................................1 1.1 VBA是什么...........................................................................
  • 用程序来控制一个网页,实现自动输入等操作

    万次阅读 多人点赞 2014-05-07 10:55:33
    因为使用.net来第一次操作页面的时候是肯定不会出错的,必须是2次或2次以上才会出现错误,所以我们可以做两个程序,在一个程序中调用另一个,调用完之后,就把它关闭掉,这样每次都相当于启动一个新程序,就不会出...
  • ExcelVBA程序设计.doc

    2011-04-05 21:32:51
    1.2 EXCEL环境中基于应用程序自动化的优点 1 1.3 录制简单的宏 2 1.4 执行宏 2 1.5 查看录制的代码 2 1.6 编辑录制的代码 3 1.7 录制宏的局限性 4 1.8 小结 4 第二课 处理录制的宏 4 2.1 为宏指定快捷键 4 2.2 决定...
  • 前几天用着都没有问题的程序,结果今天运行的时候提示:Automation 操作中文件名或类名未找到: RegExp 估计是安装杀毒软件的时候不知怎么给弄错了解决方法:regsvr32 vbscript.dll 
  • vba 压缩文件 使用方便 (Ease of use) There are many uses for zip folders. Previously, saving disk space was the primary purpose, but today that often isn't very important; more the option for ...
  • 为什么VBA CurrentProject.Connection语句会导致我的所有访问数据库崩溃?(Why do VBA CurrentProject.Connection statements cause all my access databases to crash?)我正在使用遗留数据库.mdb数据库,它在Access...

空空如也

空空如也

1 2 3 4 5 ... 18
收藏数 348
精华内容 139
关键字:

vba自动化automation错误