Date format issue when submitting from a userform to a spreadsheet
I have a userform that I've generated which routes dates onto a spreadsheet
based on the users input. I am having a bit of a frustrating time with the
dates, it would appear that in the process of moving the date from the
userform to the spreadsheet some dates are switched/transposed. I'll give an
example. If someone enters 09/02/2004 on the userform excel seems to look at
09 and assume it is a month and transposes the dates to 02/09/2004(this does
not appear to be a US/UK format issues as I have already gone down that
road). However, if the date 13/09/2004 is entered i...Printing Newsletter in Publisher 2003
I have Publisher 2003 on an XP OS and trying to print a newsletter with 2
pages per tabloid size paper. I was able to do this OK with Publisher 2000.
It seems that the 2003 version does not have a "Book fold" option for the
layout. The Print Preview looks OK and shows page 6 and 1 for the layout.
For layout I choose "Booklet". What I get is page 6 and 1 on 1/2 of the
11x17 paper. Help!
Gary are you printing to a laser printer???
If you are, you are running out of printer memory.
Have a look in the properties of the printer driver, and change the settings
from Vector...Publisher file made in Publisher 2007 won't open in 2007
I produced an 8.5 x 11 brochure two days ago in Publisher 2007. I was able
to save, resave and reopen the file many times during the day. When I tried
to open the file today, I get the "Publisher cannot open the file" error
message. I've tried to open the file on two different machines with
Publisher 2007 and get the error message both time. One has XP Pro, the
other has Visa Home Basic. It's a 1.6 meg file. I have a smaller publisher
file of a bumper sticker (40 kb) which was made a couple of weeks ago which
opens with no problem.
This is the second time I ha...Microsoft Money 2007 Deluxe Canadian version?
I have been looking for Microsoft Money 2007 Deluxe Canadian version and I
cannot find it. Where can I get one?
There isn't one. See http://money.mvps.org/faq/article/422.aspx
Microsoft MVP - Money
For UK tips & fixes see
I do not respond to any emails that I have not specifically asked for.
"masai" <firstname.lastname@example.org> wrote in message
>I have been looking for Microsoft Money 2007 Deluxe Canadian version and I
>ca...does vista installed on virtual machine 2007 get wsus updates ?
It is searching for updates but it is not finding anything and saying
that Windows is up to date. I have set the updates to install from the
wsus server and assigned the updates to the same Vista virtual machine
aconti's Profile: http://forums.techarena.in/members/73272.htm
View this thread: http://forums.techarena.in/active-directory/1290161.htm
If the machine is getting the correct GPO for the WSUS settings, check with
rsop...Office 2007 trial is very slow. Is this because it's a trial
I just started using the trial version of Office 2007. It takes forever for
it to open on my computer but Office 2003 opens just fine. Is this just
because it's a trial or is it naturally slow because of the additional
It's likely due to the expanded feature set and increased hardware
requirement over Office 2003.
> I just started using the trial version of Office 2007. It takes forever for
> it to open on my computer but Office 2003 opens just fine. Is this just
> because it's a trial or is it naturally slow because of the ad...Can't edit print styles in Outlook 2007
Weekly calendar view to print - Define print Styles - Edit "CANNOT DISPLAY
THE DIALOG BOX"
I'm using trial version - shouldn't be the case????
I'm having the same problem where I cant edit the print syles ... please let me know what ou find out.
I think being able adjust the format and print the calendar is important, as I usually print my calendar.
EggHeadCafe.com - .NET Developer Portal of Choice
This is an Excel newsgroup. I would suggest posting this to an Outlook one
Microsoft MVP - Excel
Southampton...excel, worksheet, set print area, position selection on printed pa
Office 07, Excel.
Print area is set, print preview displays selection, always on far left of
I want to choose the position on the page, eg centered or right aligned etc.
To get your printout to center on the page chose Page Layout, click the
Page Setup quick launch button (bottom right corner of the Page Setup group).
Choose the Margins tab, click Horizontal.
There is no command to right align a printout, but you can change the left
margin to force the printout to the left.
If this helps, please click the Yes button
"Eve Al...Office 2007 SP2
Has anyone else lost the little check box which is usually found next to
each task in the task list in Outlook today? I'm assuming it's a bug?
"Carmen Gauvin-O'Donnell" <email@example.com> wrote in message
> Has anyone else lost the little check box which is usually found next to
> each task in the task list in Outlook today? I'm assuming it's a bug?
Nope - still there...
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level...z-order of various lines and bars in an Excel 2007 chart
What is the procedure for changing the z-order of various lines and
bars in an Excel 2007 chart, such as drop lines, high-low lines, up/
down bars, and error bars?
I observed that when I add drop lines to an Excel 2007 chart, they
appear in front of the underlying data -- in my case, the underlying
data is displayed as a plotted area. I want the plotted area to be
fully visible with no lines over it.
I would like to send the drop lines to the back and keep the plotted
area in the front, but there is no option to do this.
So, is there a procedure for adjusting the z-order of drop...Issues Template
Hi i have downloaded the issues template to work in a vet office, but am not
sure what the Add related issues is for on the Issues details form. i jus
want to know what it does and its benefits
It's unlikely that you'll get any help that requires anyone to
download and analyyse someone else's guickie application. You'd do
better to use the sample databases and tools that are provided with
Access and ask questions based on them, instead.
"Amin" <Amin@discussions.microsoft.com> wrote in message
news:1B20F4FC-2696-4724-8615-49...Unicode "private use" glyphs in Powerpoint and Word 2008 #2
Office 22.214.171.124 on Leopard 10.5.2, all updates applied to both.
A friend is migrating from Windows to Mac, and has come across
something that we're trying to work around.
He has some .ppt files with font glyphs in from a Unicode .ttf font (a
specific purpose font for showing the LCD display characters on a
piece of monitoring equipment). When we bring the font and .ppt over
to the Mac, the glyphs from the normal ASCII range come over into
Powerpoint 2008 fine, but the glyphs from the "private use" range from
F000 upwards a way don't transfer. In Powerpoint they show as spac...Work spreadsheet issue
If I have multiple rows of data on a worksheet and on another worksheet
I want various counts of rows that have certain things in common, how
would I do that? Thanks.
jenrenea's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23098
View this thread: http://www.excelforum.com/showthread.php?threadid=373900
Can you provide a sample of your data along with your expected results?
Domenic's...Outlook 2007: is there a way to use it as a Diary
I'd like to keep a daily journal of important notes, etc. In other
words , I would like to keep a Diary. Does Outlook 2007 have this
Sure - Ctrl+8 to view the journal or you can create a Mail and Post folder
type and post to it.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email:
EMO - a weekly newsletter about Outlook and Exchange:
mailto:EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH...Upgrade Path from DPM 2007 to DPM 2010
Is there going to be an upgrade path from DPM 2007 to 2010?
Yes. Look at the following DPM 2010 documentation:
"DPM supports upgrading from DPM 2007 SP1 on a Windows Server 2008 x64-bit
operating system to DPM 2010. If DPM 2007 SP1 is installed on a Windows
Server 2003 x64-bit operating system, you must upgrade to Windows Server
2008 before upgrading to DPM 2010".
Also, here are my notes on DPM 2007 to DPM 2010 upgrade:
http://santhoshsivarajan.blogspot.com/2009/09/dpm-2007-t...Unread mail not showing up in Inbox
My Unread folder in located the "Favorite Folders" section in Outlook
shows that I have more unread mail than I can see in my Inbox. My
Inbox is normally sorted by "Received" so I can see the most recent
emails as then arrive. If I change it so that it is sorted by the
"From" column, I can see all the emails in the Inbox that are
appearing in the Unread folder. It is strange that they don't appear
using "Received" though. Emails that fall under any rules are not
affected by this so rules are irrelevant in this case I suppose.
Also, some additio...Exchange 2007 Mailbox Folder information not updating
Operating System: Mac OS X 10.6 (Snow Leopard)
Email Client: Exchange
I am using Entourage 2008 Web Services Edition in an Exchange 2007 SP1 UR4 environment. I have only been using the Web Services Edition for about a week and prior to that I was using the regular Entourage 2008 client for four months. In any case, the problem I am about to describe occurs in both versions of Entourage 2008. <br><br>Recently my employer's executive group decided to implement Managed Folder Policies to assist in controlling mailbox size. I was the first to...Check printing in GP 7.0
I have check payments for vendors, where I'm dealing with
LOCAL CURRENCY & FORIGHN CURRENCY. When I paid by check in
LOCAL CURRENCY then the amount in words prints perfectly
but if i paid by check in FORIGN CURRENCY then the amount
in word prints in numeric which i want to print amount in
words instead of numbers.
Please help me to print checks amount in words for FORIGN
CURRENCY as well.
Your suggestion would be appricated on above issue
I am experimenting with Excel 2007. I normally use Excel 2003. When I have
unusually large amounts of text in a cell *in 2003* the formula bar displays
all of it. Sometimes that takes up most of the window, but the text is about
8 or 9 points. Under 2007, although I can increase the width and height of
the formula bar, the text is much larger and I must scroll down to see it
all. *Not good* How can I change this is 2007 version?
You can minimise the Ribbon.
There is a dropdown at the end of the QAT (Quick Access Toolbar) which
gives this option.
With the Windows XP bar set...Outlook Draft Email Print Problem
I have emails saved in draft but when i go to print them
it doesnt show who it is being sent to and the fact it
hasnt been sent yet, i have played with the setting but to
no avail. I am using outlook 2003 any help would be
Turn off WordMail before printing the draft (Tools | Options | Mail Format)
or wait to print until after you send it.
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
<firstname.lastname@example.org> wrote in message
news:...Printing Detailed Trail Balance
I just installed a new printer HP Deskjet 5940 and when i print Detailed
Trial Balance reports it cutting off the Credit column. How do I fix this?
...Outlook 2002 HTML printing problem
Outlook 2002. I cannot print HTML emails. Plain text
prints without any problems just HTML will not. Office xp
pro is at all latest service packs. Anyone have an idea
what may be wrong?
...Alerts in PS 2007
I need to generate an Alert to the employee who didn't submit the Timesheet
by the certain time. Next step - send Alert to the manager.
Appreciate your help
Best to re-post this in the newsgroup dedicated to Project Server:
On 04/03/10 15:07, laguna wrote:
> I need to generate an Alert to the employee who didn't submit the Timesheet
> by the certain time. Next step - send Alert to the manager.
> Any ideas?
> Appreciate your help
Thank u, Rob
How to delete ...Business cards & printing
I have formatted some business cards with Publisher 2003 for a friend and
she wants to be able to print them off from her computer. However she does
not have MS Publisher, MS Word. She will probably purchase one of the Avery
packages from an office supply.
Is there a way I can save the file ready to print the cards with the proper
number per page and convert it to jpg so she could use it?
Thanks for information.
Hi Susan (email@example.com),
in the newsgroups
|| I have formatted some business cards with Publisher 2003 for a
|| friend and she wants to be able to print ...Update KB973917, KB975929 and KB976264 Killed Network print
When I installed the updates on Vista SP2, the network print stopped working.
I have an old HP printer with an Axis 540 print server and a new Brother
DCP-375CW using Wi-Fi.
The printers are visible form the computer and can be found in add printers,
but no print job gets done, when I roll back the update, they work again.
There is no problem in printing from WinXP machines.
I have stopped using Windows update due to these problems.
Any suggestions on solving this odd problem?
For home users, no-charge support is available by calling 1-866-PCSAFETY
(and/or 1-866-234-6020 ...