Threads Replies Last Post 2 Pages: 1  2   Ending Excel Automation Object in Access 2003 Howdy, I have gotten some good advise from Ken Snell, but I need a bit more. Using Office 2003, I am using Access to put data into a series of Excel files. The problem is that Excel is left running in memory when done. I've gone through my code and tried to ensure all late binding was used, all Excel ranges referenced through automation objects, etc.. Still, Excel remains loaded in Task... 2 24.09.2006 21:38:02 Re:interopoledde >... 1 20.09.2006 14:02:56 Re:interopoledde >... 1 20.09.2006 14:02:43 Opening Excel spreadsheet from Access does not refresh data Hi, I have a spreadsheet with a sheet that's linked to a query in my database with automatic refresh on open. I also have a switchboard in the database item that starts the following code to open the spreadsheet: Function OpenExcelFile(strPathToFile As String) Dim objXL As Object On Error Resume Next 'Set objXL = GetObject(, "Excel.Application") Set objX... 2 19.09.2006 20:59:32 Lookp Acrobat install location in code and assign to a variable In the code below I have hard coded the path to where Acrobat is installed. What I really need is to look up the install path via code and write it to a variable so that the code can be computer independent. For instance, this is where the patch is stored in the registry. HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\Acrobat.exe Here is the code I'm using now that I need to... 2 19.09.2006 20:50:06 Re:interopoledde >... 1 31.08.2006 19:54:26 Re:interopoledde >... 1 31.08.2006 19:54:23 Re: Regards, teresa.greene@bigfoot.com... 1 21.08.2006 23:18:20 Re: Regards, laura.biding@ntlworld.com... 1 21.08.2006 23:18:17 Re: ... 1 18.08.2006 20:32:33 Re: ... 1 18.08.2006 09:28:22 Position Announcement, FT Permanent The University of Tennessee is searching for a person with solid VBA experience in Access or whose programming background will enable them to come up to speed quickly. This is a pemanent, full-time position with generous benefits. The link appears below. I am retiring from this position in February, and I will not answer questions about the job. Those should be directed to the chair ... 1 15.08.2006 18:51:25 5 steps to setting up Accounting Software So, you just have start using a computerized accounting program. Once you set up your accounting system, you can then realize all the benefits of accounting software: increased efficiency, ability to track, analyze and improve your financial health, and the opportunity to add services such as payroll and credit card processing. Before you enter information into the software, you will need to ... 1 03.08.2006 22:02:08 Amigos.com Amigos.com http://amigos.com/go/g671669 ... 1 24.06.2006 19:38:32 Check if Excel file is open before transfer spreadsheet Hello, I have this bit of code. The transfer spreadsheet command does not appear to be returning all of the data properly if the excel file is open when the command is executed. Does anyone know how I can check if the selected file is open so I can run that check before i execute the transfer spreadsheet command? **** CODE SAMPLE Private Sub cmd_Import_MTT_Click() 10 On Error GoTo cm... 2 02.06.2006 05:50:15 ANN: C# Online.NET FOR IMMEDIATE RELEASE First Wiki-based Online C# and .NET Reference at C# Online.NET Dallas, TX — A new concept in online references for Microsoft .NET programming languages is being pioneered by C# Online.NET–a new wiki-based, online C# and .NET reference. C# Online.NET offers documentation, tutorials, and C# source code examples for .NET languages beginning with the C# language. “Compa... 1 01.05.2006 17:16:05 Make Money From Google Google AdSense is a fast and easy way for website publishers of all sizes to display relevant, unobtrusive Google ads on their website's content pages and earn money AdSense for search results pages use Google's search to provide relevant results, and the search results pages are customizable to fit with your site's theme https://www.google.com/adsense/?ai=BRRgZ9XRNRM... 1 25.04.2006 06:24:10 for sale: internetDotComs.com domain for sale: internetdotcoms.com http://www.afternic.com/name.php?id=11866440 ... 1 16.04.2006 13:28:33 Syntax for Access report line method through interop I'm trying to create a COM callable library function in vb.net. This is going to be a common library called by a lot of Access database projects to add some custom drawn objects to a report. I pass in the report object to a vb.net function as an object of type Microsoft.Office.Interop.Access.Report. Within that object, the syntax for the line method is Public Overridable Sub Line(By... 1 09.04.2006 16:30:01 Start Earning Money 15 Minutes From Now Did you know? $29 can make you $1,000? And $1,000 can return you $3,081,484 in 3 years? (without you lifting a finger) Yes, we will show you how AND give you the method Yes, InvestPlace uses extremely powerful tools InvestPlace contains a powerful combination of two match winners... This is some valuable information. I'm using it and watching my money grow everyday. ... 1 09.04.2006 14:21:38 ERROR: You do not have exclusive access to the database at this ti I have an Access 2003 MDE application that is deployed to 232 client computers using Access Runtime. The Application is launched from a VB.NET application and is crontrolled through automation. One of the 232 computers is producing the following error when the Access Application is launched. "You do not have exclusive access to the database at this time. If you proceed to make changes, ... 2 31.03.2006 21:17:55 ¤ China ZhongZhan Aids Mei Mei Killer! http://onfinite.com/libraries/175399/440.jpg elmar@digi-art.de ... 1 21.03.2006 12:48:21 ¤ China ZhongZhan Aids Mei Mei Killer! http://onfinite.com/libraries/175399/440.jpg elmar@digi-art.de ... 1 21.03.2006 12:48:13 Ink Sorry guys. The spam stuff was not my intent. I do oppoligies and won't happen again. I have never been on newsgroups before and not sure how to work them. I hope you guys can forgive a bad choice. Murphey... 1 20.03.2006 12:07:30 Outlook express problem Hi, I am getting some emails through that appear blank when downloaded into Outlook express and I can only read the content of these after saving into My Documents. The last one I got was in MIME format, could this be the problem? How do I set up outlook to display these messages? Cheers, John Mac. ... 3 16.03.2006 01:44:10 2 Pages: 1  2