Programming

autopopulate fields in userform based on selection in one field
Hi All, I have an excel userform that has a dropdown field called "Leader". What I want is: Once we select a value from leader dropdown. I want three other fields to auto populate based on what we select in "Leader" dropdown. For eg: I want Student1, Student2 and Location to be auto populated once we selec... 14 Sep 2009 11:56

On some PC's prints to default windows printer rather then Acrobat PDF defined in code
I'm using the Ken McDaniels version (see link below) of automatically printing an Excel spreadsheet to Acrobat PDF. http://www.planetpdf.com/mainpage.asp?webpageid=762 It works perfectly. However, on one PC it always prints to the DEFAULT windows printer rather the Acrobat Pro. If I change the default windows ... 23 Sep 2009 22:21

File creation wait timer
I'm getting a File Doesn't Exist error when I try to Call this function from within my Email function. Sometimes I'm sure it is a timing issue where the email is trying to attach this file before it is finished being created. Would some one be kind enough to supply me with some timer code that tests and waits ... 13 Sep 2009 21:40

Content Size for WebBrowser ActiveX Control
I hope this question is appropriate for this group. . . . I am using several WebBrowser (ActiveX) controls on a VBA UserForm in Excel. I am displaying images from the Internet in them using URLs. To fit them all on the user form, I had to make them smaller. This results in the WebBrowser keeping the original imag... 9 Sep 2009 09:42

1004: Activate method of Range class failed
I get an error when the code below is executed. With ThisWorkbook.Sheets("table").Cells(27 + n - 1, 2) .Activate End With The first line evaluates to: ThisWorkbook.Sheets("table").Cells(27,2) --- Cell B27, which is a merger of Cells B27:M27 --- in this case. I get the following error: 1004: Activ... 8 Sep 2009 20:26

How to use Excel to determine cutting and reusing stock to fill or
Hello, we have a customer that requires we cut stock to different lengths. I've seen the cutting stock programs, but they don't address my needs. After determining the number of cuts I also have to combine the remaining material to make units. Example: I have a 16" piece stock, which can be cut into 4" segme... 8 Sep 2009 23:47

Restore Autofilter After Macro Runs
Hello, I have a sheet with autofilter. I need to turn off the autofilter before a macro runs but then I need to return it to the original condition (i.e. only original filtered rows are shown). How can I record the autofilter criteria and the field number in order to restore the original selected autofilter? ... 4 Sep 2009 22:02

Can't create an Object (Some sort of ActiveX thing?)
Hi, In this code both statements: Set a = New Acrobat.AcroAVDoc Set a = CreateObject("AcroExch.AVDoc") Fail. I have the Adobe Acrobat 7.0 Library checked and AcroAVDoc shows up in AutoComplete. Is there some sort of rule that says some ActiveX objects can not be instanciated? Thanks. Sub Searc... 9 Feb 2009 22:14

Problem with MSINET.OCX: instantiation of New Inet
Hi guys I need to download files from a static URL and am using the following code from http://officeone.mvps.org/vba/http_download_file.html: Sub HTTPDownloadFile(ByVal URL As String, _ ByVal LocalFileName As String) Dim HTTP As Inet Dim Contents() As Byte Se... 27 Jan 2009 13:15

MSCOMCT2.OCX registration error "ClassFactory cannot supply requested class"
I used the datepicker control from MSCOMCT2.OCX in Excel VBA, and I ensure that MSCOMCT2.OCX is present and registered on each computer. It works fine on most computers. But now on a new computer I can't register it. When I try to register it (with regsvr32), I get the error: System Error &H80040111 (-21472212... 14 Jan 2009 17:55