Search results for query: *

Thanks, Combo. Let me experiment with this concept and I'll report back. For the record, I ALSO agree that it's not the best for code protection. I had reasons for being tied into this platform in the beginning (no good excel grid controls for .net at the time, etc.), and I am migrating, but...

Anyone else have an answer to the technology question. Skip, its been awhile but I usually was impressed by your vba prowess. Having a bad day?

I don't want to get into philosophies but suffice it to say that I have a vested interest in keeping my licensed code centralized.

Hi Skip. Thanks for the quick reply. I trying to detect mouseover events in OTHER workbooks without putting vba code in them (and therefore needing them to be .xlsm files). I was hoping to put activex image controls in them (without code) and then monitor the mouseovers from my main application...

Hey Folks. SETUP: I know how to: (a) use image mouseover events within a worksheet module; and (b) How to invoke/use an application-level eventhandler to track application-wide worksheet & workbook events.. QUESTION: Is there a way to create an application-level or workbook-level...

Here's another approach that might work, but I have not been able to get it going either: using a SINGLE combobox and modifying the list. Upon selecting from the dropdown, the _change event fires. In the change event, I modify the list and redo the .dropdown to no avail. If anyone can help...

PH: I did try the AfterUpdate and it did not work either. Skip: Does "WORKS!" mean that you got the second combobox to dropdown without clicking on the second label? That's my object. Thanks.

Skip, I guess you saw that I do indeed have 2 comboboxes but they are hidden. Just for context, I have a floating (non modal) dashboard for navigation, etc. and upon clicking on a label, dyamically display JUST the dropdown (again to look similar to a pop-up / dropdown menu in a webpage. I...

Gerry - I believe that is the issue. The Change event must finish before focus can shift. I tried firing off an asynch task with ONTIME (in a half-second or so), but that did not work either. Skip - I'm not sure what you mean. Can you be more specific of offer an example?

I have searched for an answer to this for years as well. Here's what I know. PDFWriter in Acrobat 5.0 DOES let you use the PrintToFile properties of the PrintOut method. Releases 6.0 and on require either: (a) user intervention (the saveas dialog); (b) use the Distiller COM object which requires...

Hey Skip. Nothing burst here. I DO want the user to make a selection from the 1st dropdown, and based on the selection, display a second dropdown. As you can see from my sample workbook, I'm using the _Change event on the combobox to trigger the 2nd dropdown, but can't get it to display. BTW -...

I see how my link came out due to spaces. Here it is: http://innovient.com/Downloads/cascading combo test 2.xls

Skip and Hugh, Thanks for the replies. Skip: That's exactly my problem. Once a dropdown is displayed, I cannot display another without some user intervention. I have tried setting the 1st combobox to visible = false, setting focus on the 2nd combobox, you name it. Attached is a simple set of...

Howdy folks. I have exhausted all my efforts on this one. First off, I know there are posts for "cascading comboboxes", but they are not this situation. I currently have a combobox that employs the .dropdown method upon clicking on the combobox (no big deal). Upon selection from the dropdown...

Hi lebforces. Yes, I got to the bottom of this. Turns out that you can only use the PrToFileName option with the PDFWriter up through Acrobat 5.0. In 6.0 and up, while you can still use the PDFWriter explicitly through a dialog, you must use the Distiller in VBA if you don't want user...

Hi Thomas. Thanks for the reply. ( I actually tried to call you after seeing info through a Google search.) You're right, that DOES result in a pdf, BUT it also requires user intervention for the "saveas". I need to progammtically supply the output file name and path (which I do with Acrobat...

Howdy Folks. I've got an EXCEL XP / VBA app which generates PDF's to specific output files automically (no user intervention with an Adobe dialog). It's quite simple, using the .printout method and the PDFWriter driver as follows: ActiveWindow.SelectedSheets.PrintOut PrintToFile:=True, _...

Hi Tony. It pretty simple. Just select multiple sheets first. Sheets(array("abc", "def", "ghi")).select Then change your .printout line slightly. ActiveWindow.SelectedSheets.PrintOut ... BY THE WAY: I think it's MUCH easier to just change the activeprinter to the PDFWriter. It's just a...

Thanks, BrainB. I'll give it a try with a slight variation. Since: (a) I'd like to avoid having to clean-up the temporary workbook when done with it; and (b) I don't know the name o the temporary workbook (i.e. book2, book3,...) I'm gonna capture the Workbooks.Count BEFORE the .COPY and then...

Hello all! I use the code below to "export" selected sheets from a workbook as excel, csv, txt, etc. (on the saveas fileformat differs). Just recently, I've begun to have issues with the activewindow focus. I believe it's speed-related within a Novell server environment. The problem is...