Recent content by vzdog

Trying to do it for different instances.. Issuse is I do not know how.

Ralph Take a look at the code I have posted in my post here: http://www.tek-tips.com/viewthread.cfm?qid=1640089&page=1 I am basically doing what you want to do - but note that toward the end I am moving the file in to an Access db. This should help get you started though. I am using outlook...

My code is working - as written in the original post. My code that basically looks for an email from a specific sender with a specific subject line. Once that email is received then my code saves the attachment to the designated folder and the kicks off some macros in Access. My...

No not yet. I have a code that will do everything I want it to do begining with saving an attachment from a particular sender with a particular subject line. However, I have yet to accomplish saving different attachments from different senders. Typically the attacment would be .xls file.

Actaully just had a chance to try this and it does not actually save the attachments. Perhaps something is missing. I tried usinga test set up of 2 different senders and both instances failed to save the attached file.

yooneek - Thanks for the reply. I have been trying to read more about using case versus a If then Else - and thought that may be the way to go. As I said in the post I do not use VBA but see where I need to learn. Is there a way to use case where I would be able to set a certain sender and...

Hello everyone. I have a VBA script cobbled together that will successfully capture an email attachment from a specific sender with a specific subject. My problem is that it will only capture 1 instance.I would like to be able to add additional Senders and Subjects to capture - and be able to...

Hello everyone. I have a VBA script cobbled together that will successfully capture an email attachment from a specific sender with a specific subject. My problem is that it will only capture 1 instance. I would like to be able to add additional Senders and Subjects to capture - and be able to...

Is there code that envoke "Capture Incoming Data" and "End capture as well? I have other posts here asking about capturing a scrolling screen but so far have not seen any responses...except for my own pleading.

Lets try row + 1: Dim Row As Long With xlApp.ActiveSheet Set MyRange = .Range("B2:B65536").Resize(xlApp.CountA(.Range("B2:B65536"))) End With For Row = 1 To MyRange.Rows.Count Sess0.Screen.PutString MyRange.Rows(Row).Value, 21, 3...

Skip, I believe we have a miss communication. I wish i could have sent you my Excel sheet. I have a heading on my column c. So, it has to start on Row2. But i am not sure how to get it there. I did not think that qualified as a Variable.

ok that didnt work like I thought... Here is a sample of it: A B C TID EnableCmd Status BLBGVABBK13 SET-PMMODE-T1::0038-04:P::,ALL,ON; COMPLD SET-PMMODE-T1::0039-03:P::,ALL,ON...

Skip, Here is my Excel sheet. Perhaps this will clarify some.

Ok Skip It works with this code,but..... Dim Row As Long With xlApp.ActiveSheet Set MyRange = .Range("B2:B65536").Resize(xlApp.CountA(.Range("B2:B65536"))) End With For Row = 1 To MyRange.Rows.Count Sess0.Screen.PutString MyRange.Rows(Row).Value...

This is wrong, isnt it? xlSheet.Cells(3,1).value = Sess0.Screen.GetString(19,6,6) should be for Column C row 1: [xlSheet.Cells(1,3).value = Sess0.Screen.GetString(19,6,6)