Office Automation :: Outlook - Application Running Multiple Threads
Apr 15, 2009
I have an application, running multiple threads, and in many of these threads, Outlook is being called, some mails read, attachments downloaded, and then the outlook instance closed. But it is possible that there are a number of threads trying to do the same thing at the same time. There is of course a lock at the beginning and end of the process, so that no two threads try to access the outlook application at the same time.
"Sometimes" i get an error message : Creating an instance of the COM component with CLSID {0006F03A-0000-0000-C000-000000000046} from the IClassFactory failed due to the following error: 80010108
View 3 Replies
ADVERTISEMENT
Mar 28, 2011
i was wondering if someone could give me the final explanation on what i might be doing wrong here.I spent a lot of time reading around the net and the forum about how to add Threading capabilities to a VB project.
Nos, i've got .NET 4 installed, and i've added the system.tsr and mscorlib.dll files as reference in, say, Excel 2007 (see screenshot).However, when i try to make a thread with anything as basic as "Dim Thread1 As System.Threading.Thread", i get a user-defined type not found error.Indeed, when i use the object browser to see what's in the System file, theres nothing remotely linked to any Threading, and in the mscorlib file, nothing under "Threading" either, just a few Thread related functions, but nothing defining a data type
View 2 Replies
Jul 19, 2009
I have a macro written in VB in Excel, which reads emails from Outlook. I would like to automatize this process, but everytime, when Excel wants to access the outlook, I have to give permition to do that, see http://apophis.wz.cz/permition.PNG (It's in czech, but you will see the point). Is there any way to give this permition for ever? Or for long time, such as 10 hours? (I can choose max. 10 minutes).
View 1 Replies
Jan 11, 2011
I a using the following code to insert a calender appointment into the default calender in outlook 2007. My problem i am having is that my customer know has a mobileme calender in outlook as well so I need to be able to insert an oppointment in to this calender which is not the default one.
[code]...
View 1 Replies
Mar 2, 2010
I was wondering if anyone knew a way to have vb extract an attachment from an outlook email and save it to a specified directory. What I have is a program that when a file (outlook attachment) is dropped onto the main form it saves that file to a specific directory. I have the following code which seems to work for anything other than Outlook (possibly because outlook's drag and drop feature is defined differently?):
Code:
Private Sub Form1_DragDrop(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DragEventArgs) Handles MyBase.DragDrop
Try
[Code].....
View 1 Replies
Nov 21, 2011
I would like to "get" a text from outlook message, using VB.NET shared add-in.
First, I've made VBA script and it worked well. Here it is:
Code:
Sub Macro1()
Dim msg As Outlook.MailItem
Dim insp As Outlook.Inspector
[Code].....
View 7 Replies
Nov 11, 2010
I installed the API redist [URL] for Office 2010 (Office 2010 was already installed). Then I tried to use code from MSDN [URL] just to see how it worked. I included the code here, since it's short. At the top of the file:
Code:
Imports Outlook = Microsoft.Office.Interop.Outlook
... and in the class:
Code:
Private Sub SendSalesReport()
Dim mail As Outlook.MailItem = CType(Application.CreateItem( _
Outlook.OlItemType.olMailItem), Outlook.MailItem)
[code]....
Unfortunately, VS2010 balks at the very first line, not recognizing the namespace. What do I need to do?Oh, and I can't find Microsoft.Office.Interop.Outlook.dll anywhere, either. Shouldn't that have been installed?
View 3 Replies
Mar 19, 2009
I am using Office 2003 with VS2008. I am trying to add appointments to a brand new calendar in public folders. Adding the first appointment works fine. However each and every other appointment from that point, is deleted when I add another one. Here is the code, that I am using.
Code:
Dim objOutlook As Outlook.Application
objOutlook = New Outlook.Application()
Dim objNS As Outlook.NameSpace = objOutlook.Session
[Code].....
View 2 Replies
Feb 17, 2010
I have a VB NET application that reads through my Outlook 2007 Inbox and retrieves email addresses - the only problem I have is that mailitem.recipients returns the CC addresses but not BCC s,
View 1 Replies
Nov 16, 2009
I have a customer who wants to send emails to his customer and suppliers with confirmation of order, purchase orders etc. instead of printing them and mailing them (postal strikes in the UK, and threats of more).
I have the following code which works on a Vista machine:
Code:
'Created Outlook Application object
Dim OLApp As New Outlook.Application
'Creating outlook Namespace object
[Code].....
View 2 Replies
Jun 8, 2011
I am using Outlook 2003, VB 2008 and Win XP.I am storing user ID's in the User1 field of the Outlook Address Book. This is working find I want to Find all Address Book items with a value in User1 [code]This will find an Address Book item, even if the User1 field is not blank. When I debug, the first entry found has OlContactItem.User1 = Nothing.If I set User1 to a value (for example Id # is 1234, so I set User1 = "1234"), I can find just the one Address Book item with:[code]How can I find just the Address Book Items with User1 is blank?
View 1 Replies
Jul 30, 2009
i'm relatively new to outlook task creation from visual basic.when i create an outlook task, i want to insert a link with a custom string..url...instead of the left screen, i would like to come up with the right screen.by the way, i'm using visual studio 2005, microsoft outlook 2003 and outlook interop from outlook 2003.[code]
View 4 Replies
Aug 19, 2011
I try to develop a automation-add-in for Excel which can get some data from our SQL DB. So i call my add from an Excel-cell.. like "=getThisFromDb()"... This works totally fine! But what if i want to write to another cell then just give a return value? I managed to get the running instance of excel. I can read from it. I can open a new document in it and write to it. ->> But can't write to the Worksheet that called me!!
View 2 Replies
Aug 24, 2009
I have an issue which has successfully busted my head all weekend. I created a COMAdd-in, in VB.NET (VS 2008) for Excel 2003. We now need to work the solution out for 2007 and since the layout and objects are a little different we had to make some critical Interface changes.Instead of a floating CommandBar we are now going with RibbonBar, which looks good but it doesn't work. Whenever I open Excel Workbook (which is the primary application). The Add-in successfully recognizes it and opens it up properly (bunch of Macro calls, layout settings etc). Anyway, after it opens, if I click on any button (on the new ribbon tab) I get "Application not properly initialize. Program will now close" and excel object is lost.
View 1 Replies
Jan 6, 2010
I am currently writing an application in VB.NET that draws to a Microstation(MS) CAD application. Like Excel, MS has a robust COM object library that can be programed remotely. Hence, I am posting this in the VB Office Automation forum.In the case where the user invokes my program and there are multiple instances of Microstation(MS) open, I need to let the user determine which MS application instance they would like the program to draw to. It could be potentially catastrophic if the program draws to an unintended application/file.So my problem is this, I need to know how to convert an instance of the application that was found by enumerating through the GetProcessByName method in the Process Class, to an "Micros tationDGN. Application" object.I have read the responses to Post 1317219 by jprg. In a response to that Post, (Post 1317389) Mike_R replied;But if you want to actually manipulate the Excel instance via automation in order to create and save a new file, etc., then it's pretty close to impossible to convert an instance that you grab within via the Process class to an Excel.Application instance.
View 3 Replies
Sep 20, 2011
I have 2 sheets in a workbook that have links on them. I need to copy both sheets into this new workbook at the same time to update the links and not have sheets looking for the original workbook (it just temporary and deleted after the copy). I thought I had it, but I cannot figure out how to deal with the array that is needed (I copied the code from macro builder in excel)..
oExcel.Application.Windows("EP Labor Calculator.xlsm").Activate()
oExcel.Application.Sheets(Array("Rates", "Labor Calc")).Select()
oExcel.Application.Sheets(Array("Labor Calc", "Rates")).Copy(Before:=oExcel.Application.Workbooks("SAP Test.xlsx").Sheets(5))
View 1 Replies
Oct 2, 2010
In the past few weeks, to speed up our database freshening process, I've created a couple of extra programs, basically copies of the exe file. The program itself, accesses web pages, images etc and uses threads to do so. The second program uses LIMIT 300,100 and the third LIMIT 600,100, to make sure they don't work on the same records.
Before the last few weeks, one occurrence of the program used to run without problem, from the task scheduler all through the day. Only one occurrence of each exe can run at a time.Since theres now three programs running, .net 2.0, on xp, the program often seems to get stuck and never ends. I have to kill it from task manager.
It runs fine in the IDE I just wonder if there would be any benefit from upgrading to vb.net 2010 ?
View 1 Replies
Apr 17, 2010
How to I run multiple threads in VB.NET? Say I need 2 threads - one that prints 100 numbers in a loop and the second one that asks for the user's name and prints it inside a message box.
View 1 Replies
Jan 13, 2012
I have a sub-procedure which I want to run a different process, depending on what is currently running. I thought the easiest way to do this was by using an ArrayList of each of the campaign details & adding an 'Inuse' field to check to see if the Inuse field is set to 0 or 1. The problem that I have is that when running the process it is all happening at once & the integer hasn't been changed before the next thread kicks in so my threads are running the same campaigns. I tried to avoid the problem by adding a Thread.Sleep(100) delay inbetween starting threads but this led to exactly the same problem.
Here's an example of what I am trying to do:
Imports System.Threading
Public Class Form1
Private Campaigns As New ArrayList
Private ProcessRunning As Boolean = False
Friend StopProcess As Boolean = False
[Code] .....
View 2 Replies
May 6, 2009
I'm writing a scripter using VBScript, that should be able to execute multiple scripts at same time, running on own threads.
The issue is, I DO start those scripts on different threads, but their sleeps still seem to affect the other threads too.
For example, let's say I start 2 scripts
In the Main event
NewScript1
NewScript2
[code]....
View 1 Replies
Jan 4, 2012
I have an VB.NET 2010 application using framework 4 that has issues with reading and writing to cells using command similar to 'RequiredSoftwareVersion = EmployeesSheet.Cells(37, 4).value'. The big thing is I can open/close the workbook, select which worksheet in the workbook. On some computers it works fine, on others I get a pop-up that asks if you want details, continune, quit. All the computers have Office 2007 installed.
View 4 Replies
Mar 24, 2009
I would like to open a file in an application using vb.net 2008. I am unsure which namespace to use. I do not want to assume it is the current associated application. I believe there should be a way to...
Dim app as something
Open a file in that app
View 5 Replies
Jul 30, 2009
I know how to program this task easily using vb.net, only because i had to do a similar task a few seasons ago. However, when I confronted this task last week my previous solution did not work.Here is my code.Code:'using VS 2005 so i added the COM reference: Microsoft Excel 10.0 Object LibraryDim xlApp As Excel.ApplicationDim xlWorkBook As New Excel. the .Net Office Automation forum
View 8 Replies
Dec 9, 2009
I have two forms running in the same application but on different threads. HdForm and DataForm. I have a class library whit datasets and a stack in it. Cause both forms (different threads try to rad from the same class library i use a synclock to syncronize. But it seems like the synclock dont work.I get random errors in the HdForm while reading from myAr dataset. It says index out of range. But i know for sure that the index exist (i have make sure of that). When i click on the visual studio play button then, it goes again.If the index was realy out of range then it couldn't go further. So i think the synclock does not work and thus the dataset is changed in time while im the loop reading from MyAr.
[Code]...
View 3 Replies
Feb 14, 2009
It appears that when one creates an instance of Excel, using CreateObject, (Late binding), the suggested Excel closing function (with GC.collect etc) does not work. I have tried several suggestions, and the only one that works is process.kill method. Do you see any problem in using this? BTW: the reason we are using late binding is that we cannot use Office PIAs....not sure which version of Office would be installed on the client site. We work with O2003, but the client might still be at 2000 or 2002.
View 7 Replies
Apr 15, 2011
I'm calling the following method from a button click event to export a datatable to excel. After the export is completed, the excel application object is quit, released and assigned to nothing. But in reality it's not getting released and stays active unless the entire application is closed. So every time the button is clicked for export, a new excel application object keeps on running. The problem doesn't occur if two of the lines from the method below are not used. But I can't omit them as they are really needed. Check the * marked lines.
Code:
''' <summary>
''' Exports data from a datatable to excel.
''' </summary>
[code]....
View 1 Replies
Jul 13, 2010
I am using visual studio to create an application that opens an excel file and then for each entry in the first column the entry in the second column is stored in an array. Then excel opens two other workbooks and for each entry in the first column it searches for a match in these other two workbooks and stores the corresponding value in an array.
Anyway, the problem is closing excel afterwards. I have used the thread: [URL] to work through the basics of cleaning up. I used the cleanup code provided and added the WithEvents caveat. I do not have strict option on.
I believe the problem is the fact that I have three workbooks open.
This is my cleanup code: (wrkbk, wrkbk2, wrkbk3 are the workbooks; datasheet, datasheet2, datasheet 3 are the worksheets; excel is the application)
Code:
GC.Collect()
GC.WaitForPendingFinalizers()
GC.Collect()
[Code]....
I got the impression that order was important in the cleanup procedure so I have tried some variations of moving the workbooks and worksheets around.
View 1 Replies
Jan 25, 2011
I have written an automation addin in Excel with C# (addin.dll). To use the addin, I need to 1. register it using "regasm /codebase c:...addin.dll"2. select in ExcelOptionsAddInsExcel AddinsAutomation the respective addin from the list
I would like to automatize 1) and 2), so that the user just needs to run an exe-file in order to use the addin. 1) should be no problem, but how can one automatize 2)?
View 12 Replies
Apr 20, 2010
Ok basically what I need to do is the following:Read FirstExcelDoc (attached)For every row in that: Retrieve data from sql server db based on info in the Orange columns of FirstExcelDoc Let's say I retrieved data elements A, B, C, D, and E from sql server. Then I need to enter those same data elements A, B, and C in another excel spreadsheet (which has formulas etc) After inputing A, B, and C in that spreadsheet, read a couple of calculated fields and compare those results to data elements D and E retrieved originally from SQL Server DB. Finally, output the results in the Blue columns of the FirstExcelDoc spreadsheet for that row.Loop through and do the same thing for row 2 of the FirstExcelDoc and keep on until you see "END TEST" in the FirstExcelDoc.
I'm looking for a method of doing this efficiently. I have read several articles over the past few days as well as those from Mike R. but just need some direction to get started on this.To start of I'm looking for whether to read the entire FirstExcelDoc spreadsheet or just read the info for first policy number(2nd row) and process it and write out the blue column info for that row and then loop through and come back and read the second policy number (3rd row) etc... Please attach a code snippet for either way of reading the data.
View 19 Replies
Jun 17, 2009
I'm using excel via interop in application.Sometimes users kill application that created excel instance and that results in excel instance sitting in memory without any chance of disposing it.First I tried to tackle this using ROT(running object table) looks like not all instances of excel are registered there.Than I tried to somehow mark excel process after it is started via interop.[code]This works as long as excel is visible but in my case excel window is invisible.All I need is to somehow mark process that started via automation with the parent PID, so that later I can kill it if parent does not exist.
View 19 Replies