Conditional Opening of Excel file
I have a complex workbook that relies on various SUMIF's from othe
reference workbooks. If these aren't open, then obviously the formula
As it's for someone else; I want a piece of VB so that when they *open
the main workbook, it checks to see if the ref file is open, and i
not, it automatically opens it for them. A bit like this
sub worksheetopen '(Not sure where this should go in parent book)
if workbook("Referencefile.xls") is NOT open then
Any ideas folks?:confused
Message p...Trouble opening publisher docs from CD
I burned a CD containing publisher documents (all were
changed from read only)for a associate to use. However,
when the associate put in the CD, he could open the
documents, but could NOT make any changes or additions. A
box comes up stating something about "hidden" atributes
or something like that. He also copied the entire folder
into his computer and still couldn't make any changes or
additions to the individual documents. What are we doing
wrong. I appreciate any help to resolve this problem and
thank anyone who may have the answer.
Once those publications ar...Email Messages disappearing
I have my email (Microsoft Outlook on Microsoft XP) set up to go to specific
folders dependent on who sends it. Well, there are messages unread in
certain folders it will have a number next to it. Well, I'll click on the
folder and the number changes. Not one number but multiple. Like it says
there are 5 messages in the folder unread, I'll click on it and then it says
one and the other 4 messages are missing. I don't know what is causing this.
rachel <email@example.com> wrote:
> I have my email (Microsoft Outlook on Microsoft XP) set up t...Why is Publisher printing very light, hard to read, after reinstal
I had to reload my Microsoft Office 2000 and now the print on my Publisher
documents is very light and hard to read. How do I change this to a darker
This is not a Publisher issue. Do you have your printer set to draft? Is your
driver current? Clean your printer heads.
Mary Sauer MSFT MVP
"Betty Florida" <Betty Florida@discussions.microsoft.com> wrote in message
>I had to reload my Microsoft Office 2000 an...Excel cannot open email program.
I often use "file.. send to... mail recipient" to send a spreadsheet as text
in the body of an e-mail.
I prefer that to sending excel as an attachment, since my recipients may not
have excel and usually don't need to see formulas.
On my new computer however I get the message "excel could not open the
e-mail program" if I try the first option above.
Both excel 2002 and outlook 2002 are working fine. I "repaired" office
just to be sure. Still doesn't work.
Only difference is that the computer came with a trial version of office
2003 which I don...Outlok 2003 Word Attachments are Read Only and in 2 page view
I have a client with Outlook 2003 and when he receives an email with a word
doc attached and attempts to open it (rather than save it 1st) it opens in
Word as read only and shows as a split screen (2 page book view). if he
saves it to the drive 1st he can remove the read only attribute and then
Word opens it normally.
Not sure why the view is different. My OT advice - always save attachments
you want to edit, and then open them. Otherwise you're using a temp copy of
the file & may lose changes.
Marc Seidler wrote:
> I have a client with Outlook 2003 and when he recei...Open XML File Converter
Operating System: Mac OS X 10.6 (Snow Leopard)
Any word on an update to this converter that resolves the "There is not enough memory or disk space to convert this document" bug on SL? I've seen it reported elsewhere so I'm assuming it's a known issue, but can't find any relevant info here.
On 11/2/09 2:33 PM, in article firstname.lastname@example.orgR9absDaxw,
"email@example.com" <firstname.lastname@example.org> wrote:
> Any word on an update to this converter that resolves the "There is not e...manual Control Messages in MFC
I m sure someone done this before
my CFormView derived class has a few checkboxes.
I want to force the message handlers of all the checkboxes to be called when
I change (check/uncheck) one of them. I dont want to use the group thing.
my code is like this
m_bStatusCode = ((CButton *)(GetDlgItem( IDC_CHECK_COMPILE_CODE
)))->GetCheck() ? TRUE : FALSE;
m_MyGUI = COMPILE_CODE;
/* needs to send the notify the parent to execute the other message
m_bStatusAssets = ((CButton *)(GetDlgItem( IDC_CHECK_BUILD_ASSETS
)))->GetCh...unable to open CRM web page
It seems that I can open the CRM web page from the server but not from any
workstations. It also affected any clients that were using the Outlook
client. I have tried opening the page using the ip address, and the FQDN of
the the server and still didn't have any luck. Someone point me in the right
Well a few things to try to narrow the problem down:
1. Can you ping the server with the IP address / FQDN?
2. Can you log into the server with a non administrator and get to the site
locally? (may be a permission issue, set to run as local or network service)
3. Log...Font size changes in Excel 2003 charts when re-opened
For certain charts that I create within Excel 2003 (usually bar
charts), I use a font size of 8 (eg for data labels, axis labels, and
scale). If I close the file and then re-open it, all these fonts will
have become size one (title and legend are not effected).
Oddly, if I have created a bar chart and made several copies of it
within a worksheet, it will only be the original and not the copies
that are affected by this.
If anyone can shed any light on why this may be happening and how it
could be fixed, I would really appreciate it.
...Exchange POP3 Message Retrieval WOES..........
Is there any possible way to decrease the amount of time for Exchange to go
out and check a mail server in the POP3 settings? It will not go any lower
than 15 minutes before Exchange will even attempt to go out and look for
mail. For people that live and die by e-mail everyday, you would think that
you could set it down to every minute if we so choose. Why limit it to only
15 minutes. Is there a VB script that will run that process faster or tell
Exchange to go check for mail now versus having it wait 15 min?
BTW, this is with SBS 2003 Standard Edition
Please help, this is a major ...open multiple workbooks at startup
Ever since i ran a macro that opened several workbooks, my Excel always opens
the same workbooks. I have searched and deleted all the files that are being
opened. Search shows they are in a sub-folder "Application Data", but this
folder is not listed in explorer and the files that are opened are not found
with a file search. another thing, the open files in Excel options is
cleared to blank.
How do I stop opening these files when I open another file?
you can find the folder application data if you switch on the view
hidden files option in windows
it will be in C:...Importing messages from Outlook 2003 into 2000?
I have Outlook 2003 on my computer at work and Outlook 2000 on my
computer at home. I would like to move some messages from my work to my
home machine. Unfortunately, Outlook 2000 doesn't seem able to understand
the .pst files generated by Outlook 2003. Is there any way around this?
Make sure you create and copy items into a legacy (Outlook 97 - 2002) pst
file. See File | New | Outlook Data file. Pick the Outlook 97 - 2002 type.
Copy items form mailbox to this new pst. Close it when done (right click on
personal folders and select close/disconnect.)
"Colin Caulkins&...Visual Basic Error Message #2
After updating an application unrelated to Excel that I have been using for
two years, evefry time I now start Excel (I'm using Excel 2003, by the way),
I initially get a Microsoft Visual Basic error window popping up on my
screen: "System Error &H8000FFFF (-2147418113). Catastrophic failure." When
I click OK, a second Microsoft Visual Basic error window pops up: "Out of
memory." I then click OK, the window disapears, and then everything runs
just fine. All my calculations, prior work and spreadsheets and so forth, as
well as new files I create are readily...news/outlook bar, opens a folder rather than news?
Just happened today.
I have newsgouprs in my OL 2003 bar,
when I click on it opens a folder C:\Program Files\Common
rather than my news, suggestions on how to remedy this?
Think I have it fixed,
"Bruce Leavitt" <Notthis1@noidea.com> wrote in message
> Just happened today.
> I have newsgouprs in my OL 2003 bar,
> when I click on it opens a folder C:\Program Files\Common
> rather than my news, suggestions on how to remedy this?
...Error openning Workbook
I am having trouble openning an Excell 2002 workbook. The file is 49 meg in
size and I am running Win 2000 OS. The error message provided has no value.
just stated whether to send error report to Microsoft.
When I update stock prices from the Internet, I get two messages:
Component Update: The Internet, banking or brokerage server could not
process the request. Please try your call later. (SMC)
Money was unable to retrieve currency exchange rates for Euro...
The stock prices seem to update correctly. Does anyone have any idea how to
get rid of these messages?
...First Time Opening Outlook
I just installed Outlook and when I try to open it, I get a popup message
titled "Connecting to Microsoft Exhange Server". The message is, "Your
Microsoft Exchange Server is unavailable." and a second popup says,
"Configuring Outlook Accounts". The configuation process never does
complete. I can even open outlook.
Ross <Ross@discussions.microsoft.com> wrote:
> I just installed Outlook and when I try to open it, I get a popup
> message titled "Connecting to Microsoft Exhange Server". The message
> is, "You...Visual Studio can't open resource file in Resource View after IDE crash
I have a strange problem with Visual Studio .NET 2003, I hope that
this is the appropriate newsgroup. After adding an icon resource
to my project, Visual Studio crashed, and after restarting it, it
was unable to open my project's resource file in the resource view
pane. It displays the name of the rc file, but when I click the
"+" beside it to open the resources, nothing happens, and the
"+" disappears. There is no error message.
Restarting Visual Studio and rebuilding my project didn't help.
I can open all other projects' resource files without problem...When collecting data by using e-mail messages
I'm getting the Warning message - these email messages might contain data
that is of a confidential or sensitive nature - and it's not giving me access
to the Create button in the wizard. The suggestion is to remove any fields
in my message that might contain the confidential data, but there are none.
How do I get around this?
When I said "there are none", I meant that none of the fields contain data of
a sensitive or confidential nature. I even tried removing every field except
the very first one which is simply a text field with the identificat...Cannot open Outlook window. The set of folders cannot be opened
This morning I wanted to copy my pst file to laptop -via home network.
Outlook hickupped against that. I then made an archive file in same
directory and copied that via via to laptop.
NO SETTINGS WERE CHANGED. Then I closed doen computer normally.
Now, returning home after work, starting Outlook, it gives the message:
Unable to open Outlook window. The set of folders cannot be opened .
Can anyone advise me please what I should be doing?
Create a new mail profile - yours is now corrupt.
Milly Staples [MVP - Outlook]
Post all replies to the group to k...reference is not valid message for pivot tables based on Access query
I've looked around but can't find an answer to this.
I have a workbook - an xlt - that has 6 worksheets that pull data from
different queries in the same Access database.
I have several worksheets with on pivot table each. The pivot tables are
based on dynamic named ranges in the external data worksheets. I use
dynamic ranges because I have some adjacent calculated columns in the
The workbook has only 6 pivot caches - the same as the number of worksheets
that pull data. I copied pivot tables from sheet to sheet so that they'd
use the same cache, where approp...missing all texts from mail messages
For some reason all text from all of my mail messages are
missing. The only way I can read my mail messages is by
saving them as *.txt files. I have relatively new XP
version (got a new computer few weeks ago) with Outlook=20
Express 6. The mail messages were readable at first,=20
but the problem occurred after automatic windows updates=20
last week and I believe this has caused the problem. How=20
could I fix this?
Automatic updates on my computer around the time the mail=20
message problem appeared:=20
Windows Media Player 9 Series (KB837272)=20
I'm new with XML. Please give me some advice.
I wonder there are any difference between XML that is automatically generated
from ADO and XML file that shows in many textbooks. I found that the formats
are a bit difference. At the begining of the one that is automatically
generated from ADO is usually like this
<xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:
- <s:Schema id="RowsetSchema">
- <s:E...Screen size upon opening of Outlook
Is there a way to set the display to Maximize when outlook opens. It seems
that every other day that when I open Outlook, I get a minimized screen.
Is there something in the registry that I can configure so this doesnt
If you create a shortcut to Outlook.EXE you can set it to open maximized.
"Craig" <email@example.com> wrote in message
> Is there a way to set the display to Maximize when outlook opens. It
> seems that every other day that when I open Outlook, I get a minimized