I have 2 versions of Excel. How to call out the application for both of them?

Shell "EXCEL"

Is it possible to tell with version should be open?

Thank you,

Zdenek

implementations of automatic behavior of excel trough VBA macros is the final solution for

Annoying repetitive tasks like:

1-- Import data and sort.
2-- report to a friendly display of data.
3-- make operations and filter data.
4-- Check captured data looking for values out of limits or finger errors.

Get involved in the matrix of excel and his virtual representation of work environment.

Discover the power of Excel meaningful as information on anything that man makes for his benefit out of resources available, in order to make tasks simpler to perform.

What I desire excel to do is explained on the attached 2010 excel sheet.

Please advise if these desired actions are acheiveable and if so- the cost, if additional software is needed and an approx ETA for your solution(s).

What I desire excel to do is explained on the attached 2010 excel sheet.

Please advise if these desired actions are acheiveable and if so- the cost, if additional software is needed and an approx ETA for your solution(s).

The following code filters a list of employee falling under the select employee in a hierarchy. Download the attached file and see how it works.

This is a reply to forum topic "Help Count Trios/Quartets/Quintets", posted by basculhu:

excelexperts.com/help-count-triosquartetsquintets

Hello, basculhu,

Dear users. I hope one of you might know the answer to this question.

I am currently trying to make an excel ark for the boat where I am working right now.
Here is the problem
I have created this worksheet.
Look at the attachment
Now I want to create a another sheet where I can look up the date the date that I have entered.
I don’t know how to program a bottom or made the cells auto full out whit the info from the other sheet.
Hope someone can help me whit this problem.
Best Regards
Allan Bamse Sørensen
Esvagt A/S

I am struggling to find a formula that can lookup a range of numbers and autopopulate the correct answer.

For Example:

If someone has a rate between 67% and 69% they reeive a score of 24. I need to be able to enter 68% in a cell and have a formula that knows 68% is in between 67% and 69%.

Currently my data table is set up with 67% in cell B5, 69% in cell C5 and the score of 24 in cell D5. Do I need to set it up differently? Please help.

I have attached an example. THe PIR tab is where I inout data and the legend is where I need to pull it from

Hi All

I have exported a file from our main system at work and require and need to pull it into Excel 2007 to create Pivot Tables for every department.

I can do everything that i said above the problem is with the data that is exported.

Let me start in saying that the data has to do with time sheets when people logged in and out at work. Now if the person do not log in or out the system gives the following value in its excel form --- which screws my formulas and pivot tables i have created.

It occurred to me that don't have a section on the Dos and Don'ts Of Spreadsheet Design... I think the best way to do this is to start you all off, and you can add your own pet loves / hates

Do   Separate inputs from outputs

Do   Use Data validation on input cells
       - make it as restrictive as possible
       - this reduces the chance of bad data

Here is a small Invoice Tracking Utility that simply logs the invoice details from various invoice templates. In the attached Excel file there is a 'Control sheet' to setup the utility, 'Invoice #s' sheet where log is created and 3 sample invoice templates where you enter invoice details. As you save or press Ctrl+S in your Excel file it logs the invoice details in the Invoice sheet. In Control sheet there is also an option to enable putting date stamp in file name while saving by turning this option TRUE or FALSE.

Download the attached sample file and try it yourself.

It has been many many years since I worked with excel - so I am definitely NOT an expert (once upon a time) and am desperately hoping that someone can help me.

My boss has asked me to set up a spreadsheet and so far so good all my formulas have worked until I have become brain dead.

Attached is small utility to create a Pivot table from a CSV file. There is a button provided on the click of which you are asked to choose the csv file and then the target cell/range where you want to place your pivot.

This is the macro code working behind the scene...

Sub CreatePivotTableFromCSV()

    Dim strFileName     As String

    Dim strFilePath     As String

    Dim rngTarget       As Range

Excel doesn't provide anything to sort on color. Here is a customised code snippet to achieve the same. Download the attached Excel file to to see how to implement color sorting in Excel range.

Solution to forum question on url:

http://excelexperts.com/help-me-please

Download attached file and see the formulas. I have added another column for sheet name.

Download the attached excel to see how you can scroll large amount of data in the visible area of the screeen.

Hello friends , i hope you all are doing good and God il take care of all of us...
I wish to make a button in VB-Excel ,which will perform some specific action, but may major concern is that this button should always be on the TOP on all applications, even the excel file or that macro is minimised..
For example Microsoft language bar in windows , it is always visible and is on top of other applications...
Can you please help me?////

Regards
Ruth

Can someone please give me some pointers with regard to working with large data (say 1 million rows, 200 columns) in Excel 2010?

Having the data on the worksheet from cell A1 onwards, I am trying to read it in memory via an array.

QUESTION 1. What is the difference between these two methods?

Method 1:

dim myarray()
myarray = cells(1,1).currentregion.value

Method 2:

dim myarray
myarray = cells(1,1).currentregion

The second method seems to be able to read "more data" than the first, though both fail if the data is "too big", with an out of memory message.

Could you please help me how to create in format cells a date format using only upper case letters, example: August 05, 2012 for AUGUST 05, 2012.

Refer attached Excel file for answer to forum question on
http://excelexperts.com/creating-2nd-list-dependent-1st-list

See data validation criteria conditions on Cell A2 and B2. Also see Named ranges created (dynamic named ranges can also be used here)

I am trying to have a column that will tell me if a student has passed, they can only pass if they get a 60% score for each section, there are four sections.

eg; Cell A1 has a score out of 30 so pass mark is 18
Cell B1 has a score out of 35 so pass mark is 21
Cell C1 has a score out of 35 so pass mark is 21
Cell D1 is marked as Pass or Not Pass

so to get a overall pass the student will need to get at least the minimum score
for each test. As I have over 400 results it would be great if the final score could be calculated for me if possible in excel.

There is an application on which i want to sendkey Tab , U ,Tab and then H by only pressing Ctrl+H.
(Ctrl + H) = sendkey(Tab , U , Tab and H.)
Can i make any macro in excel which will be running in the background and can send desired key stroke on a particular application running in foreground , when i press any assiaghned button.

Ruth

I am struggling to work out the correct formula to work out the following problem: I am trying to work out how many day hours and how many night hours make up one shift. E.g

Start time 1pm (date 8/7/12)
End time 1am (date 9/7/12)
Shift Length = 12 hours
Day Hours (Day hours are classed between:7am - Midnight) 6 hours
Night Hours (Night hours are classed between:Midnight - 7am) 6 hours

A1 = Start time
B1 = End time
C1 = Day Hours
D1 = Night Hours
E1 = Shift Length

Please help
x

I think I posted this in the wrong place earlier....sorry for the confusion

Here is small Task Management Utility with facility to view Reports. There is control sheet from where you can set the mandatory fields and fields that you want to show up in Entry sheet and Report sheet.

Give it a try and give your feedback and suggestions.

Download the attached UK Tax Calculator Excel file having simple and comprehensive tax calculator.

Simple Tax Calculator:

Comprehensive Tax Calculator:

In the Header at the top of a worksheet I have lost the white space which shows the active cell Location and to the right of this cell the space which shows th contents of the active cell. I've been using Excel many years and this has recently happened and I can't find a way to get them back.

I now have to double click on a cell and it's contents (formulas, etc) appear in the cell.
I'd like to get it back to the original format.

This is a small Leave system utility. Download the attached zip file and extract excel and access file from it. This can be used in a multi user environment as well by keeping the access database at a commonly accessible location and distributing the excel file to all users. In the access database there is a table 'M_LeaveTypes' from where you can maintain the Leave Type and Max Carry over for each type of leave. In this system an user is identified by his Windows login id.

Here is an utility to generate a simple multi choice questionnaire/survey (as you wish to use it). The survey response files can be collated using the collate responses button and selecting the created files