In Excel 2007, the open file window does not display the folders p
When I'm in excel 2007 and I want to open a new file, the folders pane is
gone. I used to have it and I even added folders that I used most frequently
but now it's gone. I know the IT deparment did an upgrade but others still
have it and I'm the only one that got affected. Please help, now I have to
navigate to get the the files that I need.
...Modeless dialog in IE through ATL/COM dll
I am creating a ATL/COM component(dll) which adds the context menu in
IE. After clicking on that menu it calls annother ATL/COM componet
which shows the Modeless HTML dialog box.
The problem is everything opens fine but suppose when i right click
conext menu and that opens the other HTML Modeless dialog. as it is
Modeless I can also click on IE's any web page. When i click on any
link it open another instance of IE. And when I closes that 2nd
intance of IE i got exception of memory in my dll workspace.
[Unhandled exception at 0x777849cc in iexplore.exe: 0xC0000005: Access
violatio...Selecting a directory or folder in Hyperlink dialog box
I am building a macro that will automate the first few steps of building a
hyperlink. Because I don't know the location or name of the file to which the
hyperlink will point, I would like the user to complete the process past a
So, I have the following items in the macro thus far (for 2007):
This opens the Hyperlink dialog box and then activates the Look In block.
Now I would like to direct it to a certain directory in the Look In block
allowing the user to complete the h...Not able to open .pst file in Outlook 2007
I am trying to open Outlook 2003 .pst file in Office 2007.
However, it is giving me this error: Cannot Start Microsoft Office Outlook.
The command line argument is not valid. Verify the switch you are using.
" If you think you can, and if you think you can't, then you are right"-
How are you trying to open the PST file?
Run Outlook 2007 then use File | Open .....
Bill R MVP
"Shilps" <email@example.com> wrote in message
&...OLE Problem on Opening
I have searched everywhere but cannot find a solution to this.
I have a c.6mb .xlsb file (c.60mb in .xls) which I am trying to open
in xl 2003. However everytime I try to open it it starts to convert
the file then just gives me the following warning "microsft Excel is
waiting for another application to complete an OLE action"
I have no other programs open when I try this, any help would be
Are there macros in the workbook? First try to open the workbook with
macros disabled (using medium security mode) and see if the ...How can I hide the main window / dialog
I use MFC to paint a picture(.bmp file) on screen. But I want the
application main window not to show on screen. How can I do that?
I tried to use dialog and doc/view mode, the best I can do is to call a
SendMessage(WM_CLOSE,0,0) on OnInitDialog(). But there is still a flash
screen of showing the main dialog then close. How can I prevent it from
"Victor Lai" <VictorLai@discussions.microsoft.com> wrote in message
> I use MFC to paint a picture(.bmp file) on screen. But I want th...file browser dialog
I need an utility let me to browse local and network folders from access
2000 and return the 'file' selected from the user.
I've found this http://www.mvps.org/access/api/api0002.htm but return only
folder name, not file name.
what can I do?
On Wed, 2 May 2007 16:03:42 +0200, "massimo" <firstname.lastname@example.org> wrote:
>I need an utility let me to browse local and network folders from access
>2000 and return the 'file' selected from the user.
>I've found this http://www.mvps.org/access/api/api0002.htm but return onl...error opening address book when adding an appointment
I have used Outlook 2000 before but when I loaded it on my new compouter that
runs Microsoft Vista I have been unable to add an apointment in the calendar.
I always get a message "An error occured when attempting to open the Windows
Adress Book. Unable to find the WAB DLL."
Excel and Word are working fine. I don't use Outlook for e-mail. And am
not trying to link the apointment with anyone else.
You are using Outlook 2000 in Internet Only Mode. It is not compatible with
Vista. You'll need to run one of the functional versions of Outlook.
...Compatibility Checker dialog box needs to state workbook referred
The Excel Compatibility Checker dialog box in Excel 2007 (which warns of
features in a workbook which aren't supported by earlier versions of Excel
which may be lost if the file is saved in an earlier format, e.g. Excel 2003)
currently doesn't say which workbook it is referring to.
This is a problem when using a .net or VBA program from Excel to manipulate
other Excel files. In our case we have a custom toolbar that reads in data
from another Excel file of the user's choice, and writes to this file, the
Excel Compatibility Checker dialog box pops up to warn "minor loss...How do I open a new excel file independant of one already open?
I know this is going to sound like a naive newbie question and yes a did do
a google search but didn't come up with anything useful. Perhaps I was
using the wrong search terms.
On my PC at work I have several excel files. Let's say for example I have
an excel file that I have opened and am working on. There may be times when
I may need to refer to another excel file. However, when I open up the new
excel file the one currently opened will close before the new file will
open. As my header suggests, is there are way to open up a new file without
having the older one close? S...Forcing a document to open in the correct version
I have both excel 2003 and excell 2007 installed on my Vista machine.
I do most of my work in 2007 (and it was installed first)
I have some work I have done in 2003 that does not work properly in 2007
(Excel froms and moving data back and forth from Access to Excel)
Is there any way I can force these files to always open in 2003 with out
making 2003 my default Excel?
I know I can open the 2003 application first then drag my file into it but
thats a pain.
I want to double cliclk on my file and have it open in the correct version.
Is there a way?
Any help here will be appreciated.
Thanks ...Open Subform in a New Window using a command button
I have a form with a subform which does exactly what I need. However, I want
to someway change the subform to a command button so when you click the
command button, it will open the subform using the same filter.
My form is frmPatent and the subform is sfRelated. The Link Child Field is
RelatedMtr and the Link Master Fields is Matter.
Can anyone assist me.
Place a button on the form and try this in VBA:
docmd.openform "subformname", acnormal,,"RelatedMtr= '" & me.matter & "'"
replace the subformname with your own subfo...Opening a document
When I click the open button in Excel, nothing happens.
In order for me to open a document I have to go and find
the document and double click on it.
Please help! This is frustrating.
Can't say why your button doesn't work, but there are other methods. Try the
File-Open menu; also the keyboard command Ctrl+O (the letter O, not zero)
will bring up the File-Open menu.
"Mel" <email@example.com> wrote in message
> HI all
> When I click the open button in Excel, nothing happens.
> In order...Retrieving archived items by opening PST file into Outlook
I find it difficult to get the hang of all this exporting and archiving
business. However, I do archive my work e-mails periodically, after first
deleting all attachments. Tonight I decided to see how easy it would be to
retrieve some old e-mail items. In Outlook, I selected File/Open and
navigated to the file Archive.pst. This created a Folder in Outlook called
"Archived Folder" with the subfolders Inbox and Sent Items. Everything looks
OK. But I have a few questions about this archive folder I now see.
This additional folder (and subfolders) are now visible in Outlook with a
large...Open Recordset error.
Could anybody look at this simple code and tell me how the g_Rs.Open()
can lead to an assertion failure? I put this code in a class function. I
have created the data source named Historical_Data...
// Open a database connection
g_db.OpenEx ( "DSN=Historical_Data", 0);
=================================================================...Can't open transaction by category report after making changes to
MS Money 2005:
1. Opened Report "Transaction by Category" on "Category = Adjustment Increase"
2. Switched to Category, created category "Increase:Adjustment"
3. Moved "Adjustment Increase" to " Increase:Adjustment"
4. Switched back to Report "Transaction by Category", report wouldn't
show-up. Reverted to "Report Home"
5. Click on "Transaction by Category", can't get to the report, always
revert to "Report Home"
Tried "Standard Repair", "Restore from Backup", can't solve ...Also minimize Excel by clicking taskbar icon without files open.
You can minimize Excel and other apps by clicking their icon in the task bar,
except Excel won't minimize if you don't have any spreadsheets open.
Frustrating to get accustomed to a feature that sometimes doesn't perform.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the ...cannot open excel file from as attachment
when i try to open the excel file and error message saying the operation
failed, the email sent to me was HTML, please help
What is the exact error message, please?
"Pegasus" <Pegasus@discussions.microsoft.com> wrote in message
> when i try to open the excel file and error message saying the operation
> failed, the email sent to me was HTML, please help
...Add-ins not loading when opening MS Access 2007 a second time
I have some add-ins that are used with an MS Access 2007 .accdb application.
When I open the .accdb file --the first time-- (after logging into the PC),
the add-ins initialize successfully. If I then close MS Access 2007, the
second (and subsequent) time(s) I open MS Access, the add-ins do NOT
They will load, however, if the user clicks on the MS Office Button > Access
Options > Add-ins > "Manage: COM Add-ins" > [Go...] > [OK] (Or [Cancel])
1. Is this a bug? Is this expected?
2. Is there some way (with VBA code) to force the Add-ins to init...Slow opening excel attachment from Outlook 2003
I have a user who is running WinXp. He is trying to open an excel attachment
from Outlook 2003. It takes about 4 or 5 minutes but it does finally open.
Others can open the file just fine.
Is there any known issue with Office 2003 products conflicting like this?
If there is, what is the fix?
...contacts folder associated with address list will not open
When I try to access my address book to get an email address I get the above
message and am unable to send my mail. What's going on and what can I do
about it? Thanks.
"DW" <DW@discussions.microsoft.com> wrote in message
> When I try to access my address book to get an email address I get the above
> message and am unable to send my mail. What's going on and what can I do
> about it? Thanks.
Sounds like the Address book service is misconfigured. The quickest cure, in
my opinion, is...Outlook 2010 crashes when opening Mac mails
I'm having this problem with Outlook crashing whenever I click an
email from certain friends who use Mac Mail. If I disable the preview
pane, it doesn't crash until i open the email.
This only happens on my XP machine (my main machine), not on my
Windows 7 netbook.
I searched online and see i'm not the only one having this issue. It
seems pretty fundamental, but I have yet to see a solution.
Does anyone know of a way around this problem? I hate the thought of
abandoning Outlook, but these crashes are sucking up way too much time
On Tue, 03 Aug 2010 10:31:03 -07...Custom form could not be opened???
Ran into this issue yesterday, and am completely stumped:
User has an email that when he double-clicks on it to open it he received
the following message: "The custom form could not be opened. Outlook will
use an Outlook form instead. The object could not be found". After saying
OK to that warning then the email comes up. What's weird is when you first
go into OL there is no icon for the message (no envelope) until you single
click on it.
Furthermore, after the email opens up then the message cannot be printed and
the following message is returned: "One or mo...Several reminders open every monday without reason
We have a strange problem here in our company. On 3
computer outlook opens several reminder ( >20, i dont know
how many there are totally) every monday morning. But for
each reminder only one date is set (e.g. birthday) and not
every monday. So how can i solve this problem? Any ideas?
Start Outlook once from the run line with the clean reminders switch -
start | run | outlook.exe /cleanreminders <enter>
Florian Bittner wrote:
> We have a strange problem here in our company. On 3
> computer outlook opens several reminder ( >20, i dont know
> how many there are totally) e...Problem upgrading project in VS2008
I upgraded my existing MFC app from VS2005 to VS2008. It uses ADO to
connect to a sql server 2005 database. When compiled under VS2005 the
connection to the server via the _ConnectionPtr interface opens
When compiled under VS2008, the first time in my app takes around 30
seconds to return from _ConnectionPtr::Open, though if I close the
connection and then open it again it's back to near instant. And the
app runs 100% fine thereafter - no crashes, freezes etc.. (I've had to
increase the timeout on the connection, as otherwise it just timeouts.