Search results for query: *

I'm trying to get a macro to run at a scheduled time, except I'm not really how how to go about doing this. Any help? Thanks.

Ok, the code was re-written specifically tp post here. Since the same error is still apparent, I don't think there's a difference. Sub Main Dim appExcel As Object Dim wbExcel As Object Dim aSheet As Object filePath="C:\documents and settings\assadk\desktop\Copy of tests2.xls"...

Sorry, I left out the line declaring aSheet. Here it is: Set aSheet = wbExcel.Sheets(Sheet1) But, the program did not act any different. Anything else?

Here you go Dim wbExcel As Object Dim aSheet As Object Dim queueID As String Dim filePath as String filePath="C:\documents and settings\assadk\desktop\Copy of tests2.xls" Set AppExcel = CreateObject("Excel.Application") Set wbExcel = AppExcel.WorkBooks.Open(filepath) queueID=...

We have a macro that writes to Excel from Attachmate and then saves it. At least, that's what it's supposed to do. It only works when Excel is closed. However, we want it to save while the Excel window is open. But, it does not work, it ends up saving to the My Documents (default file location...

The picture is a screenshot of a webpage. If the color in a certain area is red or yellow, then a specific letter is put in a specific column.

Hello, i was wondering if there is a way i can get a color or RGB from a picture that i have copied on my CLIPBOARD. It'd be cool.

Thank you so much.

Oh, and also i wanted to know if there was a way to make methods in E!B, and how to use them with parameters.

Hello, I was wondering if there was a way to wait for certain keys to be pressed while the macro is running. For example, while the macro is running, is it possible to wait for a key to be pressed, so i could exit macro, mid-run? Also, i would like to know if i can wait for two different keys at...

Hello, I am using EB to send an email that gets information from excel. For example, i need to send an email that contains every row that has been marked by initials in another column. I want to be able to take only those rows and email them. That would work, or if not i was wondering if i could...