Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Handcopy

    Macro to run a macro later?

    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.
  2. Handcopy

    Saving in Excel (Not what you think)

    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"...
  3. Handcopy

    Saving in Excel (Not what you think)

    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?
  4. Handcopy

    Saving in Excel (Not what you think)

    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=...
  5. Handcopy

    Saving in Excel (Not what you think)

    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...
  6. Handcopy

    Getting a color from a picture that is copied on CLIPBOARD

    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.
  7. Handcopy

    Getting a color from a picture that is copied on CLIPBOARD

    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.
  8. Handcopy

    Methods and keys in E!B

    Thank you so much.
  9. Handcopy

    Methods and keys in E!B

    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.
  10. Handcopy

    Methods and keys in E!B

    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...
  11. Handcopy

    Copying rows in EXCEL

    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...

Part and Inventory Search

Back
Top