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...
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...
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
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
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...
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...
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
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
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.