Search results for query: *

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)

Skip, I think I see the incrementing, what you mean by that. To clarify, once this is ran through and the responses are recorded, the excel sheet will moved in to an Access table and then of course this sheet (recording the responses) will be over written the next time. It will actually start...

I am guessing: so that it is part of the loop.. 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...

Skip, I do not know where to add the code in but I believe i see what you are leading to. xlSheet.Cells(1,1).value = Sess0.Screen.GetString(19,6,6) I am not sure where this would put the response back (from the host)on the Excel sheet. I need it go in Column C so my data in Columns A and B...

I am using a macro to send a command to an Attachmate session. I have an Excel worksheet that is called by the Macro in Attachmate. It puts the data from column B in to the Attachmate session and sends it.as you can see it loops until an empty cell. No Problem, works Great.....but the host...

Surely someone knows how to accomplish this?