Search results for query: *

Is there a way to find out which option button on a worksheet is selected by looping through an option button array? I remember doing something like this in VB5. I'm trying to do the same in VBA in Excel now but can't make the button names an array. Right now I have to check each button...

I have a spreadsheet I originally created in Excel 2003 which used the MSCOMM control to read data sent to the serial port. When I upgraded to Excel 2007 this spreadsheet still worked fine. Lately our IT installed some updates on my computer and now this spreadsheet cannot use the MSCOMM...

I'm trying to open an Excel file via a macro. However, I want the user to be able to select the file rather than hardcoding the file as in the command: Workbooks.Open Filename:= "C:Sample.csv" Should be easy right? But I can't find it in the VBA help.

We have PCs in our offices that have Office installed. The PCS in the lab do not. I would like to use Microsoft Office Document Imaging Printer Driver to create images of reports from the laboratory PCs. However, the only way I can find to install the printer driver is to install the Microsoft...

I created a spreadsheet with a macro that uses the Chr() function on one PC and when I try to run it on a second PC I get the error Compile Error: Cant find project or library. If I create a new worksheet on the new PC and use the Chr() function everything is normal. The error only occurs...

I'm trying to execute a subroutine in a command button's _Click procedure from a separate module in Excel. I want to perform the command button click from code in case the user did not do it manually. I'm using the following code but I get an error...