Reply:

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 question
I 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 question
Hi 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 question
I 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...

Question
Why 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 #16
Hello 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 Question
Greetings, 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 questions
I 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 Question
All, 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 #3
Hi. 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 question
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 "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 #2
Usually 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 coding
I 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 question
I 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 command
Hello, 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 Question
Hi. 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 question
Hi, 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 pack
Hi @ 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 migration
Hi 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 question
Which 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 question
except 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 question
Hi! 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 questions
I 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...