|
|
Excel VBA-Geting data from Access by
kodricales
My problem is that I don't know how to connect to an Access database
from Excel. I'm modifying a macro in which I have to compare some
strings in Excel cells...
|
|
2 |
878 |
|
|
|
|
0 |
876 |
|
|
Selection after enter by
Jeanette Caldwell
After entering data into the active cell, pressing the tab key moves the
selection to the right, but pressing the enter key does not move the
selection at...
|
April 30th, 2010 03:43 PM
by JLatham
|
4 |
874 |
|
|
Calculation by
KTC53
In one colum I have different years eg. 2009, 1979, etc.. In the next column
I have 2010. What I'm trying to do is subtract from each colum to show how...
|
|
2 |
870 |
|
|
Duplicates - ?? by
JLMcCabes
One worksheet has 600 + lines with a lot of expenses, including SOME of the
local expenses. This is a check register..
Another worksheet has 300 + lines with...
|
|
5 |
869 |
|
|
Hiding graphics elements? by
Blue Max
How can we hide pre-selected groups of graphics elements with the touch of a
cell or control?
We have two distinct groups of rectangles with gradient fills. ...
|
|
3 |
866 |
|
|
|
|
3 |
866 |
|
|
|
May 28th, 2010 03:16 PM
by tim m
|
2 |
862 |
|
|
|
|
1 |
861 |
|
|
|
|
1 |
860 |
|
|
Date format clarification by
Blue Max
When a user selects the 14-Mar-01 standard date format in Excel 2007, then
selects the custom format option, this is the standard format that...
|
|
6 |
859 |
|
|
Find & Replace in XP by
Jane
XP now has the ability to do a find & replace based on
formatting, but i ran across an issue. If I type the word
accountant in cell A1 and "accountants are...
|
|
3 |
856 |
|
|
Finding maximum value by
Ruan
Hello,
I want to find the maximum value in a column, but I want to ignore the
negative and positive part of the value. Basically, the maximum difference
from...
|
|
3 |
855 |
|
|
Quarterly Formula by
Caroline
Is there a formula to obtain a total for each quarter which excludes
including the year? Thus avoiding having to change to year on a yearly
basis. Your...
|
|
2 |
849 |
|
|
Sum of retuned valus as digits by
Vinay Vasu
Hello there,
I am using IF function to return values as digits. Now I need the sum of
such digits in a coloumn. Pease help me to do this.
Thank you
Jeevan
|
April 22nd, 2010 09:19 PM
by Brad
|
5 |
846 |
|
|
Hyperlink problem and question by
Shawn
I created a hyperlink to a pdf file ,it flashes and closes whats wrong???
\\Pwreports\PWREPORTS\2010\197\2010000005_NIBRS Incident Report.pdf
I can make...
|
|
1 |
844 |
|
|
Combo Box by
josros60[_2_]
Hi,
how can i make this code work in Combo Box (Activex Control) to
populate data fields in excel?
I got it to work in Combo Box (Form Control) but it will...
|
|
0 |
843 |
|
|
|
|
3 |
841 |
|
|
formula for copy and paste by
robbie5
can i create a condtional function in a cell that would send data in one row
of cells to a cell in another worksheet.
ex
a1
a2= aaaa
a3= bbbb
a4=cccc
a5=if a1...
|
December 27th, 2005 10:59 PM
by bpeltzer
|
2 |
841 |
|
|
Converting Quatro Pro files to Excel by
Phil at Richardson
We have a large number of files used in product costing, which have been created in Quatro Pro 7. We would like
to begin using Excel, instead of Quatro Pro. ...
|
|
1 |
839 |