Using Excel 2002, Excel will not maintain toolbar customizations and will also not close properly. 1. If a button is added to a toolbar, it functions...

I've installed every option on my Office 2003 standard CD, loaded the Office2003 Converter Pack (oconvpck.exe from Article ID : 212265 ) and updated to the...

How can I load a database from an Access Application in VBA? I tried with GetObject function, but I don't know how to get the database. Remy

Dear Sir, Is it possible in Excel that by just encoding the data in receive and issue voucher it will automatically post in STOCK CARD worksheet and then...

I want to automatically generate a sequence of numbers from 1 to....X without typing them all. How?

I have put in formula to total a column of figures, it has empty cells for new items to be entered as they occur. It used to total in new items...

is it possible to make the hyperlink relevent to the text within a cell. i.e if the cell said paul it would email to pauls email address or if the same cell...

I have a spreadsheet that the data, the date was input in Excel 2003 as mm/dd/yyyy (12/31/2004), how can I convert the column of cells format to...

Hello, I have a situation where I want to move 3 sheets from one workbook to another. The Problem is that the sheets appears to carry their File Path with...

Just heard from MS that they were 'playing' with this in the Beta2 timeframe to try and come up with a more satisfactory conclusion for all, but the next...

Sorry if this is posted in the wrong fourm but heres what I am trying to do: I need to set up a spreadsheet, i've got the basics down (I think) but am having...

I have tried and succeeded in importing a .csv file into excel. This file has numerical values. After converting the file, I try and add a few of the numbers...

i have a .xls file that has been layed out very nicely (and i wasnt supposed to change it), but the silly bugger who designed it, didnt put it the formulas...

In a Macro How do you print a string in a macro? For instance: Print "Hi there" So "Hi there" goes to the printer. I tried all kinds of things but it keeps...

Hi I am new to excel and would like to design a form, that keeeps track of the construction maintenance jobs we have in then when they have been completed...

I have exported from an Order Entry program to comma delimited text file customer purchases. The file has more entries than Excel can handle on one...

Help! I am a novice trying to modify a worksheet that someone else created. I am baffled by something that I can only describe as a "floating" cell. ...

I dim Warning(100) as string Then I do the following: Warning(1) = Cells(1, 3) + " " + Cells(3, 3) + " " + "Assessments" + "= " + Cells(2, 13) + "," +...

Hi I have got this macro to run when opening. All works, but when I password protect the sheet, and then close and open i get a run error. I am not fluent...

I have two conditions 1. m20 2. =M2-P23 It only pays attention to the 2nd condition. As if its and "or" rather than an "and". I'm using conditional...