Search results for query: *

This is exasperating. I have used regwrite to enable MSCOMM32 on other machines including Vista and Windows 7. A new laptop showed up and regwrite doesn't change the compatibility flag value. Using Shell and calling a .cmd file that calls a .reg file doesn't work either. Running either the...

The Auto_Open() sub runs fine and adds a menu to the Excel Commandbar. Selecting commands brings up different Userforms. The small userforms come up OK. Selecting the command that brings up the large userform (12 page multiform and 450 controls) crashes Excel. If I start the VBE first, there...

Using "...weboptions.targetbrowser" seems to return the setting that Excel uses when saving-as-a-webpage. I need to determine the actual version of IE that is installed on the machine. Later versions of IE will block ActiveX controls. I can unblock the control (MSCOMM32.OCX) from within VBA...

I can change the Excel Application icon. I would like to further customize by changing the standard XL icon that appears at the left end of my custom menubar. If it changes the icon on all menubars then that's OK too. 1. Can the menubar icon be changed? 2. If so - how do I do dat?

Sometimes when I save the project, it is 6 megs. Other times it drops down to as small as 3.3 megs. (I only make incremental changes to the code - no massive additions and rarely any deletions of code.) Does anyone know why this is and is there a way to control the file size of the VBA...

I have tried this in Excel 2000 and 2003 I have a custom menu bar. Everything works fine. I wanted to add tool tips to some of the commands. When I add tooltiptext to a menu item(msocontrolpopup), it displays during mouse hover... When I add tooltip text to a msocontrolbutton or popup under a...

I block certain procedures from running unless a worksheet is sorted in a particular fashion (ex. "Data", "Name", "DOB" etc.). I currently set a variable to hold the sortedby criteria. Is it possible to add a custom property to worksheets? I think something like: If mySht.SortedBy = "Data"...

In Excel... I collect data through a serial port and paste it to a worksheet. I also send the data to a printer so there is a hard copy (department of redundancy department). This works if the printer is connected to a parallel port. Does anyone know how to send a string to a USB printer...

Used to be simple. Maybe it still is. In Excel... Just want to check and uncheck a command when it is selected. Similar to the behavior of the "View" "Formula Bar" button. GVF

Excel...When using autofill, if two cells contains "1st" and "2nd" and you use autofill, the autofilled cells will display 3rd, 4th...120th...133rd etc. Is there a way to format a number in VBA so the result is the correct "th" or whatever? I am using a select case to do it, but it seems...

In Excel...I show a non-modal userform. When it appears on screen I don't want it active. I don't want the user to have to click on a cell to make the worksheet active again. Is there a way to accomplish this in VBA? (The userform just shows data from cells that are out of view on the...

Someone helped me out with this a while ago. I had a senior moment and lost the code. I want to send a single line to the printer and have it wait patiently for the next line. When it gets to the bottom of the page it should eject the page and be ready for more data. Something like: print...

I am collecting data (over the course of a month) through the serial port and pasting it into Excel. The computer collecting the data is unattended. I need to send each line of data to the printer as well so I have hard copy in case something bad happens to the computer. The printer would...

Hi all, I am communicating with a piece of equipment through the serial port using MSCOMM32.ocx There is an occasional problem (possibly machine dependant) that results in portions of the upload getting scrambled. Using PortMon I see that my VBA code is sending the data correctly and I...

I want to determine the boot drive so I can change drives and get to the "...Documents and Settings\All Users\Application Data\Microsoft" folder on any machine. Is there a keyword in VBA (like %BootDrive%) that will point me to the correct drive letter? Or is there another way to accomplish...

I have a custom menu bar with a "Windows" menu. Most of the commands are custom but I would like to emulate the File List of open workbooks that the standard "Windows" menu uses. Is there a way to Get the "file list" of open workbooks from the standard Windows menu and paste it to my custom...

I have several Excel add-ins that use MSCOMM32.OCX to communicate with serial ports. I generally use an OnTime event to send a command to the device requesting its current reading and the data is sent along and pasted into Excel. As more laptops are delivered without serial ports, device...

I would like to set the size of my opening dialog box to full screen (at whatever resolution the display is set at). I believe I must do this programmatically at run time. How do I get the setting (ex. 1280 x 1024) from Windows? Greg

I have an add-in project open and values have been assigned to variables. Is it possible to open another add-in project and have it request and receive the values of specific variables from the first project? The values of the variables will not be changed by project2. Thanks

Can someone explain the difference between "ActiveWorkBook.EnableAutoRecover" and "Application.AutoRecover.Enabled"? I have added a Userform that emulates the Excel Tools/Options/Save tab and I check and uncheck the menu command based on the return from the userform. Everything works fine, I...