how do I change to page 2 in making a card
> how do I change to page 2 in making a card
Which version of MS Publisher are you using?
MS Picture It! -
Digital Image MVP
Highlights and FAQs
This is not tech support
I am a volunteer
Solutions that work for
me may not work for you
Proceed at your own risk
View, status bar...
If you are using 2007...
This was posted by a fellow who lost his sort tabs.
To fix the Publisher page s...Make resource mailbox calendars viewable
I previously had calendars setup under Public Folders to reserve conference
rooms, but was told it was more efficient to use resource mailboxes for
things like that. I have created the mailboxes and it is working well but is
there a way to make the calendars viewable to the entire office the way it
was under Public Folders? People would still like to be able to see whats
available before making the meeting request. Thank you.
On Wed, 7 Feb 2007 14:31:17 -0800, KJ <KJ@discussions.microsoft.com>
>I previously had calendars setup under Public Folders to reserve conference ...making global changes
I recently imported my checking account data, over 2000 transactions, from
an Excel worksheet. The data was accurately imported, but it didn't import
the expense category associated with each transaction. Is there a way to
have Money2002 globally change all checks written to Payee A assigned to
I can re-import the data if I knew what to name the column and what order to
place it in Excel. Maybe someone know the answer to that.
Thanks in advance
In microsoft.public.money, Michael Israel wrote:
>I recently imported my checking account data, over 2000 transactions, from
...Copy Excel to Word
How do I copy a multiple page Excel file into Word? Need to have the first
row repeated on all pages. Have tried to do a copy, paste special but only
one page shows in my Word document.
You need to copy each page (or sheet) seperately and paste it in to word.
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.
> How do I copy a multiple page Excel file into Word? Need to have the first
> row repeated on all pages. Have tried to do a copy, paste special but only
> one page shows in my Word docu...How do you make the Address Book Show Up
In outlook, I've seen (under my normal contact list) CRM Business Contacts.
I've seen this before (as it shows up with the Business Contact Manager). It
doesn't seem to show up anyomore. And, I had a friend on the network install
it and it does the same thing....only 'contacts' show up. How do you get
that to show up on the outlook bar on the left like I've seen before?
Also, I have synchronization errors. How do you fix them? There are no
logs, no errors, no messages, and no place to look!!!
...How to tell if a form is open
I want to know how to return a value telling me whether or not a form is
currently open. Something like this pseudo-code:
If Forms![new appointment].Open = True Then
'send harry a box of chocolates'
Assuming Access 2000 or later:
If CurrentProject.AllForms("new appointment").IsLoaded Then
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Nick Heath" <NickHeath@discussions.microsoft.com> wrote in messa...Opening file to a certain worksheet
I need excel to open to a certain worksheet so that i can run a macro t
adjust every other sheet to users screen resolution.
How do i do this?
Any help would be useful!
Message posted from http://www.ExcelForum.com
not quite sure what you want but if you want to activate a specific
sheet for one workbook put the following code in the workbookmodule of
this excel file:
Private Sub Workbook_Open()
Worksheets("Sheet3").Activate '-> activates sheet3 on startup
> I need excel to open to a certain worksheet so that i can run a macro
> ...Removing the password requirement when importing/opening a pst fil
I backed up and also archived several outlook pst files. I've since resaved
them from CDs to my hardrive and removed the read only attribute.
Nevertheless, everytime I try to open them I get a dialog box asking for the
password. The problem is, I never set a password in the first place.
Does anyone know how to get around this? I've been trying to figure this
out for months.
Solly-man <Sollyemail@example.com> wrote:
> I backed up and also archived several outlook pst files. I've since
> resaved them from CDs to my hardrive and removed the...make Outlook use alternate calendar
I have found a dll file which can be replaced by Arabic Hijri
Calendar dll files in outlook 2003 program folder (program
files\microsoft office\office11) in order to view the calendar in
Persian Solar Calnedar, however to make outlook use it as its main
calendar I have to change the "Regional and lang..." in Control panel
which changes the calendar of the whole windows into Hijri lunar
calendar which is not an ideal situtation :).
So how can I make outlook to use Hijri calendar as its main calendar
while the XP calendar is still Georgian?
...Opening URL attachments without saving
I have modified my registry in Office 2003 to allow URL attachments in
Outlook 2003. However, when I double-click on the attachment I am forced to
save the URL to my hard drive and then open the attachment in a browser.
Is there a way to open the URL attachment without having to save it first?
Thanks in advance,
...Opening Publisher Files #2
Is there a way to open and read a publisher file without
having publisher program installed. Someone one has sent
me a publisher file and I do not have publisher nor do I
have a need to full verision of Publisher.
Mary Sauer MS MVP
"Martin" <Martin.firstname.lastname@example.org> wrote in message
> Is there a way to open and read a publisher file without
>...This makes no sense
I have bought 500 bonds at $10 each. Money tells me this cost me $50. In
fact, it cost me $5,000. Is there some way I can enter accurate info (ie.,
the correct number of bonds, and the correct price), and get the correct
Glyn Simpson, Microsoft MVP - Money
for UK tips and fixes for MS Money. To send Microsoft your wishes or
suggestions, use http://register.microsoft.com/mswish/suggestion.asp
or email email@example.com especially if it's a UK specific wish.
I do n...Missing .dll on opening
Upon opening Outlook 2002 I get a message that I am
missing MociExt.dll but I cannot get it to reload during
any sort of fix or reinstall of Outlook. Any ideas? This
started occuring after a recent update I did to Office.
I don't believe that's a file installed by Office/Outlook. So, my guess is
that you have an Outlook add-in that's causing this problem. Please do the
following steps to confirm this assumption:
1. Exit Outlook.
2. Press and hold the CTRL key as you launch Outlook.
3. When prompted to start in Safe mode click Yes.
Does the error occur? If not, please...Could not open one or more attachments #5
I have a user using Outlook 2000 that can view some of the attachments he
gets in email. The ones he can't view give him the error message, "Could
not open one or more attachments." The only thing I have noticed about
these attachments, is that they appear to not have an extension. Would not
having an extension be the problem? I would think the email would open but
have a generic icon for the attachment.
...Excel 2010 PivotTable Oddity
I have a very strange excel issue I was able to reproduce on two
computers using Excel 2010. To reproduce the issue, do the following:
1. Paste the following info into a new Excel file:
2. Create a PivotTable from this data.
3. Set up your PivotTable like this:
i. Row Labels - Type
ii. Values - Sum of Amount
4. Look at the Grand Total number
On my systems, it's showing the grand total i...How to make PST file default?
I've created another PST file in Outlook 2002. How do I make this one the
default for mail? I have two PST files open.
- Go to Tools > E-mail Accounts > View or change existing e-mail accounts
- Select the PST you just added in the "Deliver New e-mail to the following
location" dropdown (it will most likely appear just below the current
default Personal Folders file) > Finish
- Exit and Restart Outlook
- You can now close the previous default PST (R-click on that pst folder
while in Folder View and select "Close <foldername> Folders")....Can I project an Excel spreadsheet without the menu bar?
Is there any way to "auto-hide" the worksheet menu bar in Excel the way we
can "auto-hide" the taskbar? I want to project an Excel spreadsheet onto a
screen but do not want the worksheet menu bar to be visible.
Thank you to anyone who can help.
Go to the View menu, choose Toolbars, scroll down to Worksheet
Menu Bar, and uncheck it. Or, with VBA,
Application.CommandBars("Worksheet Menu Bar").Enabled = False
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"DEN-RIK" <DEN-RIK@discussions.micros...Write to Access Via Excel
Is it possible to use Excel as a frontend to Access? I developed a database
for one of the groups at my company, but the request was made to interface it
to Excel, if possible.
If it can be done, what are some of the pros and cons of this approach?
I suppose you could do that, but why would anyone want to cripple their
users that way?
The real question, though, is what does Excel offer in terms of an
interface, that would be superior to the interface in your Access database?
"PJFry" <PJFry@discussions.microsoft.com> wrote in message
news:28A446D2-...Excel spread sheet
Why random data is replaced with a number symbol. Date entered as 2/2/2010
but ######## shows up in the cell.
iCould be a number of reasons:
First try either widening the column or reducing the font size.
Come back if that doesn't work
> Why random data is replaced with a number symbol. Date entered as 2/2/2010
> but ######## shows up in the cell.
...Opening Word 2007 template in 2003 reformats the document
A Word 2007 document was email to my company. The document appears to be
using a Letterhead template. When the document is opened in Word 2003 the
entire document changes to quadruple spacing. In addition, there is a
formatting dialog boxes as if track changes are on.
A few users in the 2003 environment can open the document, view and print it
fine. Others, open it and see the quadruple spacing.
Is there a setting in 2003 that turns this off? Why are some viewing fine
while others do not?
"Gia T." wrote:
> A Word 2007 document was emai...run vb macro on open
Simple query - I am after the VB code, so that on opening
a spreadsheet a macro contained in the spreadsheet is run
To explain further, I have a sreadsheet that has three
query's that refresh via a macro and then the macro
continues and closes the spreadsheet. What I need is the
code to invoke this above macro automatically once the
spreadsheet is opened.
Thanks in advance.
...how do I make make my hyperlinks show the email address they are .
I copy a list of names from one page and put them in a excel spreadsheet.
What happens is just the name show like DUSTIN MCALISTER but when you hold
the mouse over the name the email address shows up in a little yellow box
showing what the hyperlink is. Is there a way to make it show the email
address instead of the hyperlink?? That way I can click on a row of names and
all the emaill addresses will be there so I can copy and paste them into my
Email and mass email my clients? Thanks!
...!!! Excel and Windows NT Integrated Security !!!
Do you know how to read the userid logged on a PC using VBA.
For example as using the instruction request.servervariables("AUTH_USER") in
Public Function WinUserName() As String
WinUserName = Environ("UserName")
> Do you know how to read the userid logged on a PC using VBA.
> For example as using the instruction
> request.servervariables("AUTH_USER") in ASP.
I have a text file containing values that I import into excel.
Once the values are in an excel sheet I do a sum of them all.
(currency - 2dp)
The final sum is displaying as 441992.489999999990000 - why would this
None of the individual values show a greater degree of precision that
In the text file there are no values with more than 2dp!
Why is excel calculating incorrectly.
I know I can do rounding etc. but what I want to know is why excel is
MattShoreson's Pr...Can't open XLS file
When I double-click on the XLS file, empty XLS will open and following
message is displayed:
“Windows cannot find ‘document name’. Make sure you typed the name
correctly, and then try again…”
The only way to open my files is to 'drag and drop' them into an already
Thanks for any advice
I bet you could open excel and do File|open to open those workbooks, too.
Sometimes one of these works:
Tools|Options|General|Ignore other applications (uncheck it)
--- or ---
Close Excel and
Windows Start Button|Run
Windows Start Button|Run