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

    How Do you identify Activecell for Conditional Formatting?

    Thanks, Combo. However, I found an Add-in that better helps me identify the activecell to show me what row and column I'm on. Rowliner from cpearson.com . My end result was to highlight the x and y title cells so I know I'm on the correct cell to enter/change the data. The other item is...
  2. scottmh

    How Do you identify Activecell for Conditional Formatting?

    I have a 2 dimensional array and I would like to have the column and row header cells change color when the intersecting cell is selected. I've been trying to build it as a Function that I put in the "Formula is" selecion of the conditional formatting, but, I can't seem to get it right. Here...
  3. scottmh

    Script to launch programs on startup

    I'm sure there is a way...I just don't know how to do it. Can you create a .vbs that will run on startup in WIN 2k/XP that will launch 3 different Extra Sessions and Lotus Notes? Thanks, Scott
  4. scottmh

    Export Outlook calendar to HTML page in VBscript?

    Hi, folks! I'm trying to export the calendar/tasks info from my outlook to an HTML page that I would use on my desktop as an active desktop item. Is it possible to do this with vbscript and does anyone know where there is a good source to look at it and build from? Thanks in advance, Scott
  5. scottmh

    Open IE from Excel and login to web site ???

    Hey folks, I'm trying to code a macro for a friend that will open IE, navigate to a URL, then log him in to his account. I was able to find some code that open's the URL and puts the user info into the webpage fields, but I can't get it to click the "Login" button. Does any have...
  6. scottmh

    Extra - pen Excel and call Macro in Personal.xls ?

    cal, I found by using SacToCal's sample code from this thread thread1-428362 was able to do it. All I did was make this code a Header File, and changed ' Open a Workbook Set objWorkBook = objExcel.Workbooks.Open("yourfile.xls") to ' Open a Workbook...
  7. scottmh

    Extra - pen Excel and call Macro in Personal.xls ?

    That would probably work, but, I don't want the macro to run everytime I open that file. I wish to have it run only when a certain sequence of events happen, or have one macro (extra) run then give Excel the foreground and have extra tell it to run a macro in the personal.xls file. Thanks, Scott
  8. scottmh

    Extra - pen Excel and call Macro in Personal.xls ?

    I've got a macro in Extra that when run will open two CSV files in Excel. I've then created an Excel macro to format the files to my liking, but, I woulld like to Extra call that macro for me. Is there a way to do this? Scott
  9. scottmh

    Can Extra! 6.4 manipulate Excel File formatting ???

    Hey folks! First, let me say that this group has been a god send! I have been able to acheive a lot of automation in my tasks since finding this board. You guys have been great in answering my questions, direct and indirect. THANK YOU! Now...I have a macro that pulls my reports when I logon...
  10. scottmh

    EBMNGR Crashing

    Quote "...I was hoping to find a 'RunMacro' method of the Session collection.." End Quote I foundthe only way to have a macro call/run another macro was to take the called/run macro and make it an *.ebh (Header) file. You'll need to change that macro's Sub Main/End to a Function, but...
  11. scottmh

    EBMNGR Crashing

    falkor13, I've had ebmngr.exe crash on me also. Error Reading memory addresses. I usually have to open taskmgr.exe and find the Extra.exe or ebmngr.exe process that ends up staying open and end it. Haven't seen much about this issue anywhere but here, but, I think it could be an issue with...
  12. scottmh

    create a msg box that will open an executable

    falkkor13, Thanks. This worked very well. Do you know if there someplace (web, book {w/ real exmaples) that explains this kind of VB intereaction between applications that I could use as a good reference? Also, where can you get material that explains things like the shell32.dll calls? My end...
  13. scottmh

    create a msg box that will open an executable

    Hey Calculus, do you know how to get Extra! open a specific file once it has Shell's the program. e.g. Shell ("Excel.exe",1) then have it open a specific file. Also, Is there any better reference for this language you know of? The Help files are not very good and the code examples...
  14. scottmh

    Dialog Box examples...HELP!

    Thank Calculus. I'm sure this will help me a lot. I was so stuck trying to figure it out.
  15. scottmh

    Dialog Box examples...HELP!

    Can anyone provide example code that I use to learn the proper use of Dialog Boxes in conjunction OptionGroup/OptionButtons? I've been trying to wrap my head around the Macro Help of Attachmate, but, can't figure out how to use the user select option with select...case Any help is greatly...

Part and Inventory Search

Back
Top