Anyone know how to open a 2nd workbook in VB? I also need it to close when the original workbook closes

There are about 10 workbooks that I open every day, usually several times a day. Excel remembers the last 9 files, not the 10 most wanted. is there an easy...

Is it possible to get 2 decimal cell using IF or any formula? for example if cell A1 has or is "abc", cell A2 should be 2 decimal. Thanks. Mukesh

Spreadsheet with 2 columns, first has site name, second has time taken to make a delivery to that site (In decimal) So for instance A1 = London B1 =...

We We are exporting data into Excel in CSV format. I would like to create a template in Excel which can then be applied to the CSV file when I open it. I...

The following is the Row of codes that states like INVMP etc. How can I formulate in a cell to tell me that when the code row is a text, give me result...

Hello, I'm taking a systems and industrial engineering class, and we're using: Optimization Modeling with Spreadsheets by Kenneth R. Baker. This book has a cd...

Sometimes when I link a cell to another in a different spreadsheet it will only show the formula not the result. E.g. The cell shows "='Stock List - Supplier...

I am trying to keep race times in excell. Anyway, the question is how to calculate race results. When I do a simple formula for subtraction, "=A10-A9" kind...

Hi, I use Excel 2007 Home and Student. It has a lot of columns (max. number: XFD. you do the math). that means the horizontal scroll bar is very not...

I'm having an ANNOYING problem with Excel 2003. Somehow the visual basic debugger got turned on, so every time I go to past something into a cell in my...

When copying Excel text (saved as tab delimited) to Notepad - the save as comes up ANSI however a dialogue box comes up that some data will be lost unless it...

Is there a way to use the fill series function in 2007 without using the mouse? It used to be so simple: alt - edit -fill - series - date - month, (or...

I am attempting to save data to Notepad and it comes as a ANSI type file. I receive the following dialogue box "are you sure you what to save in this format...

How do you Identifying duplicate values in a range? Thanks

I have a formula in a cell and would like to apply it to a large range of cells. Is there a easy way to do this? The area is too large to click and drag.

Windows XP, all service packs & updates, Excel (Office) 2003. I recently had to recover my PC using Norton Ghost. I use a number of Excel *.xls projects...

Hi, I want to know how to use the instruction Range("RangeName").Value = Output in a VBA function to paste in a spreadsheet a value which is not the principal...

How do I get an automatic count down to the number of days, minutes etc to an event

I try to save as file with text and I get the following message: Test 1 5-1.xtx may contain features that are not campatible with Text (Tab delimited). Do...