Determine field from attribute
With Attribute.GetCustomAttribute() I can obtain the attribute if I have
the field. How can I achieve the opposite, how can I obtain the field
from within the attribute? I want to check the field type in MyAttribute
constructor, and throw exception if attribute and filed mismatch.
Something like more detailed AttributeUsage functionality.
Hi Mihajlo Cvetanovic,
You wrote on 19/02/2010 :
> With Attribute.GetCustomAttribute() I can obtain the attribute if I have the
> field. How can I achieve the opposite, how can I obtain the field from within
> the attribute? I want ...Determine if data label overlaps chart title?
Hello again, all you experts. I now have run into a new issue
when generating charts via VBA.
I add data labels only if the datapoint belongs to a particular
company. Sometimes, the data label
is on the last (and highest) point on a distribution curve. It
then runs into the title of the chart.
I've been trying to capture this in code but am at a loss. I
can't find any property of the data label
that tells me its top. I haven't even gotten to trying to
compare this with the bottom of the chart title!
What I want to do is change the data label's position to bottom
i...Help with summing numbers in cells that also contain text
I have a work schedule where the column heading is the employee's name and
the cells below indicate what the employee's status was for that date, as
col A col B
01/01/07 8.0 SIC
01/02/07 4.0 SIC
01/03/07 D (indicating worked the day)
01/04/07 8.0 VAC
TOTAL SIC Hrs: 12.0
I've tried extracting the numerical values into a hidden helper column "C"
using the following formula: =IF(RIGHT(B2,3)="SIC",LEFT(B2,3),"")
It extracts the correct value, how...How do we determine crew size with Microsoft Project?
How do we determine crew size with Microsoft Project?
Crews for what, to do what, with what? How many hours of work have to be
done, what constraints are there (physical, safety productive etc)? Which
version of project?
Project is a calculator, like Excel. unless you enter data it can't
calculate anything! Tell us a lot more and maybe we can help.
Microsoft MVP for Project - http://www.project-systems.co.nz
Author of the only book on Project VBA, see: http://www.projectvbabook.com
"HarperMatrix" <HarperMatrix@discussions.microsoft.co...number format #15
normal format for number & currency in excel is
How to configure numbers as well as currency as
xx,xx,xx,xx,xx,xx,xx,xx,xxx.00 format ?
when custom format is used, the entry is converted to
thousand comma separator format.
Here is an answer from Bob Phillips to a similar request
I think you may be intrested in the add-in I have modified for the
Indian numbering/currency system. The original code is available on MS
site for English system. The add-in is attached in zipped format. If
you nee...Equating a Percentage to a Number
I am a new excel user. I am trying to set up an electronic grade book and I wanted to know is there is a formula I can use to tie a letter grade to a percentage.
You are a bit vague, do you have number grades or letter grades?
that means 0-59% F, 60-69 D and so on, replace them with numbers 1-5 if
or change the whole scale if needed
"Laura" <firstname.lastname@example.org> wrote in mes...Entering a 16 digit number
I am creating an Excel worksheet and am trying to enter credit card numbers
in one of the columns. When I enter the number, it automatically changes the
last digit to a "0". How do I format the cells to accept a 16 digit number?
Format as text or precede the entry with an apostrophe, excel has 15 digits
precision but I assume you won't do any calculations with credit card number
(No private emails please)
"Tbird" <Tbird@discussions.microsoft.com> wrote in message
>I ...Determining the Active Worksheet
My problem here is of course in line 1. I need the code to run based on what
worksheet is active. There will be a series of these if statements (if May
is active I will select May - September and so on). So is there any way to
write the first line to determine the active worksheet?
If Worksheets("April").Active = True Then
Sheets(Array("April", "May", "June", "July", "August",
For your first line you can use:
If ActiveShee...how to insert roman numbers
I am trying to insert roman numerals such as Grade 2
For Roman 2, have you tried holding the shift key while pressing the i key
"drisc229" <email@example.com> wrote in message
>I am trying to insert roman numerals such as Grade 2
How do you want to use the Roman numerals? If you want a numbered list, just
choose the desired numbering format (i,ii,iii or I,II,III). If you want a
sequential list with entries anywhere in the text, use SEQ fields. If you
want static ...How do I determine if I have Exchange?
"Home users typically do not have an Exchange Server e-mail account; instead
they use a POP3 e-mail account with an Internet service provider (ISP) or use
a web-based e-mail service, such as MSN Hotmail. If you use a POP3 e-mail
account, your ISP can provide you with your specific account information.
People without Exchange Server accounts cannot use the features in Outlook
that require an Exchange Server."
The above message appears in the HELP file, but I still need help
determining if I do have an "Exchange Server"?
Did you purchase Exchange Server and ...determining identical ranges
Can someone refresh my memory as to the array formula one would use t
determine if the data in two ranges are identical?
Also, how would I return an array of the row numbers of the rows i
Range A that are not identical in Range B?
Message posted from http://www.ExcelForum.com
Array-entered. Not case sensitive.
mvpearl omitthisword at verizon period net
"upstate_steve >" <<upstate_steve.156g8e@...Auto
I have been working with a customer who was required to migrate from Lawson
software. They were used to Lawson automatically generating batch numbers
for them in Payables and Receivables and I think General Ledger as well.
They think it is odd that GP doesn't create batches automatically.
My basic question is anyone aware of a valid tested third party solution
that would autocreate batches for at minimum Payables and Receivables?
Thanks much -
Its very easy to be customized, we already customized such solution for one
of our customers to automatically generate batchs base...Getting error number 0x8004011D
This is a multi-part message in MIME format.
I got err msg ' Task " Microsoft Exchange Server reported error =
(0x8004011D). The server is not available.... " whenever I send out mail =
from this particular PC.
Receiving of mails are working fine but not sending out mails.
Other PC clients can send/receive mails from this Exchange svr ( =
Wonder what have I missed out?
------=_NextPart_000_0019_01C632ED.8A...Comparing one list of numbers against another
Hi , Can someone help me with this problem
I want to compare a list of tape media with another , The results should
show missing media and new media in separate columns
First Inventory Second Inventory Missing Media New Media
TAPE01 TAPE01 TAPE07 TAPE11
TAPE02 TAPE02 TAPE08
TAPE03 TAPE03 TAPE09
TAPE04 TAPE04 TAPE10
Any help appreciated
When I am doing my purchase receiving at the Receivings Entry, I sometimes
encounter some problem which the Receivings Number.
For example, suppose the new receivings number should
be REC/03/000004, but this number REC/03/000005 is given
to me instead. What could be the possible cause of the
missing receivings number:REC/03/000004. (this no. is not
used by anyone).
Please advise or tell me how can I avoid.
Thanks in advance.
I believe it's when someone started to do a receivings but then deleted it.
It already increments to the next number. You can prevent deleting of
documen...Calculate total number off cells with data in
Hope I find you well
I have a spreadsheet that has a number of cells that may or may not have data in them depending on curtain criteria. What I would like to be able to do is count the number of cells with data in (data is alphanumerical) and display the total number of cells with data in in a different cell. Any ideas?
> What I would like to be able to do is count the number of cells with data in (data is alphanumerical) and display the total number of cells with data in in a different cell. Any ideas?
Check out the COUNTA worksheet function.
Jan Kare...Page numbers restart with continuous page break
This happens in 2007, 2003, and 2002. My doc has 2 "next page" section
breaks within the first 3 pages. After each break, I've requiested that the
numbering restarts at "1" and that works fine. After several pages I need 2
"Continuous" page breaks so I can use a 2-column format within a page. I use
the Insert Page Number Format command to have it CONTINUE numbering.
However, it restarts the numbering. If I do this as a test with a doc that
does not have regular section breaks at the beginning it seems to work. Best
case, I would like to ma...Splitting Numbers in a Column
:confused: I have a column of numbers that are 21 digits long. For
each number the first 7 digits represent a department,
the next 5 digits represent a class and the last 9 digits
represent the account #. Is there a simple way to
separate the single column of numbers into 3 columns
with the appropriate headings?
An example of the type of numbers in the column is as follows:
----------...Checking Winning Numbers in the Lottery.
For people who may not understand the lottery rules for the UK.
Person picks 6 numbers in the range 1 to 49 (no duplicates)
If all the 6 numbers come up then when the lottery numbers are announced,
then it is serious party time.
We have 25 people in our Lottery syndicate and therefore I want to automate
the checking of numbers that are announced with numbers that are pre-selected
by the 25 individuals. Additionally, I want to know how many numbers have
matched in an individual row against those announced.
Assume lottery number announced (in ascending sequence are) 1, ...Any way to convert column of numbers from positive to negative?
Is there any way to convert a column of numbers that are positive to be
negative? We create a text file from our general ledger program that has all
the transactions for the past year, then import that file into Excel. We use
the text to columns to convert the text file to a usable format where the debits
are in one column and the credits in another. The problem is that all the
numbers are shown as positive so when we net various figures the amount is not
correct. Here's an example:
...How to create CMainFrame-based dialog to display variable number of listboxes in a CFormView
I have an app where I need to display a variable number of CListBoxes (in a
single row) in a CFormView.
I don't know how to dynamically create the CListBoxes and attach them to the
CFormView, something that would normally be done through resources if it
were a fixed number of listboxes..
Could anyone give me an idea of how to dynamically allocate and attach
controls and then any cleanup?
I also need to know how to manually hook up a CMainFrame with a CFormView,
as the AppWizard only creates something like that as a topmost window, I
Any help would be greatly appreciate...Numbering Lines and Paragraphs
I'm using MS 2007.
I'd like to number the lines of a doc, but restart the numbering with each
The only options I see are:
Restart Each Page
Restart Each Section
Suppress for Current Paragraph
Is there any way I can change the settings, short of making every paragraph
it's own section?
(I'm doing some editing for a project and we use shorthand to reference
where to make changes, such as: P10 L15 [paragraph 10 line 15])
To clarify... I also need the line numbering to start new at each paragraph
so in the example (...Convert text numbers to number format
I have received a file that has a date column. However, the column is
reading as text. I need to change the column so that the date reads as
a number format. Any ideas?
montagu's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15227
View this thread: http://www.excelforum.com/showthread.php?threadid=314927
Right click and reformat as you want then click on cell and press F2 an
enter to refresh data that should do the tric
--------------------------------------...How do you determine which certificate template to use
We are trying to setup RPC/HTTP and have had numerous problems. We think it
has something to do with the certificate and SSL. How do we determine which
certificate template to use?
On Tue, 1 Feb 2005 12:15:06 -0800, "RP" <RP@discussions.microsoft.com>
>We are trying to setup RPC/HTTP and have had numerous problems. We think it
>has something to do with the certificate and SSL. How do we determine which
>certificate template to use?
You shouldn't need to use a certificate template, it's just a computer
Run MMC, a...duplicate voucher number the same payment number exist
Two different transaction but same payment number. One is already
posted that's why the error appeared duplicate keys every time i
posted the other transaction. Why is it that there is a duplicate
number since the transaction made in different time although same day!
I saw it in pm10300.
i need to post the other transaction but i cannot post because of that
posted payment number exist. What can i do? any body can help me
regarding this matter.
I would delete the payment and redo the task.
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MC...