General

Excell docs save with a 1 added on.
When I save an Excell file it saves under the original name but adds a 1 to the end. For example, if I save a file called test, the next time I save it it comes up as test1.xls, the nest time as test11.xls. Does anyone know how to correct this? ... 12 Jul 2008 20:44

code to delete module / macro in another file
Is it possible to write code to delete a module or macro in another excel file. I have a file that I savecopyas but need to remove the modules and macros from the copy file only. ... 3 Jul 2008 00:14

error in code
hi, could anyone tell me what could possibly be wrong in my code - see remark below? i keep on getting an error message thanks Private Sub Workbook_Open() Const sAPPLICATION As String = "Excel" Const sSECTION As String = "QUOTE1" Const sKEY As String = "QUOTE1_key" Const nDEFA... 3 Jul 2008 03:17

Using formulas with a drop down menu
I have the same situation as stbrnalt. I have a drop down menu (cell S59) that contains three lines; item 1, item 2, and item 3 (from a tabie in column T and lines 52, 53, and 54). Item 1 is $1.00, 2 is $2.00 and 3 is $3.00 (from a table on col U, lines 52-54). How can I make the item in the drop down autom... 2 Jul 2008 21:10

Formula error
Could you look at the below formula for Select Case and tell me what is incorrect. It does not perform correctly on the worksheet. Const SaddleBlanket = "O5:O43" Dim SaddleBlanket As String Worksheets(R12).Select Range(SaddleBlanket).Select Selection.Interior Select Case S... 3 Jul 2008 17:40

Formatting Percentages
How do I make a 0.0% appear as a hash mark (-) ? Thanks. ... 2 Jul 2008 21:10

Longitude and Latidude Formatting
I imported a text file with latitude and longitude cordinates into an excel spreadsheet. The longitude and latitude came in as DD and not DMS like I had planned. I read some other posts on how to fix this and tried them but it didnt seem to work. When I formatted the cell in [hh]°mm'ss\" it came out as #######.... 3 Jul 2008 11:28

Requiring Cell Content on Save
I'm creating a 12 question survey in Excel and want to find a way to require users to provide responses in specific cells. Ideally, I'd like to run a check on cells I'm requiring a response in and make sure those specific cells are not blank. If they are blank, I'd like to generate a dialog box warning that r... 2 Jul 2008 20:08

Shading When Selecting Nonadjacent Cells
In Excel 2007, when selecting nonadjacent cells using the control key, previously selected cells are not highlighted (or so faint that you cannot see them) while selecting the next group of nonadjacent cells. Where do you go to adjust the appearance of selected nonadjacent cells? ... 2 Jul 2008 19:07

File name is followed by a colon then a number, what does that
The weird thing is that i only opened the file one time and if i close one of them, it usually closes them both. If i have the file open already then try to open it again, it doesn't add the colon and number, just re-arranges the sort order in View/Switch Windows. If i open up another instance of Excel then t... 2 Jul 2008 18:05