Freeze Excel Spreadsheet till template open first then spreadsheet
When I export the data from Access 2002 to excel spreadsheet after
select excel templates. I couldn't open the spreadsheet until i open
the template and then closed the template. I open the spreadsheet
where i get the data from Access 2002. It works.
Here is the area that I have trouble with.
'Hide warnings on the spreadsheet
ExcellApplication.DisplayAlerts = False
'Save the workbook
'Turn spreadsheet warnings back on
ExcellApplication.DisplayAlerts = True
'Make it visible
ExcellApplication.V...Opening publisher 97 with a later version
I have publisher 97 on my windows xp and it works fine. However, I had someone refine some work I had done and apparently they used a later version of Publisher because when I loaded their CD, I got the message "Publisher cannot load files from a different version"
What can I do--does this mean I have to buy a later version to match the version he used, or do I have to buy one of those programs that can open other programs. If I do the later, will I be able to use my 97 version to make changes once I get the files open on the later version
http://www.mvps....Summing Alternate Rows
We have spreadsheets with many rows and need to sum alternate rows. Is
there a way to do this without entering a formula using the number of
KarenQ's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=19608
View this thread: http://www.excelforum.com/showthread.php?threadid=395115
That formula sums odd-row values in the range A1:A18.
To sum even-row values the formula is:
=SUMPRODUCT(--(MOD(ROW($A$1:$A$18...Customize Current View: Filter Problem
Using Outlook 2002, I have created a category called "Hidden" i
outlook. In my calendar, I put all the appointments I don't want t
appear in this calendar (i.e. daily reminders).
I then filter out all these "Hidden" items by selecting --
Customize Current View-->
Hidden (the category I created)-->
Edit these criteria directly-->
And then I change:
("DAV:isfolder" = false AND "DAV:ishidden" = false) AN
("urn:schemas-microsoft...How do you turn off/on the "1" or "2" or "+" or "-" view hide/unh.
What is or how do you control, turn on/off the small "1" "2" or "+" "-"
hide/unhide view buttons right above the "A" cell? Sometimes shows when I
'Data - Goup/Outline'
> What is or how do you control, turn on/off the small "1" "2" or "+"
> "-" hide/unhide view buttons right above the "A" cell? Sometimes
> shows when I hide columns.
You can toggle them to hide or display with
I have some code where I calculate this month minus 2 month. This goes fine
until I get to august. When I use DateSerial to deduct 2 month I get to July,
and this makes no sence. I made the following testcode.
Dim MyDate As Date
MyDate = #8/31/2010#
MsgBox DatePart("m", DateSerial(Year(MyDate), _
Month(MyDate) - 1, Day(MyDate))) ' MsgBox = 7
MsgBox DatePart("m", DateSerial(Year(MyDate), _
Month(MyDate) - 2, Day(MyDate))) ' MsgBox = 7
MsgBox DatePart(&qu...open two different Access reports
I was wondering if i can get some help here. I have two different reports
that i want to open when a user clicks a button to view the reports for
printing. Is there any way of popping them up at the same time in VBA?
Thank you in advance
>I was wondering if i can get some help here. I have two different reports
>that i want to open when a user clicks a button to view the reports for
>printing. Is there any way of popping them up at the same time in VBA?
>Thank you in advance
Yes. Call the DoCmd.OpenReport command twic...Unable to open Outlook Express after upgrade to Win. XP
I upgraded from windows98 to windows XP Pro. Now when I
try to use OE I get two error messages.
"Outlook Express could not be started. The application
was unable to open the OE message store. Your compter may
be out of memory or your disk is full.....0x800c012e,3"
"OE could not be started because MSOE.DLL could not be
initialized. OE maynot be installd correctly"
I found a similiar problem fix for window2000 which said
to delete OE, rename the old folder, then edit the
registry and reinstall. I did the above but was not
allowed to rename the old folder and th...Oldest date for Duplicate Cust. #
I'm trying to get the oldest date associated with a
customer number, and in the Cust# column, i'll have many
duplications of the same customer number.
Let's say A is "Date", and B is "Cust#".
(I won't be able to allow my users to sort the data, so
i'll need a formula that returns either the oldest date,
or the cell which contains the oldest date.)
Any help is much appreciated!
Nevermind. I found it using Google/Groups.
>I'm trying to get the oldest date associated with a...Opening an *.MSG file with it's respective attachment.
The file *.MSG is a message file. This can be viewed by any editor, like
Notepad. However, when there's an attachment to it, we see garbage.
Is there a way to open the attachments present inside the *.MSG files ?
Yes, by opening it with Outlook.
Microsoft Office and Microsoft Office related News
Also Outlook FAQ, How To's, Downloads and more...
Tips of the month:
-Create your own fully customized Toolbar
-Creating a Classic View in Outlook 2003
Subscribe to the newsletter to receive news and tips & tricks in your
mailbox!...opening .pst archives
I am trying to open an outlook e-mail archive file (pst)
that was made when I had Office 98 and transferred to my
new computer (Office 2003 Pro).
I am looking for an old e-mail that has now become
evidence in a lawsuit.
Can anyone help?
You didn't say if the PST file was on a CDR/RW, hard drive, or network
share. In any case, the PST file must be located on a local/network drive
where you have full access (read, write, modify, delete, .etc) rights. Once
the file is located in said place, you can open the PST file via File | Open
| Outlook Data File. To close the PST file when you ...Dates #9
The problem of a date code... I need to address this so that fo
example, 5/6/04 can be correctly entered as either 5th of June or 6t
of May, depending from where the date emanted.
Message posted from http://www.ExcelForum.com
Couldn't you format the cell as mmmm dd, yyyy so that the user sees what date
they entered in a non-ambiguous manner right away?
Or maybe provide 3 inputs: Month, day, and year.
You could combine them elsewhere.
"adn4n <" wrote:
> The problem of a date code... I need to address this so that for
> example, 5/6/04 can be c...2011 Calendar templates
what's up with the calendar templates?
why can't i find a 2011 calendar in Word 2007 templates or online.
i would like both a 12 month calendar 1 month per page and the 6 months per
Can anyone help me?
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
&quo...OWA Calendar Views
I am hosting an Exchange 2003 SP1 server with many users connecting via
OWA. Many of the users (including my boss) are not fond of the 7 day
view and much prefer the 5 day "Work Week" view within Outlook. Are
there any modules that I can load to implement this "Work Week" view
within OWA? I am aware of the control click method in the OWA calendar
but my boss does not like that solution.
Thanks in advance,
...Excel Opens Without Displaying Workbook
I am having issues with opening an Excel file. The file opens, but the workbook is not displayed. I tried the resolution in the article XL97: Excel Opens Without Displaying Workbook (http://support.microsoft.com/default.aspx?scid=kb;en-us;158996&Product=xlw97), but neither of the resolutions fixed the problem. Any suggestions??
Are you using Excel 97?
Fort Collins, CO
>I am having issues with opening an Excel file. The file
opens, but the workbook is not displayed. I tried the
resolution in the article XL97: Excel Opens Without
Di...Page setup for 8.5x11 calendar w/picture on tabloid paper?
How can I set up a calendar with 8.5x11 (landscape) pages with pictures for
each month to print on tabloid (11x17) paper so it can be saddle stiched? I
would like the picture on the top half and calendar on the bottom half. I
keep ending up with two of the same pictures on one page and two calendars
on the next page. Thanks, Bob
I assume you are taking this to a professional printer so why not just set
each page up as a landscape 8� x 11 and let your printer do the rest?
MVP Microsoft [Publisher]
"Bob at 4799" <Bob at firstname.lastname@example.org>...Qrp Date functions
Where do I find the various functions to modify the Reports
like cast(DatePart(Dd,[Transaction].Time) as nvarchar) and others
and what they mean????
Found the information at MSDN Transact-SQL Reference
"Barry L" <email@example.com> wrote in message
> Where do I find the various functions to modify the Reports
> like cast(DatePart(Dd,[Transaction].Time) as nvarchar) and others
> and what they mean????
...Opening pub files created with older Publisher versions #2
I have just upgraded to Publisher 2003 from 2000 and am having trouble with pub files sent to me for our chuch newsletter
which is using Publisher 97
The text is not wrapping around graphics boxes. Can I fix this? I really don't want to go back to Pub 200
Richard this is caused by Publisher 97 not been printer independent.
Even if you went back to Publisher 2000, unless you have the identical font
versions and printer driver you would have issues with formatting.
It sounds like the person sending you the file has a garbage HP inkjet
printer. Get them to install the HP5P laser p...date tracking
I am entering clients into a 2007 Excel spreadsheet. How do I make the entry
turn color when 14 days have passed?
This is a multi-part message in MIME format.
As part of the "client" entries, do you enter the date the client was
entered? This would be the key in doing this task.
In a cell on the worksheet you could enter the formula for today's date
like this =TODAY().
Then use the con...opening a .docx with word 2004
Operating System: Mac OS X 10.3 (Panther)
How can I open a .docx attachment that has been sent to me with word 2004?? Can I convert it somehow at my end or does it have to be converted from the sender end?
Thanks for any help...
> How can I open a .docx attachment that has been sent to me with word
> 2004?? Can I convert it somehow at my end or does it have to be
> converted from the sender end?
Make sure that Office is up to date (or at least in version 11.5.0 - the
altest version being 11.5.1) and install the XML convertrs you'...Office 2003 Service Pack 3--subsequent problems opening Publisher
I run Publisher 2003 on Windows XP. On June 13, I updated my system with
Office 2003 Service Pack 3 so that I could open Word documents with the file
ext docx. Subsequent to the Service Pack 3 installation, whenever I open a
Publisher file (which I created), I get the following message: "Publisher has
detected a problem in the file you are trying to open. If you are certain
that this file came from a trusted source and does not contain harmful
information, click OK." What is causing this and is there a way to stop this
Error message when you...Outlook 2007 Calendar -> Outlook 2003
In the past I could forward appointments and birthdays from one PC to
another, if both PC's had Office 2003. I just tried forwarding a birthday
from Outlook 2007 to Outlook 2003 and it doesn't work. I get the email in
2003. Open it, open the calendar item, then click on Save & Close. No
error message. But it's not there. Neither in the current month or for
next year. I forwarded it as a reoccurring item, that's the only way it
will let you do that.
Has anyone else been able to do this?
Or, is this a backward compatibility issue?
It's odd.... this works fine for...Effectively stoping open relay.
I have a client who started using exchange 2003 few days back. This client
is having more than 12 subnets starting from 172.27.50.0, 172.16.0.0 to
172.27.0.0 and 10.172.172.0 & 10.172.173.0 subnets in different location in
town which are conneted by DSL. This users are connecting to the Exchange
Most of these users are POP3 users.
I have 2 SMTP Virtual Server running. Default SMTP Virtual server
172.16.5.25 and the second for Externel.
In the Mail connector I have added only the external as the local bridgehead
In the relay properties of the internal I...Short time vs short date
In my form I have a fldOutOfRoom which the user inputs a short time into the
field, i.e, 0900.
I have the following code in the open event of another form called frmRNnotes:
If DateDiff("h", Forms!frmPtDemographicNew!frmVisitNewEdit.Form!OutOfRoom,
Now) >= 1 Then
Me.cmdRNnotesEdit.Visible = False
This code gives the RN one hour to complete a note and then he/she can no
longer edit the note.
What I want to know is the Short Time format going to let the cmdRNnotesEdit
button be visible everyday within one hour of the of the original time? That
is, is the short time just a tim...Can't open 2005 data file after reinstalling Money 2005
I am experiencing a recurring problem. I have had to reinstall Windows XP
and MS Money 2005. I am now unable to open my previously converted 2005 file
or restore any backup version. I consistently get the following error
"Money cannot locate filename or cannot open it, possibly
because it is a read-only file, you do not have
permission to change it, or your disk drive is write-
protected. If you have chosen the correct file and it
cannot be accessed, you will need to click OK and then
Restore your most recent backup file."
Any help or thoughts would be greatly ap...