|
Reading HTML Controls
I have a spreadsheet that has data in in HTML controls.
For example in D4 there is an embed function that contains the control
HTMLText15. It shows 87.3
If I use the function value(D4) I get 0.
If I write a macro with VBA code I can reference HTMLText15.value and
put in cell D4 in another worksheet.
How do I know where the HTMLText controls are. Has anyone worked with
these.
You can re...
|
1 |
06.09.2006 19:13:31 |
|
|
Unique text count with multiple criteria?
This formula is working but what it's doing right now is giving me a
total unique count of names PER QUEUE. Sometimes agents work in two or
more queues per day, so what I need it to do is give me a total unique
number of names even if the same name shows up under multiple queues.
Make sense? If so, does someone know how to make the formula do that?
=SUMPRODUCT(((Queue_User_Routing.csv!$C$...
|
5 |
06.09.2006 19:01:51 |
|
|
determine if date range falls within date
Ok, this one is driving me crazy! Seems like it should be simple, but
no luck so far.
Here is what I've got:
a2 start date 2/10/06
b2 end date 1/29/06
c1 - aa1 dates by month ex 1/1/06 2/1/06, 3/1/06 etc...
Example
12 months exist between the start and end date, whenever the date
listed in cell c1-aa1 falls within the start and end date range the
value true is returned.
end r...
|
2 |
06.09.2006 18:35:08 |
|
|
Workbook protection
Hello
I have a excel document with an serial nummer protection. It is a
trailversion for 30days. i got it from somebody but the trail period is
over. Now some funktions are not working. My knowledge of VBA is not great
and i don`t know where to look. So can somebody help me tho get the file
working?
-
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/...
|
3 |
06.09.2006 18:16:51 |
|
|
Footer - max of 255 characters
Is there is no way around the max for footer is there? Can you not have more
than one column for a footer?
I have Excel 2003 and I was wanting to place a legend for codes as footer at
bottom of page but unfortunately I exceeded 255 characters. Guess Word does
have advantages over Excel.
...
|
4 |
06.09.2006 18:10:10 |
|
|
Cell Reference Formula Outside Workbook
I am trying to reference a cell outside of my current spread sheet. I
am using a cell in my current sheet as an input for the extension of
the file I would like to look in. So I have this defined as LINK. And
the value of link is something like C:\\Myfolder\ready.xls
I am trying to set up a formula in my sheet that will use this
reference to the cell on the first page, which I defined ...
|
2 |
06.09.2006 17:37:39 |
|
|
.jpg or .bmp into faceid
Hi!
Is there a way to make my own faceid?
Can I turn a jpeg or a bmp into a faceid?
It would be sooooo cool...
Thanks,
Albert...
|
2 |
06.09.2006 17:28:58 |
|
|
Autofilter - SUM
Hi,
I'm using one excel document with Data >- Filter >- Autofilter function. I'd
like to put autosum command but it doesn't work with autofilter's columns.
Please help.
...
|
3 |
06.09.2006 17:20:37 |
|
|
Filter mode
Hello All
I have a worksheet with autofilter set to on.
In the bar just above the taskbar, on the far left, I notice that it says
"Filter mode", and if I right-click on that I can select options Average,
Count, etc.
BUT: whichever option I select seems to have no effect - it always says
"Filter mode"!
Is there another setting that needs to be set somewhere?
Hope someone can help.
...
|
2 |
06.09.2006 16:53:21 |
|
|
Bypass New Workbook pane
Excel 2003. Is there a way to bypass the New Workbook pane when
opening templates on this computer. So you would just click File, New
and it would open the Templates window at once.
If not, is there a way to have more "recent" templates in the New
Workbook pane than the actual 4?...
|
3 |
06.09.2006 16:51:33 |
|
|
Filling in a column with text
I tried doing some searches on my problem, but it is so hard to
summarize in a few keywords. The subject, above, is not very accurately
descriptive, either.
Here is my issue:
I am an engineer in a production environment. We track the Downtime for
the various pieces of equipment that we run. We have a spreadsheet
where the production operators input the equipment data.
Each day has a time co...
|
4 |
06.09.2006 16:48:58 |
|
|
Checkbox Problem on Locked Worksheet
Hello all,
I am having a problem on a worksheet I created to track employee time.
The problem is with the checkboxes. The employee can check the boxes,
and you will see the days field at the bottom automatically update.
With the sheet protected, the checkboxes go crazy. If you play with
them and try to click them, you will see that if you click one, it may
check the one next to it, etc. ...
|
6 |
06.09.2006 16:31:07 |
|
|
Paste Special
Sometimes when copying data from one spreadsheet to paste into another,
I get a different "Paste Special" dialog box that seems to be treating
the data as an Object or Picture etc. (rather than the "normal" dialog
box which offers the options of 'Values', 'Formulas' etc.). I've never
been able to figure out why this is. Anyone have any ideas?
...
|
3 |
06.09.2006 15:27:02 |
|
|
XML file into Excel 2000
Hi,
I have a xml document that i want Excel 2000 to open. I'm having
difficulties reading the file in, is there a utility/parser built in to
this version of excel?....or will i need to use a 3rd party tool?
thanks.
...
|
3 |
06.09.2006 12:45:15 |
|
|
faceid on menu bar
Hello.
How can I add a FaceId to a new popup on the menu bar?
Thanx,
Albert...
|
2 |
06.09.2006 08:43:09 |
|
|
Is it possible to get text values in a pivot table?
From this:
ROW COL VAL
A HD1 X
B HD2 Y
B HD1 Z
C HD3 J
A HD3 Z
B HD3 R
C HD1 S
Get this?
Var of VAL COL
ROW HD1 HD2 HD3
A X Z
B Z Y R
C S J
(If 2 rows go to same cell, would need to get maximum or first).
...
|
3 |
06.09.2006 04:03:14 |
|
|
printing more than 1024 characters in a cell
I have Excel 2003 and can see all of the text contained within one cell (more
than 1024 charcters) in the formula bar but once I click out of the cell part
of the txt disappears.
I have used Alt+enter to break the text into paragraphs but this doesn't
solve the problem.
I would like to print large text wrap cells >1024 characters. Is it possible
or do I need to split the txt into...
|
2 |
06.09.2006 02:10:42 |
|
|
Count weekdays from NOW() to a future date.
Hello all,
Is there a formula I could use to count the number of weekdays from today
until a future date? If I use DATEDIF I can get the number of actual days,
but I'd like to get the number of weekdays from today (i.e. NOW()) to a
future date, say December 13th, 2006. Can Excel do this?
Thanks,
Art.
Windows XP
Office 2003.
...
|
9 |
06.09.2006 01:19:25 |
|
|
How can I expand a worksheet beyond 256 columns and 65536 rows?
As subject...
|
6 |
06.09.2006 00:53:27 |
|
|
print hidden values
I have a spreadsheet that has two cells that I have hidden by going into
format cells to number and typed ;;; (3 semicolons) in the type box.
I would like to be able to have the sheet print without the value showing on
the screen. Does anyone know how to set a macro to allow hidden cells to
print?...
|
2 |
05.09.2006 22:37:19 |
|
|
Sort Cells/Columns
I have three lists of items (numbering about 150) on a single sheet using
columns A, D & G.
I need to sort these in alphabetical order continuous across all three
columns. All I get at the moment is each column individually sorted, which
is no good to me.
Can anyone help?
TIA
Ed
...
|
7 |
05.09.2006 22:19:19 |
|
|
Cell Selection Bug!!
Not sure if anyone has seen this before:
if a selection in BookA is copied to BookB whatever was originally
selected in B stays selected aswell as what is copied in e.g say you
select A16 in BookB then go into BookA and copy A1:C1, go back to BookB
and paste into A1:C1 - the bug is that A16 is still selected (and stays
selected whatever other cells you select)
Is this an Excel;2003 bug??...
|
2 |
05.09.2006 22:16:01 |
|
|
Summing cells with no value ("") and obtaining ""
I have a column of cells that if there is no value in any of the cells
(""), It needs to return "". When I sum the cells, It still returns a
"0" even when there is nothing in cells. Any suggestions? Thanks.
...
|
6 |
05.09.2006 20:45:54 |
|
|
Complex Number Formatting
While trying to set up a vector "Cross product matrix".
-- technically not really a matrix, but rather just
mechanically calculating the determinants from the
entries within a square matrix. I ran into a major
formatting irritant with Excel. When I convert
the polar form of a complex number from two cells
to rectangular form within a single cell:
=COMPLEX(D8*COS(E8*PI()/180),D8*SIN(E8*PI(...
|
17 |
05.09.2006 20:33:15 |
|
|
Hide two cells until print
I would like to be able to hide the contains of two cells when on the screen
but have it show when it is printing.
Anybody have any ideas?...
|
2 |
05.09.2006 19:48:38 |