Programming

Build an Array of Different Values From Column
How can I build an array with non repeating values from a column? For example, in Col. A I have this: Col. A 1 2 3 3 3 4 4 I want MyArray = Array(1,2,3,4). No duplications. Can I use the Split Function? MyArray = Split(MyRange, "", 1, ) ' this doesn't work, Err: Type Mismatch Thanks in Advanc... 26 Jan 2010 10:57

Handling different Error 1004 errors
If I'm performing actions through an Excel.Application object, the only error code I get is 1004, which appears to be a generic ODBC error code. How should I check for more detail on the kind of error that occurred? All I appear to have is the Err.Description, which I can check for certain key phrases such as "The ... 26 Jan 2010 12:06

how can i append data to a sheet or book from another one
we can append data to a file from anther file in dbase. is it possible in excel??????? ... 26 Jan 2010 04:23

How to: obtain the filename that a module exists in, via VBA?
Hi Tom, How can we return a workbook's file name with and without extension? Thanks in advance. ... 26 Jan 2010 02:13

Help with looping in Excel
Hi There, I have been trying to populate a column (column 14) in Excel using VB for a while and I just can't seem to solve my problem. I am looking at 3 colums; columns 10,12,&14. colum 10 is qty, colum 12 is Absolute dollar value. if colum 10 is not null and less than 0, then colum 14= (- colum 12) or else c... 2 Feb 2010 17:30

Excel 2007 query - Access MDB question
Question: In Excel 2007, when clicking on the: 1) ‘Data’ Ribbon/Tab… and choosing.. 2) ‘From Access’ and selecting any Access mdb, the database will be opened in ‘exclusive’ mode and will be locked for all other users on the network! Why??? When recording these steps, I see that the default system q... 25 Jan 2010 12:49

Novice - using macro to protect with password
I want to protect every sheet in a workbook with a password. I understand this is tricky, so I will be satisfied if I can write a macro to password protect every sheet, which will save me typing in the password twice for every sheet. I have used macros before by simply recording them, but have no idea how to w... 25 Jan 2010 18:31

Unexpected internal error or not enough memory
I have programmed a workbook using solver in VBA code. Now I added a lot of other worksheets and data acquisition capabilities to the workbook, and cannot operate the solver from the VBA, but it works when I start it manually. The error message appears while setting the solver's option parameters. The solver is... 25 Jan 2010 09:26

convert to capital letters
I need a code that will search a range (say, A1:A10) and convert everything in that range to all caps? -- Thanks Shawn ... 25 Jan 2010 09:26

ActiveWorkbook.SaveAs Function - Can I specify the user account to save the file with
If what you want is to merely determine who last edited the file, you can examine the file properties for that. On Mon, 25 Jan 2010 04:06:02 -0800 (PST), TyreDude <manning24brett(a)googlemail.com> wrote: Hello, Can I use the ActiveWorkbook.SaveAs function and include the user account to save the file as... 25 Jan 2010 08:19