Which Endian routine is better?
I am converting big endian to little endian and have written these two
Function Endian32_UsingString(ByVal n As Long) As Long
Dim s As String
Dim d As String
Dim i As Integer
s = Right$("0000000" & Hex$(n), 8)
For i = 1 To 7 Step 2
d = Mid$(s, i, 2) & d
Endian32_UsingString = CLng("&H" & d)
Function Endian32_UsingByteArray(ByVal n As Long) As Long
Dim big(3) As Byte
Dim little(3) As Byte
CopyMemory big(0), n,...any method of keyboard remapping?
Any method of keyboard remapping In Excel?
What do you want to do? "remapping" is a loose term. HTH Otto
"Ron" <Ron@discussions.microsoft.com> wrote in message
> Any method of keyboard remapping In Excel?
> Any method of keyboard remapping In Excel?
The only way I'm aware of is by assigning short-cut keys to macros.
However, a Windows keyboard remapper utility may help you. Do a Go...Help with SQL syntax wanted
I have a view like this:
ParentNodeTitle | ChildNodeID | ChildNodeType
'District A' | 1001 | 'Estate'
'District A' | 1002 | 'Estate'
'District A' | 1003 | 'Estate'
'Supervisor A' | 1001 | 'Estate'
'Supervisor A' | 1002 | 'Estate'
'Supervisor B' | 1003 | 'Estate'
I need help with creating the most efficient SQL statement to return
all distinct ChildNodeID where ParentNodeTitle = 'District A' and
ChildNodeType = 'Estate' and ParentNodeTitle = 'Supervisor A' and
C...I want to display a graph vertically
Hello, I have a problem with displaying a graph in excel. It seems like
the default way of displaying a graph is from left to right, that is,
the longer part stretches out to the right. On my graph, dates are on
the left (vertically) and an other factor is on the right
(horisontally). I want the dates tp be horisontally and the other
factor vertically, and the curve/graph should go from top to bottom,
like a waterfall if that better explains it. That is, I would like to
rotate the graph, but not by saving the graph as a gif-file and rotate
it in Visio for instance, but as a real excel-graph, ...Keyboard Shortcut in Macro
i'v created macro with Keyboard Shortcut Ctrl+b . now i want to change it to
how can i do it .
Tools-->Macro-->Macros. Select (don't open!) your macro, and hit the Options
Hope it helps!
"osaka78" <firstname.lastname@example.org> wrote in message
> Hi all
> i'v created macro with Keyboard Shortcut Ctrl+b . now i want to change it
> how can i do it .
THE MACRO IS NO...Wanted vb.net trainer -hyderabad location
We are in need of a vb.net trainer urgently for hyderabad
location..pls forward ur resumes to email@example.com
Meghana IT Solutions
"Meghana" <firstname.lastname@example.org> wrote in message
> We are in need of a vb.net trainer
And the best place to find one, in your considered opinion, is in a
peer-to-peer newsgroup dedicated to C#...?
Sounds like a VB.NET trainer is the least of your requirements...
http...Is there a better way?
OK, I have an application that controls some devices through the serial
ports. I use worker threads to actualy handle the serial ports and it works
well. On one of the threads I need to perform several different sequences at
varying times during the program execution and I have been using volatile
bool variables to "trigger" these sequences and posting messages to get
responses. This scheme works but it seems ackward at best. Is there a better
way to "trigger" actions inside a worker thread and get a response?
x-- 100 Proof News - http://www.100ProofNews.com
x...Want Excel fractions to print like Word fractions
Word prints 1/2 in one character, not three like in Excel. Is there a way I can treat the 1/2 as text and get one character position?
You can insert that by holding down the Alt key while typing 0189 on the
release the Alt key. However you can't use it in any calculations since it
is a text character
For everyone's benefit keep the discussion in the newsgroup.
"CaroleO" <email@example.com> wrote in message
> Word prints 1/2 in one character, not ...Which is better Event or Mutex ???
I have a program in which I have two threads which start executing from the
time application starts execution till the time application quits (Before
quit the child thread is killed). Both the threads needs to notify each
other before they access a resource in my case its USB port.
As far as I think Event is idle to be used in this scenario. I wanted to
know whether is it or not.
Which is the better Event or Mutex ????
Thanks for your response.
"Amar Kumar" <firstname.lastname@example.org> wrote in message
I am looking to fill an entry level position within our company. We
are a managed services provider in Dallas and have an immediate need
for an entry level technician. If you know anyone who has some basic
technical knowledge or aptitude and a willingness to learn, please
forward this posting to them. I am primarily looking for someone who
is capable and willing to learn more so than someone who has a lot of
training and/or experience. This is an entry level position, but there
will be a lot of opportunity for training and advancement. This
position is full-time (contract to hire) and is avail...Microsoft far better than Google
...keyboard shortcuts #6
Is there a keystroke which is the equivalent of a mouse click?
in which case do you want to use this?
"dave" <email@example.com> schrieb im Newsbeitrag
> Is there a keystroke which is the equivalent of a mouse click?
at the moment I'm just formatting a cell with a right border, and I can use the keyboard to get me to the highlighted button within the border tab of the format window, but then I have to mouse click. I know that if you're select...A better filter??? Where?
I use Outlook 2000 against an Exchange filter.
I have to have a white list, so I try to not have any filters on Exchange.
My trouble is that my filters don't do me any good. I keep getting undeleted
messages in my delete box that trigger my "You've got mail" envelope, so I have
to maximize Outlook to see if I have e-mail. The envelope then won't go away
until I either mark all my messages to read (which means moving to "deleted"
where I see my latest message), or read an unread message.
I don't have authority to upgrade Outlook nor to upgrade the compa...what is the keyboard combination for format painter?
Could someone help please?
I cant find keyboard shortcut combination for format painter.
Rhere is no shortcut for the format painter, of course one could use several
keypresses through alt + e + s + t + enter
but I suspect that is not what you want. You can create a macro with a
shortcut that will do it
"Volkan" <Volkan@discussions.microsoft.com> wrote in message
> Could someone help please?
> I cant find keyboard shortcut combination for format painter.
...Which is better ?
Which way is better....
Running mail through a AV gateway then to the mail server or having a mail
store scanner that scans all incoming messages before releasing to mailboxes
Any greater benefit to of one over the other ???
Any benefit to running both simultaneously so mail would 1st be scanned at
the gateway then scanned again before released to mailbox ???
Both of these solutions would be software.
"_M_" <firstname.lastname@example.org> wrote:
>Which way is better....
>Running mail through a AV gateway then to the mail server or having a mail
>store scanner ...Better reports
I want to see my sales by department, or maybe even by
department and then by supplier. I also need to see what
i've sold and what i've received. Does anyone have any
better reports than what is in rms?
We have a fantastic reporting tool. We have a new excel
OLAP product that lets you slice and dice your data in
Microsoft Excel. You can view sales, po's, current on
hand, ect. by departments, suppliers, categories. We
have a report that shows current on hand, received to
date, outstanding on po's and what you've sold all in
one. You can...Outlook 2003 is better than I thought
Is this the latest version?
At first I wanted to stay with Eudora but after using this I can understand
why Eudora is no longer beign sold in stores. Although it was my first pop3
client, Outlook 2003 is many times better. However I do miss Pure Voice.
But most did not use this, and most will not (because of the advent of cell
phones). But then again Pure Voice was nice for sending voice mails to
Do not store up for yourselves treasures on earth,
where moth and rust destroy, and where thieves break
in and steal. But store up for yourselves treasures in heave...move/slide row with keyboard
I would like to move/slide a row with the keyboard. I know the shift
+drag edge trick with the mouse to move rows (without replacing the
destination), but I would like a quick way to do with keyboard. MS
Word has a nice feature shift+alt+up/down to do this thing, but I have
not found one with Excel.
If an existing solution does not exist, is it possible to have a macro
A slight typo if the OP is to get it to work.
He needs to press Ctrl+Shift+m to invoke the macro
You used a shortcut of Ctrl+M, not Ctrl+m
"Shane Devenshire" <shanede...I want to match and insert info on 2 different sheets
Really embarassing newbie question:
I have two sheets of data, both sheet have a common identifier "school
code". One sheet has some results (numbers) for each school code that
I'd like to match to the school codes on the other sheet. I can't seem
to figure it out using "MATCH" or "VLOOKUP", what do I need to do?
Hope this is enough info. Thanks.
shanmac's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36781
View this thread: http://www....Reinsatlling keyboard shortcuts
Operating System: Mac OS X 10.6 (Snow Leopard)
I'm trying to reinstall my keyboard shortcuts after a clean install of Snow Leopard. What files should I import back from my clone? <br><br>Luc
ONLY your Normal.dotm template. If you bring the prefs back, you may get
On 25/12/09 5:53 AM, in article 59bafbc0.-1@webcrossing.JaKIaxP2ac0,
"Manticore@officeformac.com" <Manticore@officeformac.com> wrote:
> Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
> I'm trying ...Want ActiveX control To display Office Document?
I want activex control which can display word file data in that.
Are there any such available with out of box VC++ 6.
How it can be achived with container type activex ?
Thank in advance.
"Jay Chadderwala" <email@example.com> д����Ϣ����:firstname.lastname@example.org...
> Hi all,
> I want activex control which can display word file data in that.
> Are there any such available with out of box VC++ 6.
> How it can be achived with container type activex ?
&g...Which is better?
This might be a stupid question, but which offers better performance
when processing xml? Is it the XmlDocument, XPathDocument, or just
using an XSLT file?
"Roshawn Dawson" <email@example.com> wrote in message news:%23z535EzVFHA.firstname.lastname@example.org...
> This might be a stupid question, but which offers better performance when processing xml?
What sort of processing are you trying to do?
> Is it the XmlDocument,
XmlDocument is easiest and most flexible to do processing
where you want to modify something. It's not as fast as the
al...Wich is Better?
ADO using _ConnenctionPtr and...
DAO using CDaoDatabase?
Which is More Powerful?
...Symbols on the keyboard are not the symbols on the screen....
When I'm in Excel I must be hitting a key combination that creates havoc for
me. Everything will be working fine and out of nowhere when I try to choose
a symbol using the Shift + any number key....I get some wierd symbol instead
of the symbol on the keyboard. In order to stop this I have to close out of
Excel completely and come back in and it's fine.
Is there Any way I could undo what I did without closing Excel?
AND Do you know what I did to cause it to do that?
I had the same problem because I use two different language "French & English"...I want a spreadsheet to track employee vacation/sick time hours
I want a worksheet to track my employees vaction/sick hours.