Awesome list of Excel/Word/Powerpoint shortcuts!
I recently discovered a great keyboard shortcut list for the office
applications. It seems to have practically every shortcut imaginable and it
fits on one page too! I printed it out and put on the wall next to my
monitor -- just great!. Thought you would appreciate it...
Here's the link to the PDF file. Hit print and you're ready to go.
For Excel, I like Chip Pearson's Excel Keyboard Shortcuts page at:
There is also a d...Is there ANY possibility to view embedded PDF object in XLS file after when this xls file is digitally signed?
I created an XLS file with an embedded pdf object. I can view this
object when I double click on its icon. However, if I sign this xls
file, I am no longer able to view this embedded PDF object. If I
double click on its icon, nothing happen.
I am concerned in this last two days with no results. I appreciated
...hyperlink open in new window
How do you create a hyperlink and have it open in a new window?
David Bartosik - MS MVP
for Publisher help:
enter to win Pub 2003:
"sharin" <firstname.lastname@example.org> wrote in message
> How do you create a hyperlink and have it open in a new window?
...Merge to email w/Word and Outlook 2002 security issue
I am trying to merge email using Word and Outlook 2002.
This merge consists of about 3000 recipients. When I
commence the merge I get an Outlook Security warning that
tells me that some outside program is trying to send
email using my Outlook profile and I have to click Yes or
No. It procedes to ask me for ever single recipient...
I'm not going to sit there and say yes for 3000 people.
Do you know of a setting somewhere that I can change to
not ask me everytime?
What service pack(s) have you applied? Did you choose HTML as the message
format for the merge?
-- ...Outlook does not open all of a sudden
I have Office 2007 Business
I cannot open Outlook all of a sudden.
I get a message that The Outlook Folders cannot be opened, that the server
is not available (?).
I run Microsoft Office Diagnostic with no apparent problems,
I tried to fix , to uninstall and reinstall.
All other programs ( Excel, Word, power point, etc) are working fine.
Can anybody give me a suggestion before I get another hard disk and
What is the exact error message? Paraphrasing does not help.
Have you tried a new mail profile?
Milly Staples [MVP - Outlook]
Post all replies to the grou...Expost Outlook PST file to Outlook 2002 PST file
I have a customer who has bought a copy of Office 2003
which he has now decided he doesn't like!!
He has asked me to return his system to his old Office XP
Professional. No problem except for one thing - I exported
his PST file from Outlook 2003 (11.5608.5703) and tried to
import it toOutlook 2002 (10.2627.2625) and the result was
that Outlook 2002 doesn't recognise the format of the
Outlook 2003 PST file! My customer isn't impressed!!
Does nyone any ideas on how I can either export the file
in a format that will be recognised AND keep all his
folders and messages where t...Moving my Outlook files to new computer
How can I move my Outlook 2003 files (Contacts, Calendar,
mail, etc) to a new computer?
...importing multiple text files???
I am experiencing a big problem. As a part of my analysis for PhD I have to
analyze more then 1000 files. The data that I have is in text files. To be
more precise, I have 5 different data sets, from different meteo centres,
each centre has a data set of 365 files for each day during the year. The
format of text files is something as following:
Camborne Met. Office
WINDS rev 4.1
50.20 -5.30 88
02 01 01 00 00 23 0
29 3 35
07:09 (3.0) 07:09 (3.0) 06:08 (3.0)
284 284 65 65 400 400 23 23
12.5 12.5 1 1500 1500 35 35 400 400
43 90.0 43 74.5 313 74.5
HT SPD DIR Radials...
0.101 9.8 113 0.0...Opening tab-delimited files in Excel... how to stop the autoformat of dates?
I'm doing bioinformatics work in which I often download tab-delimited
files describing genomes and open them in Excel. Unfortunately, Excel
decides that genes with names like APR1 and SEP7 are actually dates,
and reformats them as such. This is a huge headache, as I often don't
notice these problems until much later.
Is there anyway to completely disable this date autoformatting? I've
searched high and low and have yet to find a solution.
P.S. I'm using Excel 2002
sa...Dotnet Lead Engineers opening in Pune
We are Bangalore based leading HR consulting company retained by top
IT companies like SAP Labs, TCS, i-Gate, AztecSoft, GE, Symphony
Services, HCL to hunt talent.
Excellent opening for Lead Engineers at AT CMM Level-5 & Largest IT
Company for their Pune ODC.
3) SQL Programming
4) Must have strong experience on ASP/VB script and good exposure to
5) Should have min two years experience in Classic ASP/VB script and
min one year experience on ASP.NET
6) Should be willing to work on classic ASP development
7) Good knowledge of MS Sql server, H...Can I make a database in Word with Excel Data
I know this may be a "DUH" question, but...
I am making a list of area dentists that I have copied and pasted of
of the Dex website into Excel. I am wondering if I can take this inf
and make a database in Word for printing address labels. Does anyon
know if this can be done, and HOW?:confused
Myn777's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2958
View this thread: http://www.excelforum.com/showthread.php?threadid=49283
For help on Word mail merge using Excel as the...Open document from previous version
How do I open a document from a previous version of
Publisher..I have 2000?
Are you certain it is an earlier version? Do you have Norton? Disable "script
blocking" and try again.
Mary Sauer MS MVP
"Jan" <email@example.com> wrote in message
> How do I open a document from a previous version of
> Publisher..I have 2000?
> How do I open a document from a previous version of
> Publisher..I have 2000?
If it ...Change opening postion /Form
From my Main Form I have a control that open a smaller form overtop of main
Form, It always opens in the middle of my Main Form, can I reposition it to
open higher on my Main Form,
Thanks for any Help.....Bob
On Mon, 6 Aug 2007 11:13:29 +1200, Bob V wrote:
> From my Main Form I have a control that open a smaller form overtop of main
> Form, It always opens in the middle of my Main Form, can I reposition it to
> open higher on my Main Form,
> Thanks for any Help.....Bob
Look up the MoveSize method in VBA help.
DoCmd.MoveSize 2 *1440, 3 * 1440
will position a form 2 inch...Spinning Beach Ball
I seem to notice a correlation between seeing the spinning beach ball more often after launching MS Word for OSX. I removed the PDFMaker.Lib and this improved the performance a great deal, but still noticing the SBB more often after launching Word.
Anyone know about this?
Many Word issues are related to corrupt Word Settings or Normal Template.
You could try removing the Word Settings file, then testing. The Normal
Template could be renamed, then test. Be sure Word is closed before removing
or changing any files. You could also consider running the Remove Office
utility and reinstalling Offi...File Association in Dialog-Based Application
Has anyone seen any info on how to associated a file type with my
In order to use RegisterShellFileTypes(), I must add my document template
using AddDocTemplates(). But AddDocTemplates() can't be called without a
Thanks for any thoughts.
>Has anyone seen any info on how to associated a file type with my
>In order to use RegisterShellFileTypes(), I must add my document template
>using AddDocTemplates(). But AddDocTemplates() ...ACH file incorrect
The bank says our ach file is incorrect. It should begin with 522 and end
with 822 and it begins with 520 and ends with 820. Does anyone know where or
what I need to change to get this the file to display correctly.
Thanks for any input
...Obtaining Path of the file/folder ?
I have an mfc dialog based demo application.
I wanted to add my application's entry in the Windows Explorer's
context menu, which i m able to successfully by making some additions
to the registry.
Now whenever the user right clicks on some folder/file,the context menu
displays my application's entry which gets executed when the user
clicks on it.
How can i obtain the path of the file/folder on which the user
right clicked ?
Waiting for suggestions
>I have an mfc dialog based demo application.
>I wanted to add my application's entry in the Windows Expl...VBA code to hide all the tables on form open
I don't want people to use a blank mdb to import my tables. I manually hide
them all. However, after running the macro to delete all records and import
from .txt, the table become unhide. I do the importation on daily basis.
I posted to macro newsgroup and asked way to hide table after importation
action macro but got no answer. Maybe it cannot be done in macro?
If so, I need VBA code to hide all the tables on form open. Thanks.
Hiding your tables won't prevent people from being able to import them into
a blank mdb. All they have to do is ensure that they've set the datab....XLB file corrupted often
The excel.xlb file is getting currupted every week or
so. Once replaced w. a good version things work fine for
a while. Any suggestions on premenent fixes or what is
possibly corrupting it. Thanks for any suggestions
One possibility is some rogue VBA code which is customising menus/toolbars
and not undoing its work properly. If this is the case then yoour XLB file
can get larger and larger until it falls over.
If you are running any VBA code or using addins check that they have a
workbook_close routine that removes any changes to menus/toolbars they have
Charles...Quotation mark key produces << instead of " in Word doc from PC
Operating System: Mac OS X 10.6 (Snow Leopard)
I am updating a document that was created in Word on a PC several years ago. When I viewed it all the ' had become =. I found out in the forum how to fix that. But more important, I do not seem to be able to type a quotation mark. When I hit Shift ", I get a symbol that looks like a doubled >. The symbol doesn't even exist on my keyboard. I suspect that I can go to Insert, Symbols, and get the proper ", but this is a syllabus for a class that I teach year after year, updating t...How do I turn on drag and drop in MS Word 2007?
It seems that drag and drop has stopped working..... I have no clue why.
There are instructions on how to turn drag and drop on/off for MS Word 2003,
but I can't find the directions on how to do this for Word 2007. I'd like to
turn this back on. Can anyone help?
Click on the the Office Button (top/left) and at the bottom of that window click on Word Options.
In that window choose Advanced.
Drag and Drop is the third choice down.
(That said... it doesn't always work even when you have selected it. Sigh) The problem could have to do with the Symbols dialog box. When you...Are there functions/Or Events that are called automatically when the database file first opens and When it closes?
I'm assuming its "Public Function init_something()" but I can't seem to find a reference to the correct syntax. I'm using Access 2007.
Basically what I'm trying to do is initialize a list of global variables and I can't seem to figure out how to do it.
Option Compare Database
Public VariableName As String
'Call Init - Will throw an error
'VariableName = "Hello World" - Will throw an error
Public Function Init()
VariableName = "Hello World"
Private Sub btName_Click()
running on home computer, no exhange or server. when I
open an inbox message and close it, the message
disappears, it isnt in other folders or in delteld files
folder. If I move the message to another folder before
opening it, then open the message in that folder, I am
fine I can open and close it without losing it.
I have been running everything fine for a couple of years
now, only in the last moth did this start happening.
I have reformatted and reloaded my computer, it doesnt
help. I have taken mirosoft outlook express off the
computer, that doesnt help either. I only have o...Word 2003-Page Orientation
I have a long Word 2003 document with all pages in portrait orientation
except one. That page contains a table the size of which requires landscape
orientation. I have always done this by inserting section breaks before and
after this page. But now for some reason I can't get the orientation to
change either on-screen or in my printer. When I check the page orientation
in that page (section) it is set to landscape. Suspecting typical Word
corruption (this document was made from previous versons of the same stuff)
I did the usual copy-and-paste all but the last few empty ...hello! WTB SELL ME YOUR software OEM or Retail LARGE and SMALL QTY
WTB: MICROSOFT OEM SOFTWARE
WTB: MS WIN 95, 98, 98SE, 2K, XP, OFFICE 2000, XP, 97, 95 PRO-Vista ultimate, basic, premium Small business..
Looks at the list below.
Wanted to buy.. Microsoft OEM and RETAIL Software in small and large quantities.
Buying in areas of 1-2000 or more! The more the better!
Here is a partial list below. Email us with what you have!
Office 2000 SBE
Office 2000 PRO
Office XP SBE
Office XP PRO
Office 2007 Pro, Ultimate
Office 97 PRO
Office 97 SBE
WIN 95, 98, 98 SE, 2000 PRO and XP
Windows 2000 Server
Windows 2000 Server +5, 10 or 25
SBE Server 2...