Cell Border Line Width
Is it possible to specify the cell border line width using Excel 2002?
The "Border" tab in the "Format Cells" dialog box allows me to choose
predefined line widths but I need a width other than what is offered.
Is there a way to do this?
Not with the borders property...you are restricted to xlHairline,
xlThin, xlMedium, xlThick".......
You could *possibly* fake it with the AddLines method of the worksheet
but I wouldn't really want to try.....;o)
I have a main costing work sheet that needs to be populated by individual
costing sheets that went out to all of the buyers to populate.
Main Costing Sheet
A. Item # B.Desc C. QTY D. Cost E.....F.........G......H (all
contain irrelevant information to costing activity.
There are 5 buyers (Nick, Tanya, Doug, Skip and Forrest) that I have divided
up the main costing sheet and sent them thier individual items to cost, now
that I am getting the individual costs back, I need to populate my "Main
Costing Sheet" with each cost, however, the items are all to...Cannot change line/object color in Publisher 2002
Anyone who can help:
I'm using an older version of Publisher (2002). I was working on a floor
plan for a project when suddenly, all the lines and borders disappeared. I
am now unable to make any selection to change the line color--the selection
defaults to a blank option no matter what color I choose, creating
essentially invisible objects and lines in my files, even new ones.
I uninstalled and reinstalled Publisher twice to no effect--the problem
persists. (Interestingly, the same files when opened in Publisher 2002 on
another machine display fine.)
Is there something else that co...Transfer data from XML to Stream?
I have a COM component that receives XML documents from MSMQ. Before I
process the final documents and pass it to my application, I want to modify
the format a bit, as in create a name/value pair structure from an element
structure or rename certain fields. I'm using XmlTextReader to read over
the original doc and I'm using XmlTextWriter to create a new XML file that I
essentially need to load up again into an XMLDocument object.
I'd rather write the modified XML to a stream local to my running instance
of the COM component rather than create another physical file then ...Change line to bar in Line
Hope someone can help on this one...I have 4 data series that I am trying to
plot on a Line-Column chart. I need 3 of these to be columns and one to be a
line. It is defaulting to 2 columns and 2 lines.
Does anyone know how to override that default, so I can change the one line
(basically the 3rd data series) to a column?
Select the series you want to change, then on the Chart menu, choose Chart
Type, and choose the new type to assign to that series.
Next time, starting from scratch, make a column chart with all four series,
then change the one to a line.
Jo...Toggle Data Label "Value" On and Off
Is there any way to toggle the "Value" label for a chart on and off
using a button linked to some VBA code. I'd like to be able to have
the label formatted (i.e. color, size, etc) so that the user just has
to click a button for the values to show on the bars of the chart.
Thanks for any help you can give!
Found my own answer through recording macros. Here is the code I used,
applying it to a toggle button.
Private Sub ToggleButton1_Click()
Application.ScreenUpdating = False
If ToggleButton1.VALUE = True Then
ActiveSheet.ChartObjects("Chart 1").Ac...25 changes to 35
When the value of 25 is entered into a cell, the screen returns the value of
I have scanned for viruses, tracking software, defalt setup values,
uninstalled an reinstalled excell, updated, etc. Still I get a value of 35
when I enter 25.
Check Tools>AutoCorrect Options and see if someone is playing a trick on
"David Sound Tech" <David Sound Tech@discussions.microsoft.com> wrote in
> When the value of 25 is entered into a cell, the screen returns the value
&...Exchange 2000 data store size does not shrink
We have an exchage 2k store that is ~16GB. We have archived ~ 5GB (PST
files)and did an offline defrag but the db has shrunk by less than 2%.
Currently it will not mount even with the evn when we set the temp size
increase registry switch. Any ideas?
KCHobson <KCHobson@discussions.microsoft.com> typed:
> We have an exchage 2k store that is ~16GB. We have archived ~ 5GB
> (PST files)and did an offline defrag but the db has shrunk by less
> than 2%. Currently it will not mount even with the ...Is this program good for labels??
I was just wondering which microsoft program is the fastest and most
compatable for making many, many labels at one time, Word, Excel, or
Publisher? If anyone would like to help me through this it would be greatly
appreciated. Thanks Again.
Message posted via OfficeKB.com
A lot depends on what is the format of the label sheet or if it's pinfeed,
the text formatting and if there are any graphics. What is the format of the
data at this time? Personally I prefer Publisher.
"Kelsey P via OfficeKB.com" <...Copy a word doc to excel and hyperlink data between the 2.
I have a chart on an excel document and a long word document explaining the
data in the chart. I would like to place the word document under the chart in
excel. Then I would like to hyperlink the data from the chart to specific
places in the word document. Help.....I have been trying to figure it out for
days. Thank you.
...Off the chart Graph labels, that don't show up?
I have am using a bar graph and one bar is off the scale. In the 2003
version of excel the label for that bar becomes invisible, in older versions
I could just move the label down so that it can be seen.
I can click on the label and if I highlight it i can see the number, but I
cannot get it to show on the graph.
Has anyone run into this problem?
You could add a series to hold a label within the chart:
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
"Dawn&q...Need to extract data mid-string.
Here's what I have: \\lavaur4\PHIWEBEurope\SWAN_Swissco\Default.htm: 754And here's what I'm trying to get back: Swissco\Default.htmThe number of characters from the left will always be the same, 28. And thestring will always be trimmed after the ":" (colon). I'm struggling with how to use mid, left, right to get out what I need. Thanks in advance!Kellie-- Message posted via http://www.accessmonster.com On Mon, 26 Mar 2007 21:19:27 GMT, KFox via AccessMonster.com wrote:> Here's what I have: \\lavaur4\PHIWEBEurope\SWAN_Swissco\Default.htm: 754> And here&...Changing Depre Life
I have a number of fixed assets that I need to extend the life. Their in
service date was in the prior fiscal year. If I go to the Asset Book screen
& change the life, <save> the screen & choose "Year" as the reset option (not
Life or Recalculate), shouldn't I get some financial entries reflecting the
current year adjustment of depreciation?
I tried it in the test company & I'm not getting any GL entries. Any help
You have to run the GL Posting Routine at Tools>Routines>Fixed Assets
to generate the GL entry.
Fr...About worksheet change event.
I wrote a code and somewhere, I want to restrict any changes with multiple
cell selections, "except" adding a whole row by right-clicking on the row
number bar. How can i do this?
Maybe you could test like this
If Target.Rows.Count = 1 And Target.Count = Rows.Count Then
(remove nothere from the email address if mailing direct)
"serdar" <firstname.lastname@example.org> wrote in message
> I wrote a code and somewhere, I want to restrict any changes with multiple
> cell selections, "except"...Re: Data Summary
Can we do the summary by defining a macro?
The difficulty with the suggested solution :
1.I am not able to advance filter the unique data to a separate
2.Every day the data gets changed, so have to repeat the exercise
daily and is very time consuming.
Subject: Re: Data Summary
From: "Ardus Petus" <email@example.com>
In summary sheet, you can get the totals with a formula like:
See example: http://cjoint.com/?fmkJhzVi8q
To automate the production of ...Randowm data corruption Money 2002
I use Money 2002 Deluxe & Business to manage 6 business
bank accounts and 2 petty cash accounts. All of a sudden,
Money has started to randomly change some of the entries
in the petty cash accounts. It changes them in increments
of $50, $100, $150 or $200. For example, one entry that
was originally $200 on Jan 1, now reads $400. One on
2/2/04 for $70.40 now reads $170.40. Conversely, on 4/17,
the amount was $800 and it is $600!
There are some 20 such changes that I have detected so
far. I am the only one using this program. I can't see
any pattern to the changes (payee, ...Pulling Data from one worksheet into another
I have a question regarding pulling text from one worksheet into another.
Please can you help me?
I need to duplicate the information (text only) on one worksheet to another
one as it is typed. Is there a formula I can use that will allow the data
typed in one worksheet to appear in the other one immediatley?
I have a formula that the person before was using but I don't know how to
apply it to the whole sheet. Any advice would be greatly appreciated.
The formula is =IF(ISBLANK(OFFSET(OFFSET('Design
Schedule'!$B$8,$A15,$B15),0,H$7)),"",OFFSET(OFFSET(&...Excel 97 on Windows XP data sort error
I have had sorting errors using Excel 97 running on
Windows XP. Is there a fix for this? I check Excel
updates and the microsoft website says I already have all
Please tell what sort of errors.
"Steve P" <firstname.lastname@example.org> wrote in message
> I have had sorting errors using Excel 97 running on
> Windows XP. Is there a fix for this? I check Excel
> updates and the microsoft website says I already have all
Sort errors are almost always data problems. You might have numeri...Change the default Calendar
Hej to all
I have outlook 2010 with 2 calendars, calendar and work. By default the
default calendar is calendar, but I would like to be work, since calendar
have almost my private things, there is a way to change the default calendar
Thanks to all.
No, you'll have to copy over the items from one to the other.
Personally I don't use 2 calendars for this but use a single calendar and
categorize my appointments accordingly.
For details see;
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft...Collect data for a SQL Server DB via Infopath
Can anyone direct me toward information that discusses using InfoPath forms
as a means to capture data for a SQLServer database?
**please reply to the newsgroup so others may benefit**
"David C. Holley" <David.C.Holley> wrote in message
> Can anyone direct me toward information that discusses using InfoPath
> as a means to capture data for a SQLServer database?
...Publisher mailmerge error message, invalid office data source
I am trying to edit a mailmerge database I started in publisher, but I keep
getting an error message, "This is not a valid office data source". But it
was just fine earlier.
Are you creating the list in Publisher? What version Publisher? Look in "My
Documents", "My Data Sources", is your data base there?
Is there a number associated with your error?
Mary Sauer MSFT MVP
"Obrother" <Obrother@discussions.microsoft.com> wrote in message
news:31B77242-6579-4B64-9...How do I eliminate duplicate values in a series of data in excel?
In article <67F30DC1-DA2D-4144-8C9A-99793AD92302@microsoft.com>,
"dparker" <email@example.com> wrote:
...Change the name of an auto save
I am trying to write a macro that will save the file to a specific cell
reference. The reference is a specific name that is automatically generated
by another macro function.
Any suggestions on how I could do this?
IS thsi what you want?
sFilename = Format(Worksheets("Sheet1").Range("A1").Value)
ans = MsgBox("Save file as " & sFilename)
If ans = vbOK Then
If this information was helpful, please indicate this by clicking ''Y...Data type mismatch
New to Access 2007
I'm putting together a database. One of the fields is test scores which
have a value of 0 through 100 OR "ND". They aren't willing to get rid of the
"ND", so I have the field set to "Text".
Is there a way to create a validation rule that limits input to these
values? A combo box with 100+ values seems awkward.
Between 0 and 100 OR "ND" but I got a type mismatch error.
This worked in Access 2003 as the validation rule for the control:
="ND" Or (>=0 And <=100)
For...Auto date changing in Excel is maddening
I'm using MS Office Excel 2003 (11.6113.5703) to post data that spans over
or try http://tinyurl.com/6f8zn
We had to jump through all kinds of work-arounds in order to accomplish
this. It was not a straight-forward process, though it should have been.
When I enter the date format, for example, as
Format > Time > 3/14/01 13:30
And then enter 11/17/04 0:30:30, it enters okay, but when I double click on
the cell to edit it, Ex...