Question about Paste Special
Hi, I have a problem sometimes with the paste special options when goin
from one excel workbook to another. For example, sometimes when I cop
data from one workbook and then paste special into another, I get th
options that include: All, formulas, values, formats, has the option t
transpose the data and paste link among other options. And the
sometimes I try and paste data to another workbook and I end up th
paste special options: Bitmap Image Object, picture, bitmap, and I als
lose the ability to paste link. Well you can do it, but it puts it i
as an object.
What I want is the first past...
IE8 privacy questionI am running XP-Pro SP3 and considering upgrading from IE7 to IE8.
I have read all the feature and benefit articles from MS, but have one
question that remains unanswered.
In IE8 there is mention of being able to restore previously viewed websites
or something to that effect. I think this is on a drop down menu somewhere.
1) Does In-private viewing prevent this?
2) Does manually deleting your complete browsing history clear this?
3) Is there a registry entry that can prevent this action?
4) Is there a group policy change that can prevent this action?
In essence for privacy pur...
IF AND questionHi there,
I need a function that can provide one of three answers:
1 2 1 1...
3 3 4 4...
? ? ? ?...
If A1 = 1 and A2=3, answer 106; but if A1=1 and A2 = 4, answer 104; but if
A1=2, regardless of A2, answer 95.
The next function for column B is the same, except the answer is dependent
on the value delivered from the column A function. E.g. A3 + 6 or A3 +4 or
A3-5 etc.
Any help would be most appreciated.
--
*****
Many thanks
Gamq
Use the below formula for your first query.
=IF(A1="","",IF(A1=2,95,IF(AND(A1=1,A2=3),106,IF(AND(A1=1,A2=4),104))))
...
Microsoft Query questionI am trying to use Microsoft Query to get data from my SQL 2000 databases.
The problem is that I have a few columns with names that conflict with
keywords (like Identity). (Yes. I kow that keywords should be avoided but it
is done and cannot be changed.) This is causing a keyword syntax error
within the Query application.
Oddly enough, even if I do not select the column the error still appears.
And when you look at all the columns available, the keyword named column
shows up in boldface.
When I am doing queries in other programs I put square ("[ ]") brackets
around column and table...
QuestionWhy did the chicken cross the road?
--
Dr. Stephen Hopkins, MD
"Dr. Stephen Hopkins, MD" <DrStephenHopkinsMD@discussions.microsoft.com>
wrote in message news:B8434E21-DDA3-44D7-B39B-CD5A8C33A7BD@microsoft.com...
> Why did the chicken cross the road?
> --
> Dr. Stephen Hopkins, MD
To collect her email, why else?
Dr?
You should be ashamed to put such a title on an idiotic off topic post !!
--
Regards Steve.
MS-MVP. MAIL. [DTS] UK.
http://www.getsafeonline.org/
mac;1266180 Wrote:
> "Dr. Stephen Hopkins, MD" <DrSte...
OWA Question #16Hello All:
Quick Question regarding OWA. We are about to finalize migration from 5.5 to
2003. We have an existing web presence already in DNS a www.mydomain.com.
and running on existing web servers. With 5.5 natrually, to access OWA, it
was www.mydomain.com/exchange.
This will not be possible now since OWA runs off of the Exchange server
instead of relying on our web server under 5.5. What's the easiest way to
overcome this.
Thanks
If you can afford the extra license, you'll probably want to run a front-end
server so no one is connecting directly to the Exchange database s...
Text Box QuestionGreetings,
I have been using Visio for years, however, something has happened and I
can't figure out how to undo it. Basically up until today when I added a
text box and entered text, the text went horizontal as it was typed. Today
when I add a text box and enter text, the text goes vertical. How do I get
back to the old behavior?
TIA
using text container shape adjusting tool (text block tool), make the text
container shape wider horizontally.
Have you used Asian text font recently?...check help for "vertical text"
"Ray Batig" wrote:
> Greetings,
>
&g...
401K questionsI just started a 401K at work and I'm wondering how to deal with it in Money.
I've got my paycheck split into different categories currently and now I
have to put the 401K amount into a category as well. I didn't see one
specifically for this. What do other people use?
Should I start using the 401K Manager? I haven't gone through it yet I'm
just wondering if it works well and how much benefit I'll get from it.
Thanks in advance!
Mike
You will want to create an investment account for the 401(k) and TRANSFER
your contributions from your checking account to the...
VBA//Oracle Interfacing QuestionAll,
I have been able to correct to my database but I have one question
question:
Within objSession I want to list all available tables and all
available views.
How exactly is this done?
thank you.
Set objSession = CreateObject("OracleInProcServer.XOraSession")
Set objDatabase = objSession.OpenDatabase("", "User/Pass", 0)
On Nov 16, 12:05=A0pm, jason <jason.mell...@gmail.com> wrote:
> All,
>
> I have been able to correct to my database but I have one question
> question:
>
> Within objSession I want to list all avail...
Sorting Question #3Hi.
When I sort a selection by a column that contains blanks the rows with
blanks always sort to the end regardless whether I set ascending or
descending. Is there anyway to reverse this?
Selection.Sort Key1:=Range("B11"), Order1:=xlAscending, Key2:=Range("M11"
_
), Order2:=xlAscending, Header:=xlGuess, OrderCustom:=1, MatchCase:=
_
False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal,
DataOption2 _
:=xlSortTextAsNumbers
Column B contains a either 'X' or ''
Column M contains a number
and I want the rows with an 'X...
netstat questionHi,
When i use netstat -an in the row "remote IP" appears:
0.0.0.0 and
":"
What is this ?
What mean this?
Thanks and excuse my Inglish,
ZIDAC
"ZIDAC" <ZIDAC@discussions.microsoft.com> wrote in message
news:F7F0F753-F992-4839-A5C1-EF86700EBC28@microsoft.com...
> Hi,
>
> When i use netstat -an in the row "remote IP" appears:
>
> 0.0.0.0 and
> ":"
>
> What is this ?
> What mean this?
>
> Thanks and excuse my Inglish,
> ZIDAC
>
Basically, the ":" is IPv6,...
Hyperlink question?I'm working with an excel spreadsheet (duh, or else I wouldn't be here).
I've set up a few hyperlkinks to related files. However when I click on the
hyperlink it opens the directrory in explorer and not the actual file. I'm
using excel 2000 if that helps anything. Anyone have any info?
Tnx,
Dusty
Can you give an example of what you want to have in the hyperlink?
Let's say the file is in folder
C:\Documents and Settings\All Users\Documents\My Pictures\Sample Pictures
and the name is Sunset.jpeg
A1 = C:\Documents and Settings\All Users\Documents\My Pictures\Sample
...
Filtering question #2Usually when a filter is on and the data is filtered, in the bottom left hand corner of the screen it will provide you with the number of records found. For example, it may say that the filter applied produced "23 of 391 records found". If this function stops working does anyone know how to turn it back on? Thanks!
IL y a des cas connus o� cela se produit, une solution �tant de passer en
calcul manuel au lieu de automatique. (dans les options de calcul)
Attention, cela signifie que lorsqu'une cellule est modifi�e, les autres ne
se mettent plus � jour tout de suite mais qu'...
Questions concerning VBA codingI recently created a new macro that copies a sheet named Template and changes
the name according to the result of cell K2, and then deletes cell K2 in the
new sheet. K2 contains the formula...
=TEXT(TODAY(),"mm-dd-yyyy")&" ;
"&TEXT(YEAR(TODAY()),"yy")&TEXT(TODAY()-DATE(YEAR(TODAY()),1,0),"###")
it outputs something like "12-19-2005 ; 05353"
and the code is
Sub Copy_Template()
Sheets("Template").Copy Before:=Sheets("Template")
Sheets("Template (2)").Name = Cells(2, 11)
Range("K2&...
Msft. Money 2000 checkwriting questionI am using Microsoft Money 2000, vsn. 8. Whenever I write a new check
in the
checkwriting feature, the PAYEE is automatically entered into a PAY TO
list that
enables me to write future checks to the same payee by scrolling to
the name & highlighting it.
This is a useful feature, but there is a drawback in that some checks
are never written a second time to the same payee and the number of
payees listed in the PAY TO list is getting longer & longer.
My question, therefore, is: is it possible to edit the PAY TO list
and delete
names of some payees?
If so, how is it done?
All repli...
NetStat commandHello,
Does anyone know where we can find some sample source code
that implements the network command "netstat" on Windows NT?
Hopefully, the source code is free. But, we will pay for the source
code if necessary.
Our development environment is VC++6.0 SP5 on Windows NT.
Thanks,
Jacques
Hello Jacques,
Thanks for posting in the group.
I don't think there is any source code of this command. The command should
use a lot of SDK functions. Which type of information do you need?
Here I am glad to introduce some useful links for your reference:
http://www.codeguru.com/intern...
Number QuestionHi. I'm using Excel 2007. I have a row with a cell that contains a number,
say 4444. I want to select this number and drag down so the following cells
below this row and cell with a number with appear as 4444.1, the next row and
cell below this as 4444.2, ... 4444.10, 4444.11, and so on, by dragging down
the mouse. Can this be done? And how should I format the column? As a
number, as general, as ...? I tried holding down the Ctrl key, or the Alt
key, but the result was: 4444.1, 4445.1, etc.
If I format the column as a number, when I resort, the problem appears after
4444.10, bec...
CreateElement questionHi,
I am trying to add an XmlElement to my XML file:
XmlDocument aDoc = new Xml Document();
aDoc.Load("MyFile.xml");
XmlElement el = aDoc.CreateElement("Cim:Attr");
When I append this element to a node, the name of element is "Attr" only.
How can I add an XmlElement and recieve the full name (Cim:Attr) ?
Yoav.
Yoavo wrote:
> I am trying to add an XmlElement to my XML file:
> XmlDocument aDoc = new Xml Document();
> aDoc.Load("MyFile.xml");
> XmlElement el = aDoc.CreateElement("Cim:Attr");
>
> When I append this eleme...
Question about the feature packHi @ all.
If I install the KB833621 and KB873262 (feature pack - server components) on
the server but not the KB833621 on the client, will the synchronisation work?
thx
...
Question About PF migrationHi All,
I want to migrate PF from Exchange 5.5 to Exchange 2003. I saw that using
the PFMIGRATE utility I can create replica on the destenation server, but I
can't define which folders I want (I can only define the number of folders)
Is there any utility / script that I can use to define list of folders?
Thanks,
Nir B
Greetings Nir
We cannt use PFmigrate to do a selective replication but what can be done is
the contect replication of selective PF using if its an intra-org pf
migration by simply useing Exchange System Manager and right-click the PF
you want to replicate and on the...
Off topic questionWhich newsgroup should I subscribe to ask questions about newsgroups?
What sorts of questions? About the groups themselves? About Usenet? About
newsreaders such as Outlook Express (which I see you're using)?
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org
"Jim Birke .com>" <jimbir@yahoo<notthis> wrote in message
news:eELhwFfqKHA.728@TK2MSFTNGP04.phx.gbl...
> Which newsgroup should I subscribe to ask questions about newsgroups?
>
>
I am subscribed to several newsgroups in msn...
XSL Question #5<xsl:if test="fTOC[starts-with(@filename, '5')]">
<xsl:element name="Section1">
<xsl:attribute name="titleRef">Section 1 - Section
One</xsl:attribute>
<xsl:for-each select="fTOC[starts-with(@filename, '5')]">
<xsl:copy-of select="."/>
</xsl:for-each>
</xsl:element>
</xsl:if>
I am going through a list of files starting with '5' and placing them under
"Section 1 - Se...
ot questionexcept for being something i need to do in an mfc app i'm working on this
doesn't really have anything to do with mfc.... but its as bad a place to
start as any other group i watch. i need a kind of generic algorithm to
take an array of 3d points that describe a surface, then given two
coordinates of another point interpolate the third coordinate on the
surface. picture it like you have a set of random latitude, longitude and
elevation points, then want to find the elevation of any given latitude and
longitude coordinate. (over a small area, don't worry about spherical earth
and...
focus questionHi!
I am developing an application for specific pda... i need to create a
Software Input Panel(normally its implemented in win ce but the oem
excluded it from the system)...
the problem is as follows:
The software keyboard is in a separate child window... no i need to be
able to keep the caret on its place(on a selected editbox for example)
while pressing buttons on the keyboard.
Please help :)
Another question is, what message do i have to send to the application
in order to put/send a character to an editbox(specified by the caret).
Thanx.
climax! wrote:
> Hi!
>
> I am developi...
2 questionsI have two Excel charting questions:
1. Can you make the x axis display on the right side of the chart instead of
the left? (and no, the "...crosses at maximum value" checkbox does not make
it do this)
2. Can you create an overlay chart with an additional axis with both data
series being instacked bar format? I can create on with stacked bar and
line, but not two stacked bar ones...they just stack on top instead of being
two seperate ones.
> 1. Can you make the x axis display on the right side of the chart instead
> of
> the left? (and no, the "...crosses a...