Search results for query: *

I solved this: Dim appExcel As Excel.Application Set appExcel = GetObject(, "Excel.Application") appExcel.Visible = True With appExcel.ActiveWorkbook .Sheets(1).Cells(m, n).Value = TestString1 End With appExcel.Visible = True

Hi Thanks for the help. I have a problem here now, the (excel) window does not show up. The applications is running but cant locate the window. And I cant use: appExcel.display Is there some way to bring the application visible? Also, if I don't want a new Excel app to be open each time I...

Hi I need to move my stored string value in Outlook, to a cell (any cell) in Excel. But I have trouble to insert the value to the excel. I don't want to do the cheesy way of copying the word to clipboard and paste the text to excel. Lets start with this easy code (how should I proceed?): Sub...

I think that it has to do with API also, (you can see it in my full code in the API forum.) http://www.tek-tips.com/viewthread.cfm?qid=1594727&page=1

Hi I think this is an appropriate section to start this thread (VBA) that has to do with API: I will put an application window that we all share called: "Map Network Drive" (see the pic). Found in My Computer, Tools, Map Network Drive... http://i49.tinypic.com/63srqe.jpg 1. From this window, I...

I think I caused some kind of confusion. So I thought creating a new topic would simplify...

Simple VBA version (works, but I want to avoid sendkeys): Sub GetStringValue() Dim Sig As String Dim OutlookMessage As Object AppActivate ("Map Network Drive") SendKeys ("^C"), True 'Need to avoid sendkeys, like using WM_COPY Set OutlookMessage =...

Hi I need some help, and to ask my question in the easiest way I will put an application window that we all share called: "Map Network Drive" (see the pic). http://i49.tinypic.com/63srqe.jpg In that window, there is an textbox area (right to folder), where you can write, copy, etc. What I...

No. Sorry that the text "Wish copy this selection" was misleading/wrong). I was using the picture in another forum. That was just an example of an area in a app/window where I would like the string value in >Outlook< to be inserted. Say from Outlook Macro: Dim MyData As New DataObject Set...

Example of already open window I would like to insert my text/string value: http://i49.tinypic.com/63srqe.jpg

Hi Thanks for the feedback. And the code really works =) Open "C:\test.txt" For Append As a starts a new txt file. But I have a question for if I want to apply text to an already open application. Like brining the focus to the application and add (append?) the text.

I think we went offtrack. Let me simplify the code: Public Sub Sample() Dim MyText As String Dim MyData As New DataObject Set MyData = New DataObject MyText = "<Replace this with your text>" MyData.SetText MyText MyData.PutInClipboard AppActivate...

I did, couldn't find the solution.

Yes, something like that. It's just an example.

See the comment areas. Public Sub CNCText() Dim Application As New Outlook.Application Dim mail As Outlook.MailItem Dim mailBody As String Dim SpacRat As String Dim EngFed As String Dim TackVia As String Dim MyText As String ActivateWin For i...

Hi I would like to from Outlook control and do the following: 1. Insert text and/or string to an existing email 2. Insert text and/or string to another application I want to avoid using "SendKeys" command. Br Groom

Hi I need some help with a macro that does following: 1: In Attachmate (MyExtra) Select words on specific fields and store them as (example) X1, next word on another specific field X2, etc. 2. Open up an existing word file on the drive and the stored information will be inserted in the (word)...

Hi I would like to have a macro that allows me to save the screen (MyExtra) I'm looking at to a file (preferably as PDF). The macro should generate a unique file name based on user ID and date on the screen. Example: Groom090314VR231MM523L When it comes to saving location of the file...

Hi Can anyone help me with this following issue? I don't really know how I should write the hole thing (receiving errors). Here is the link http://www.vbforums.com/showthread.php?t=559252 Thanks in advance PS: VBA 6.3 and Outlook 2003 BR /Groom