sendkeys

Hello, In Excel 2007, I'm trying to get data from a website using VBA so that I can process it. I have to enter the website and enter in a part number to search on, then select the search result. Finally, I can highlight everything and copy to the clipboard. From there, I can work out the steps...

Hey all - I am trying to write a macro that will print a worksheet to PDF and automaically name the file. This is the code I have so far: Option Explicit Private Sub PrintToPDF_Click() Dim CurrentPrinter As String Dim fileName As String Let fileName = Cells(7...

I'm trying to use Excel for a Chinese vocabulary list. The Chinese characters aren't the problem at the moment: what I'm trying to solve is the pinyin, i.e. the pronunciation shown in Western alphabetic letters, with accents (diacritics) to show the four tones. For example, the word for...

Hello, So first some background: I am using Excel 2007 and I use Outlook 2000 for email. I am automating a report that we currently do manually in anticipation of increased reporting volume. I have some VBA experience but I would still consider myself pretty novice and I've never really done...

Hi all, I'm writing a macro that will run a report in excel, save the excel worksheet and then print it to pdf. Everything works fine except the enter sendkey won't work. Does anyone know a better way then using sendkeys? The macro will run for over 100 accounts so I'd prefer to not have to...

Below is the code I've put together. I seem to be getting hung up on the Sendkeys portion. What I'm trying to accomplish is... I have one excel sheet that generates my report: "Test Invoice Report". Using the data generated from the report I would like my macro to allow the user to enter a...

Hi I am trying to use a macro to automate the use of alt key. my code looks like this--> Private Sub CommandButton1_Click() For i = 0 To 10 Range("A" & i).Value = ActiveSheet.SendKeys("%" & i) Next i End Sub This code is to enter the value of ALT+1...ALT+10 to column A Plz help..

Hi there, I am using Excel macros to provide some data to other application (SAP R3 window) using SendKeys and AppActivate funcionality. I have two questions according to this : 1. How can I receive the names/titles of all currently opened windows/programs (bring them to the cells of excel...

Hi! I am using Sendkeys for Hyperion Planning Excel Add-In User Interface in order to automate retrieving data from the database. Sometimes the UI is too slow and I'd need a little pause between Sendkeys commands. The most helpful solution was provided by TsTom year 2003 in this Forum, see...