Programming

Multiple Office Versions
I have multple versions of Office installed on my machine. Prior to Office 2007, whichever version of Excel that I used last is what Windows would open an xls file with. E.G. If I last used Excel 2003, then opened Windows Explorer and double click on an xls file, it would open in Excel 2003. Now that I have inst... 23 Jul 2008 01:01

link excel or calc data sheet with access database.
I have spread sheet where I update pricing. I need any changes to prices on this list on selected parts to reflect prices on the Access database . This database I farther used on website. Software used ms office 2007 excel and access . ... 16 Jul 2008 10:56

Merging Worksheets together into Master Worksheet
I am trying to merge all worksheets from the workbook into one master sheet. I have downloaded Ron's example from his webpage and it works great in his test file. But when I close that file and bring up the workbook that I want to run the macro in, it has disappeared. How do I get the macro into my personal ... 17 Jul 2008 18:55

Trim function in macro
everyone. I saw a good, basic into to macros on the Microsoft site, and one of the macros I found particularly useful was the one to concatanate two columns into one. I got it to work nicely, until on some data, the new concatanated column would have multiple spaces, probably because the data came from a data... 16 Jul 2008 11:58

Index Creation
I work on a lot of different projects that are similar, but use different sheets. I have created each sheet into it's own file. I tend to make one master workbook for each project dropping in the individual sheets I have previously made. Is there some magic formula or procedure to have an index created, maybe wi... 16 Jul 2008 10:56

increasing Excel spreadsheet iteration time?
How can I increase the time (i.e. extend the time delay) between successive automatic iterations of a 2500 cell spreadsheet. ... 16 Jul 2008 11:58

Insert Two Lines After Change in Project Number in Column A
I have a list of project numbers starting at A11. I would like to insert two rows everytime the project number changes, and put a sub-total for that list of values in column N please. Thanks, Nick ... 16 Jul 2008 10:56

Code for OptionButton displaying new frame
Hi all! I have a user form with several frames containing optionbuttons. I want frame 4 to only be displayed if certain OptionButtons in Frame 1 are selected. If they are not selected I want Frame 4 to remain hidden. Is there a way to do this? Thanks in advance Paul ... 16 Jul 2008 09:54

Trouble updating a cell's text that has a formula in it throug
Actually, the reason I am trying to do this is because I have a user defined formula written in VB.Net using VSTO. This formula takes in name, hits a database, and then returns back another attribute from the DB based on that name. I have VBA code in Excel that goes through and recalculates the selected cells... 16 Jul 2008 09:54

How to convert the string to variable?
I write VBA in Excel 2003. I have a program which have the serveral variables, say, var1, var2, var3. Every time when I need to put a value to these 3 variables I need to write the code as follows: for i = 1 to 3 select case i case 1 var1 = <value> case 2 var2 = <value> c... 16 Jul 2008 10:56