How to paste text into a comment box using toolbar commands
I have a range of cells containing text on one worksheet.
I want to paste this text into a Comment Box in a NEW worksheet.
Thanks for your help .....
"Halifax" <Halifax@discussions.microsoft.com> wrote in message
>I have a range of cells containing text on one worksheet.
> I want to paste this text into a Comment Box in a NEW worksheet.
> Thanks for your help .....
I don't see the problem. Copy the text, and in the new worksheet paste into
Asking a question?
Please tell us the version...Re-arranging table using pivot-table?
I have a worksheet with data organized somewhat like this:
New York New York
New York Albany
California Los Angeles
California San Diego
I need to convert this to a list of states and each city in the columns to
the right of their corresponding state. Something like this:
New York New York Albany
Florida Miami Orlando Tampa
California Los Angeles San Diego
Any help is greatly appreci...SignedXml gives false negatives when using namespaces in signed xm
It seems that digitally signing XML documents using the SignedXml class has
a bug - or at least a behavior I cannot explain.
The problem occurs when I sign XML documents containing namespace prefixes
and namespace references and then validate it. The validation always fails
(returns false) in this case. When I remove the namespace prefixes and
namespace references from the XML, signing and validating works fine.
It seems that the problem has been recognized in .NET framework 1.1 (see
http://support.microsoft.com/kb/888999/en-us), however I am using .NET 2.0,
and the problem...Gurus need your help on Centering AfxMessageBox using SetWindowsHookEx
I have a (Dialogbox with a button) which I open from the Menu which is
vertical shaped and docked at the left side.
I click this button on the dialogbox and AfxMessagebox is flashed which
is at the center of the dialogbox . In that way its flashing at the
left side. I call a App's DisplayMessage function in order to show this
messagebox. I though if I display this dialog from App , it may come at
the center but that is not the case.
I want this AfxMessageBox to be flashed at the center of the frame.
I read few postings here. I used following code using SetWindowsHookEx.
Somb...how to use STATIC control to display temperature in degree (oC)?
I want to use the Static control as a label to display temperature unit
in degree (that is oC). How to do that?
"kathy" <firstname.lastname@example.org> wrote in message
> I want to use the Static control as a label to display temperature unit
> in degree (that is oC). How to do that?
...XML Schema problem : "Validate failed because the document does not contain exactly one root node"
Well, I'm with a strange problem here...
I Have an Application in VC++ 6 and I need to load a XML file;This XML file
has a XDS Schema validating it. I'm using MSXml4.
Well, when I use the XML Spy with the two files, no problem , the XML file
So I go to the VC and try to load, using the DOM to do it...ok, I can load
and validate the file in both ways,
with the put_validateOnParse(I'm using raw_interfaces_only) and with the
So, I Modify the XML file, taking off one simple letter, eg. changing the
attribute name "Description" to "Desc...can you convert an excel document to a powerpoint doc,
i have an organizational chart in excel and need to convert it to powerpoint.
Is this possible.
"dolphin" <email@example.com> wrote in message
> i have an organizational chart in excel and need to convert it to
> Is this possible.
...Re-install Outlook 2002
I am trying to re-install Outlook 2002 for my palm pilot
after a crash. The installation will run until I get the
message - "another version is already installed and must
be uninstalled". The previous version was corrupt and I
was unable to uninstall it. Now when I go into the control
panel to add/remove the uninstall is no longer in the
...Outlook rules wizard replies using From field instead of Reply-To address
This is regarding Outlook 2007 and its rules wizard. We have a mail
folder with hundreds of emails that were sent on behalf of people. So
the "From" and "Reply-To" are different.
We created a rule so that we can reply to all of these people but the
rules wizard onto uses the From filed when it processes the messages
instead of the Reply-To field. This behavior only happens with the
rules wizard, we can go through each email, click reply, and get the
Reply-To address just fine.
I understand there was an article posted by Microsoft about this issue
however it was in 2003. I...Re-Enable CRM User
I am trying to enable a disabled CRM user and I received the following error
message. Any thoughts or suggestions would be greatly appreciated.
String UserId) +0
Microsoft.Crm.Application.Platform.SystemUser.Activate(String id) +38
sender, DataEventArgs e) +127
eventId, FormState state, User user, String objectId,...RE:Excel will not open from a web link
When opening a link on a web page that has an Excel
Spreadsheet embedded in it, the spreadsheet will not open
up Excel but opens within another browser as an Excel
file. Programming on webpage is correct, opens up on
other machines just fine.
...Thanks Ken Wright but one more question RE saving data from circular references
Thanks heaps for that macro Ken Wright .
I have run it and it works.
However it loops forever. Can I set it up so that it could save dat
from a certain number of iterations?
Thanks again Michae
Message posted from http://www.ExcelForum.com
If you stayed within your thread and did not change the subject
Ken would see your reply as a reply to his reply and would see
it a lot faster than when you start a new thread. Ken would
probably see your post highlighted in RED. Also someone other
than Ken might have been able to help you. (not me I avoid
anything that hints of circul...I need to go back to using my RR email address in RR
I switched my Road Runner email address to Outlook 2007. I no longer receive
my emails at RR. How can I switch my email delivery back to RR?
Call Road Runner support
Please Reply to Newsgroup for the benefit of others
Requests for assistance by email can not and will not be acknowledged.
"jmc112449" <firstname.lastname@example.org> wrote in message
>I switched my Road Runner email address to Outlook 2007. I no longer receive
> my emails at RR. ...Re: exmerge error
I am getting the following error when trying to use exmerg
can anyone please help
Microsoft Exchange Mailbox Merge Program, v4.00.02
Start Logging:February 27, 2004 20:04:3
[20:04:31] Logging Level: Non
[20:04:31] Reading settings from file 'C:\Program Files\Exchsrvr\BIN\EXMERGE.INI'
[20:04:32] Error 8007203a opening an LDAP connection. ('LDAP://EXCHANGE/rootDSE') (CADRoutines::GetNamingContextData
[20:04:32] Accessing Domain Controller 'PROFI...Using EAN barcodes
I am using SO 2.0 SP1. I need to setup some products with EAN13 barcode
format. We are contemplating to use GS1 registered barcodes.
I was wondering if anybody is using EAN barcodes and if there are any
"gotchas" I should look out for.
I would probably use a 12-digit product number, which would be good enough
for our purpose. Or is there any advantage to use a 13-digit number?
I also tried to print some EAN13 labels but did not find a template that
prints the item code right underneath the barcode, kind of embedded in the
barcode. Is that a special template that need to be us...Ron Bovey re: "Trim Selection" in ExcelUtilities
Cells in my Excel spreadsheet appear to be empty. However, when I use
Edit/Go To/Special/Blanks, I get "No cells were found".
In the past, Ron Bovey suggested going to the WWW.APPROS.COM website,
download ExcelUtilities and then use the "Trim Selection" utility to
remove the characters that are making the cells not empty.
Since then, I've gone to the WWW.APPROS.COM website and downloaded the
ASAP Utilities. However, I can seem to find the "Trim Selection" nor
any utility that will do the same thing.
Try going to Rob (not Ron) Bovey's site:
...Simply Identifying the location (in My Documents) of the Access Database that I have open
I am often working in an Access Database, and need to know in which
Folder the Database exists. In other Msft applications, I can find
out by simply selecting file > Save as. But in Access, this is not an
So is there another way to identify in which folder the Access
database is located?
"Dave K" <email@example.com> wrote in message
>I am often working in an Access Database, and need to know in which
> Folder the Databas...Outlook2003 tries to configure itself for using Visio2007 after each start
I have installed MS Office 2003. Now I have updated my Visio2003 with
Visio2007 from MSDNaa.
Everything works fine - but I have one annoying issue:
After each start of Outlook2003, a dialog appears that wants to
configure Outlook for using Visio2007.
After this configuration I have to reboot my computer.
When I now restart Outlook, the same procedure happens again. This
occurs always, when I start Outlook.
Is there any possibility to shut off the integrity between Visio and
...How do I get invisible lines & borders to re-appear?
In Publisher 2003, table grid lines, text box borders and autoshape borders
have become invisible on-screen, although they do print out. Any ideas on how
to remedy this?
Recently installed Adobe PDF Maker which seems to have precipitated this,
although it could be entirely co-incidental.
Try updating your video drivers.
MVP Microsoft [Publisher]
"Ackerman & Co" <Ackerman & Co@discussions.microsoft.com> wrote in message
> In Publisher 2003, table grid lines, text box borders and auto...How do you create resouces to be used
This is a multi-part message in MIME format.
I was told that you can create resources (conference room) to be used =
for scheduling. How is this done? Do you lose mailboxes?
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META h...How to use Live Messenger Web Toolkit to register domain
Hello, i downloaded Live Messenger Web Toolkit sample from here :
And i want to just test it, not put it in production. I tried to register
application with one of my live application domain(http://quiz.it.msn.com/),
but I get error: "Domain does not exist"
can you please advice how to get rid of this error....will really
appreiciate any immediate reply...
...re re re ????
...Scratch that, using a filter did not work
I wrote too soon. you can't paste multiple sectors using a filter back to sq 1
You have replies at your first post.
It's better to stay within the same thread.
> I wrote too soon. you can't paste multiple sectors using a filter back to sq 1
I figured this out after I posted the 3rd note, sorry!
"Dave Peterson" wrote:
> You have replies at your first post.
> It's better to stay within the same thread.
> Ben wrote:
> > I wrot...Animation Using Visio & VBA
I'd like to move an icon (named shIcon) from point A to B, and I can do so by
adding in a 1-second delay between moves. The way I've done it is:
dx = 0.1 * (xLoc - .Cells("pinX"))
dy = 0.1 * (yLoc - .Cells("pinY"))
For i = 1 To 10
dt1 = Now + 1 / 86400
' Next 3 lines create a 1-second delay (not the best way to do it, but it
Do Until Now >= dt1
dx = dx
.Cells("pinX") = .Cells("pinX") + dx
.Cells("pinY") = .Cells("pinY") + dy
End ...using ms access as database in windows appplication
i gets " unspecified error" when i inserts new data to database and when i
fetches the data from access database is it the problem from access
No one here can see your monitor....
Please provide Windows version, Access version and what you are doing at the
time of the error (ie. opening a form, running a query, etc...). Posting
that information increases your odds of getting assistance.
"I feel I have been denied critical, need to know, information!" - Tremors
"access error" <access firstname.lastname@example.org> ...