Format Cells to Capital Letters
Can you format a cell so that regardless of how you type the letters into the cell it will format it to capitals?
Cannot do this via formatting.
You can enforce CAPS by using Data Validation, but this would just make the
user have to re-key.
Either make sure Caps Lock is on or use event code in the worksheet.
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Not Target.Cells = Range("A1") Then Exit Sub
'for a column use this next line
' If Target.Column <> 1 Then Exit Sub
On Error GoTo ErrHandler
Application.EnableEvents = False
...Validates in XML Spy but generates errors in .Net
Hi. I have a simple schema which validates fine in XML Spy but in .Net
I get a Type Exception:
[The 'startDate' element has an invalid value according to its data
The effect I'm looking for is to be able to pass an empty date.
The Schema File:
<?xml version="1.0" encoding="utf-8"?>
<xs:element name="...Default Cell format of existing Worksheets got changed automatical
I am using MS Excel 2007. Most of my excel files saved with default cell
format as General while creation; currently for the last two days when i open
those files the cell content format is showing as currency format.
Pls let me how to fix the same
If you reference a cell that has a format (other then General), the
reference cell will adopt the same format.
"NGBalaji" <NGBalaji@discussions.microsoft.com> wrote in message
>I am using MS Excel 2007. Most o...SHFileOperation not working
This is what I have for deleting the contents of a folder
const wchar_t g_wsz_DriverBackupFolder = L"C:\\My Folder\\*
memset(&info, 0, sizeof(info));
info.wFunc = FO_DELETE;
info.fFlags = FOF_NOCONFIRMATION | FOF_SILENT;
info.pFrom = g_wsz_DriverBackupFolder;
if (0 != SHFileOperation(&info))
DWORD dwError = GetLastError();
It fails and GetLastError is 6: "Invalid Handle". What the fuck is
Offhand, I don't see anything serious here. You have three more \0s than you actually
ne...Wrap Text for Merged Cells
Can somebody post some good VBA macro for wrapping text in case of
merged cells (merged rows as well as merged colums or both merged rows
Lot has been posted in this regard till now but i could'nt find any
perfect solution to this.
If you've seen lots of code that has been posted, yet you don't say what
makes that code "not perfect", how do you expect anyone to respond to
your post? Should responders just guess what "perfect" means to you?
Try posting back with more information - what you've tried, why it
didn...Does SumIf work with a range?
I thought you could Sumif on a whole range, ie if A1 to A10 was your
criteria range, and B1 to D10 was the range from which to sumif.
However it only seems to sum what is in B1 to B10. Is that right?
I know I could use an array formula, but that might be a bit complex
for the recipient of the file.
(change the xxxx to gmail if mailing direct)
<firstname.lastname@example.org> wrote in message
>I thought you could Sumif on a whole range, ie if A1 to A10 was your...Printing Labels (Receipts) For Each Item On Work Order
I need to print labels containing Ship to Address, Item Look up Number and
description. Each Item Needs an Individual Label With All of This Information
and the Number of Labels Printed Should Reflect The Quantity From a Work
Order. I am attempting to do this as a receipt. I am looking at code from
existing receipts and trying to cut and paste what I need from diffrent
receipts into one that may suite my needs. I am no XML pro to say the least.
If anyone knows a better way or has more experience with XML and may wanna
help I would appreciate it!
...FRx export to Excel with formulas to work for XCR columns
The calculation column shows the wrong signs for revenue (normal balance =
"C") rows when you export to excel using formulas.
The issue is coming from the following setup in FRx:
1. The normal balance was set to “C” in the row format.
2. Print control that was set to use “XCR” in the column layout.
3. Including formulas when exporting to excel.
RESPONSE FROM MBS
We have found few bugs that were written regarding this issue. One of them
states that this is working as designed. The reason they gave is because you
should not include formulas when exporting to excel as it...How can I merge and purge two excel work sheets?
...Using Popups to select a range of cells.
I have a small request for help with code.
I need a macro to have popups request the first and last cells in a
range , and then to select them.
Can someone help?
Dim Rng As Range
On Error Resume Next
Set Rng = Application.InputBox("Select your range", _
On Error GoTo 0
If Rng Is Nothing Then Exit Sub
HTH. Best wishes Harald
"Colin Hayes" <Colin@chayes.demon.co.uk> wrote in message
> Hi All
>...TRY THIS. IT REALLY WORKS!
...change a work order to a sales invoice
I am a new user in RMS and I am working with my auto department. We are
working on oan older version of RMS (Pre 1.3). He primarily uses work orders
when he has a new order. Once the work is complete on the auto he needs to
bill it and take the items out of inventory. He is currently doing a
1) Processes the payment as a negative sale (an accounting nightmare)
2) Then he takes the WO number and does a sale refereing the number
3) Then he manually adjusts his inventory.
4) Because of the way he has processed them, the work orders remain open
until he has time ...Outlook 2003 rules, check messages after sending, not working
Since upgrading to Outlook 2003 (from 2000) we are experiencing problem
when using rules and sending messages from other applications (a
We have some rules defined that check messages after sending, dependin
on certain words in the subject, the message is moved to another folder
This works with no problems when sending messages via outlook but whe
sending (as attachment) with word, for example, the message does no
This worked with no problems in Outlook 2000. Also still occurs afte
SP2 installation. :(
Any advice would be appreciated
-------------------...Cell Number Format includeing other Cell Value
I needed to create some conditional number format - to say so...
Cell A1 content is "m2"
as I Enter in cell A2: "10" -> the output to cell A2 should be "10
Cell A1: "Dollars" -> A2: 200 -> shown "200 Dollars"...
and so on....
Is that possible in Excel? (don't know VBA - yet :DD)
Any help is appreciated!
How about just use a third cell:
=a2 & " " & a1
> I needed to create some conditional number format - to say so...
> M...combine cells #3
Hello, say you have Mindy in A1, Thomas in B1, how can you combine those in
C1 with a space between the names?
Mindy, here is one way,
=A1& " " & B1
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"Mindy" <Mindy@discussions.microsoft.com> wrote in message
> Hello, say you have Mindy in A1, Thomas in B1, how can you combine those
> i...Auto fill keeps adding 1 digit or 1 cell
When I try to drag a formula or value down or across the
spreadsheet in Excel 2002 (Win XP Professional)it
automatically adds 1 didgit to the value or references
the cell next door to calculate the formula. How can I
make the drag and autofill more accurate?
Try draggin with the right mouse button. When you get to the end of your
range you get a list of fill options.
"Ricardo" <email@example.com> wrote in message
> When I try to drag a formula or value down or across the
> spreadsheet...Office:mac 2004 and Tiger (OS X 10.4)
microsoft.public.mac.office and microsoft.public.mac.office.word.
Some years ago - although after the release of Tiger, OS X v10.4 in
April 2005 - I read in one of the microsoft.public.mac newsgroups a
posting from an MVP who was still using Office:mac 2004 with Panther,
in this case OS X v10.3.9, and that this was because Office:mac 2004
was developed on Jaguar, OS X v10.2 and only works 100 pct with OS X
up to v10.3.9.
I have been running Office:mac 2004 on a Powerbook FW800 with
Panther, OS X v10.3.9 and now want to...sum the color cells
i have data with different color.
i one column i have 3 color, blue, yellow and red.
now i want to count & sum based on the colors.
how to create formula for that?
you have xl07 or higher, you are suppose to have this capability already.
see help. i am having research trouble confirming that. if you have xl03 or
earlier, see this site....
> hi all.
> i have data with different color.
> i one column i have 3 color, blue, yellow and red.
...Merged Cells #5
Is there some way to find which cells are merged without having to look at
each cell? Sometimes I want to move or delete cells and it says" cannot move
part of merged cell" or something like that, but it does not show me which
cell is merged.
I am not aware of any inbuilt method for displaying merged cells.
One possibility would be to use a macro like the following which will select
(and therefore temporarily highlight) merged cells. As written, the macro
will select all merged cells in the selected range. If the selection
comprises a single cell, all merged cell...Possible to 'copy' cell data into another cell?
If for example
A1 contains: hello
B1 contains: you
Is there a equation/command to put in cell C1 to get it to copy info
from other cells i.e. so C1 shows: hello you
=a1 & " " & b1
If you decide you want money or dates, you can use something like:
> If for example
> A1 contains: hello
> B1 contains: you
> Is there a equation/command to put in cell C1 to get it to copy info
> from other cells i.e. so C1 shows: hello you
> ??????...how to make gaps in plotted data when cell has formula
I have a simple data set with a value for each month except June.
I want the chart to reflect a gap for June, not a zero value. Although I
did tools, options, chart, make empty cells plot as gaps, it still plots
the June value as a zero.
In an attempt to get rid of div/o error, I have a formula in the data set
as If (b5=0, "", c5/b5) . What I'm plotting is the quotient c/b.
We have determined that the formula is what is causing the problem.
Interestingly, if I open this same worksheet (as is) in quattro pro, the gap
appears in the chart.
Is there a different way to do th...Re: how get rid of cells with unused formulas
Actually a much older solution is better for suppressing zero values
selectively -- format with a custom format so that the third parameter
is empty which is a zero value. This allows you to be selective.
Format, cells, number
the fomat of custom formatting is
positive numbers; negative numbers; zero; text
you can override positive, negative but those are the defaults.
see the topic "Create a custom number format" in your Excel Help.
David McRitchie, Microsoft MVP - Excel [s...workflow suddenly doesn't work.
I've a big pb : 2 days ago, our wrokflow stopped to work. I don"t know why.
All workflows (automatic or on demand). I don't know at all what to do : what
do I have to check, to do. For info : we are with CRM4.
Any help would be so great.
Thanks to all
please check " Microsoft CRM Asynchronous Processing service" on CRM
server .if it is stopped or started?
Blog : http://mscrmsupport.wordpress.com/
...message comes up when click a cell
I have been trying to work out how to get a message to come up when you
click on a cell. I have attached an example of what I am trying to do,
which was in another spreadsheet which I had, but I didn't make it. I
noticed the feature and wondered how to do it? Thank you for your help
File Attached: http://www.exceltip.com/forum/attachment.php?postid=300547 (example.jpg)
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
use DATA/VALIDATION menu.
i think "Input...Excel Cell
Im trying to read an Excel file using OLE DB.
I have around 500 characters in one cell. But the program is reading only
How do i make my program to read all characters?
Thanks in advance.
hi, DNKMCA !
> Im trying to read an Excel file using OLE DB.
> I have around 500 characters in one cell. But the program is reading only 255 characters.
> How do i make my program to read all characters?
see if this help:
-> PRB: Transfer of Data from Jet 4.0LEDB Source Fails with Buffer Overflow Error