Programming

#ref error
D/All I have linked crew data from access97 to one sheet1 excel97. I link this work sheet cells to sheet 2 in the same work book to get the crew names. All is fine but when I refresh the data after changing the information in access I get in sheet2 errors with #ref in the formula. I have to enter the li... 18 May 2010 08:10

Get Standard CSV File
Hello, I am trying to save some data from Excel to a CSV file to import into an application I am working on. The problem is that I get a file with Mime: application/vnd.ms-excel Instead of: text/csv How can I create a standard text/csv file? Thank You, Miguel ... 18 May 2010 22:32

Differences between VBA in Excel 2007-2010
Is there anywhere I can view a list of the changes (if any) made to the object model between Excel 2007 and 2010? I have a couple of business-critical macros which I've been maintaining for some time - when we moved from 2003 to 2007 it was quite painful since some of the code was no longer working as it should ... 18 May 2010 13:41

cell formula question
I am using the following formula in one of my cells: "=C1 / D2". The problem with this formula is that the result will be "#DIV/0!" if cell D2 contains no data. Can I somehow fix my formula so it does NOT return any value if either C1 or D2 is empty? I just want to avoid situations when the outuput of my formu... 18 May 2010 06:00

Converting digits to characters (123 to ABC)
Hello Experts, At my shop I'm printing product labels from an Excel sheet. I'd like to add the cost field to the label but the problem everybody would be able to know my cost for an item unless I encode it, so I thought of converting numbers to characters for example: 0 = Z 1 = A 2 = B 3 = C 4 = D S... 27 May 2010 17:04

SEARCH IS NOT WORKING
Search function in this forum Office Discussion Groups Excel Programming is not functioning. No matter what I search for I get "Your query for "whatever I searched for" did not return results." Check spelling, blah, blah, blah... I have not tried any others, this is the only one I use. ... 17 May 2010 23:29

Resize a password protected page
I need to resize a password protected page. The current macro works great when the page is not password protected. Private Sub Worksheet_Change(ByVal Target As Range) If Range("G15").Value = "Resize" Then ActiveWindow.DisplayHeadings = False Columns("C:C").ColumnWidth = Range("C17").Value ... 17 May 2010 22:24

Mouse Scroll event in listbox kills Excel
I had the same problem w/ Excel 2003 SP3. I've been using the same spreadsheet with several listboxes for months and never noticed it until today. I don't explicitly remember using the scroll wheel in the box, but it seems odd that I wouldn't have... I didn't find a solution, but I did update my mouse driver... 17 May 2010 19:08

How To Clear Drop Down Selection
Good Afternoon- I've created a simple spreadsheet in Excel 2007 which allows the user to select from several work locations via a drop down. Based on the work location selection, there are various work schedules they can select from. This was done using the Indirect function within the data valadation section.... 17 May 2010 16:55

VLOOKUP related question
Well it's been longer than I wanted to get back to this... too many projects with the new boss and this is a minor thing... still unable to get this to work. Here's what I've tried - Set ranArrayRange = Worksheets(2).Range("A2:G215") intCellRow = WorksheetFunction.Match(Worksheets(1).Cells(3,3).Value, ranAr... 17 May 2010 16:55