Programming

vlookup worksheetfunction
What is the proper syntax for using application.worksheetfunction.vlookup(emb,"c:\lists\filename.xls"!sheet1.A1:AB300,5,false) Basically how do you use the worksheetfunction vlookup looking up in a different file, with the full path in case the file is not open ... 15 Feb 2005 17:36

Combobox Vs Combobox
I am using Excel 2000. I created a sheet that automatically creates and adds comboboxes into the row where new data was entered. I am using the code: ActiveSheet.OLEObjects.Add(ClassType:="Forms.ComboBox.1", Link:=False, _ DisplayAsIcon:=False, Left:=sLeftVal, Top:=sTopVal, Width:=sWidth, Heigh... 15 Feb 2005 14:41

VBA Password Removal??
hi there has to be someone out there that can supply some code (or similar) to remove VBA password protection! i have a large document built by people who have left the company, with errors in and i cannot get in to fix it!! if i try to go in to any of the recommended places i am blocked by our firewall! ... 15 Feb 2005 09:05

how do i release memory
Hello, i have an error message: cannot empty clipboard. The Office Clipboard shows that the clipboard is empty. This situation persists even after shutting Excel i ran out of memory after running program that does many ( approx 100) open workbook/(copy/paste)/close workbook operations. The memory usage b... 14 Feb 2005 23:58

Fileformat XLText
I have some VBA code that saves a worksheet as XLText in Excel 9 but it doesn't work in Excel 10. It appears that XLText is not a valid file format. Instead I have the option of XLTextMSDOS, XLTextWindows etc. Does anyone know which one of these will give me the same file format as the plain XLText did in ve... 14 Feb 2005 13:48

Setting default printer using wsh
Hi Excel 2000 I use the following wsh script to set the default printer: Dim oNet Set oNet =WScript.CreateObject("WScript.Network") oNet.SetDefaultPrinter("hp LaserJet 1300 PCL 5e") Set oNet=nothing (The port name for that printer is DOT4_002) This works fine and the controlpanel is showing that... 14 Feb 2005 18:11

Dataform
I am using Excel 97. Is there a way to customise the form in the Data menu? -- Mark ... 14 Feb 2005 08:13

Constant definition
The constants such as xlcopy, xlpaste, etc. I understand. However, in trying to define what a constant is, I'm not as clear. Is a constant an application (Excel) property? I'm struggling a bit with properties, objects, etc. -- Thanks! Dee ... 13 Feb 2005 23:57

xla with password.
I have a xla file protected by a password. But I have forget it. Is it possible to retrieve it or to open the xla anyway ? Thanks for your answers. Bye ! ... 14 Feb 2005 08:44

Creating Pivot Tables inside a Macro
Does anyone know where examples can be found of creating pivot tables in macros? After some reading up on pivot tables, I went through the steps to create one that I needed and recorded the steps in a macro. But when I tried to run the macro, it failed on a line with the following in it: ....ActiveSheet.Piv... 18 Feb 2005 17:17