Ole Error 800a9c68
All rights reserved. I'll play with that and report back. This is not an error per se; simply a notification that Excel is still waiting on results and you can safely click ok each time the message comes up until the If this is the case you would see quite a bit of time pass before the warning appears.A second possibility is if the Managed Debugger Assistant has launched.
Tuesday, July 27, 2010 6:58 PM Reply | Quote Microsoft is conducting an online survey to understand your opinion of the Technet Web site. You may have to register before you can post: click the register link above to proceed. Saves having to create an install package for a plain ole VB app. The time now is 07:27 AM.
My reason for doing this is to make deployment of this "application" simple - just drop the spreadsheet onto the target system (which of course must have Excel 2003 installed, which You might also check out the following. Reply With Quote 01-14-2013,09:13 AM #8 snb View Profile View Forum Posts View Blog Entries View Articles VBAX Guru Joined Apr 2012 Posts 3,779 or: With GetObject("D:\personal\expirydatetracker.xlsm") .application.Run "send_range", -1 .Close
current community chat Stack Overflow Meta Stack Overflow your communities Sign up or log in to customize your list. Do I need to do this? What it means is that Excel has timed out while either trying to open a file created in another program or waiting for results to be returned. You left this in, which jams the script. // 'ActiveWorkbook.Close False If Not IWasCalled Then ActiveWorkbook.Close False End If End Sub Formatting tags added by mark007 Hope that helps, Mark Reply
The first is ifyour messaging provider(such as Outlook) is having trouble communicating withthe server. Also for the error handling, I was missing the Exit Sub command to stop it from executing when there is no error. I still have the issue either way. The syntax appears to all be valid and functional, and I've tried this combobulation 30 different ways, now.... :huh: The only way I can get around this is to add a
JiguJigu View Member Profile Jun 15 2005, 03:49 AM Post #10 Member Group: Members Posts: 12 Joined: 15-June 05 Member No.: 2125 QUOTE (lancelotshui @ Mar 2 2005, 03:44 AM)when I Create new VAT Classifications in Tally Here's a sample Excel sheet format to add / create new VAT Classifications in Tally ERP 9, Tally 9, Tally 8.1, Tally 7.2, Tally 6.3 All rights reserved. Share Share this post on Digg Del.icio.us Technorati Twitter Microsoft MVP - Excel Reply With Quote Aug 1st, 2014,04:12 PM #9 shekkikim New Member Join Date Jul 2014 Posts 19 Re:
Getting the message "Microsoft Office is waiting for another application to complete and OLE operation". I know I can have an Autostart Macro (or something of that ilk) that could launch the form, but I am hoping there is a way to do this so that Share Share this post on Digg Del.icio.us Technorati Twitter Microsoft MVP - Excel Reply With Quote Aug 1st, 2014,03:35 PM #7 shekkikim New Member Join Date Jul 2014 Posts 19 Re: End Errhandler: Sheet1.Cells.Clear Resume Label1 'Lable1 is placed before the place the workbook is saved End Sub The error handling that I was trying to do, was something along these lines:
Would it help if I posted the code? Here are the recent updates: Windows Live Essentials Windows Malicious Software Removal Tool x64 - July 2010 (KB890830) Update for Windows 7 for x64-based Systems (KB976422) Security Update for Windows 7 Reply With Quote 07-31-2013,07:33 AM #10 shrivallabha View Profile View Forum Posts View Blog Entries View Articles VBAX Expert Joined Jan 2010 Location Mumbai Posts 737 Location I see that you You could use some API to set it OnTop or make a TaskBar or System Tray Icon for the form.
Here's my excel code which is running fine. Just to clarify, the code seems to have worked as :--------------Dim wbXL As Excel.ApplicationSet wbXL = CreateObject("Excel.Application")wbXL.Workbooks.Open "C:\test.xls"Although nothing visible happens on the screen, an excel process is kicked off [visible The part that's throwing me is that while calling 'tester' obviously works as intended, once everything is done, properly, the VBS throws a runtime error on the Run Method, '800A9C68', Unknown or (xml)..
If this is an isolated occurring, you can probably just click ok and ignore it; however, if it's showing up in software that you're developing due to waiting on user input, Related 3Excel Vba runtime error?2Variable from VBA to VBScript-1Visual Basic runtime error 10042VBA Application.Caller runtime error1VBA - Runtime Error 4380VBA runtime error 90How to Display a filtered value in a text Sub send_range() Application.Calculate Application.DisplayAlerts = False Dim ws1 As Worksheet Set ws1 = Worksheets("Tracker") With ws1 .ListObjects(1).Unlist .Range("A:ZZ").EntireColumn.Hidden = False ' show all hidden column .AutoFilterMode = False .Range("A10:J10").AutoFilter .Range("A10:J10").AutoFilter Field:=8,
Community Quality Center / ALM Practitioners Forum CommunityCategoryBoardUsers turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting
LinkBack LinkBack URL About LinkBacks Bookmark & Share Digg this Thread!Add Thread to del.icio.usBookmark in TechnoratiTweet this thread Thread Tools Show Printable Version Display Linear Mode Switch to Hybrid Mode I need this to run in the background without any intervention. I'm not sure the difference between today and yesterday. If you keep xlApp invisible your form will show but if user selects another window you have no taskbar display ie: you have to minimise all windows to see that your
Thanks! Probably should get some more coffee at this point... The script is working like I want it to (macro runs), but I get that error and my excel.exe does not close. Reply With Quote 01-11-2013,11:44 PM #3 aloy78 View Profile View Forum Posts View Blog Entries View Articles VBAX Regular Joined Aug 2011 Posts 54 Location Hi Mark, Thanks for the help.
If Not IWasCalled Then ActiveWorkbook.Close False End If End Sub Formatting tags added by mark007 ...and for the script file, something like: Dim objExcel, WB Set objExcel = CreateObject("Excel.Application") objExcel.Visible = Solution:- In Excel 2007, the default setting for Recalculation of formulas is AUTOMATIC. The time now is 04:27 AM. It runs twice a day.
As I'm not familiar with running vbs script from task scheduler, i'm kinda stuck with no clue. You receive a "Waiting for another application to complete an OLE action" error message when you edit a linked PowerPoint 2000 presentation http://support.microsoft.com/kb/226773 Will Buffington Microsoft Excel Support Marked as I hope it helps, - George NateO11-23-2005, 11:24 AMGreetings, Well, I can give you an example, and once you see it, you'll probably come to the same conclusion I have; it's If this dialog ia happening repeatedly, try sending a Word document through email from the Word application and see if it succeeds.
DG_1 View Member Profile Oct 28 2005, 04:35 PM Post #14 Newbie Group: Members Posts: 4 Joined: 22-April 05 Member No.: 1956 I have the same problem for FR318 + Delphi7 Script: C\top 5 macro.vbs Line: 5 Char: 1 Error: Unknown runtime error Code: 800A9C68 Source: Microsoft VBScript runtime error Code: Dim xlApp Dim xlBook Set xlApp = CreateObject("Excel.Application") Set xlBook = People can come up with really nasty Open Event functionality, as mentioned here: http://www.mrexcel.com/board2/viewtopic.php?t=132693&start=10 Thatís some bad behavior, right there... :huh: NateO11-23-2005, 01:02 PMErm, I might have missed the most obvious Any help?
So you need to add quote (') in the left of string (become '=Test This is Right). Run-time error '440': Automation Error Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Aug 1st, 2014,04:08 PM #8 shg MrExcel MVP Join Date May 2008 Location The The following code is used to set the calculation to Manual :- 'Stop Recalculation Dim xlCalc As XlCalculation xlCalc = Application.Calculation Application.Calculation = xlCalculationManual On Error GoTo CalcBack The following code Even though the Debit and Credit figures shown in the e...
Copyright © 2003–2009 PunBB.