Why is Excel being opened in Outlook?
I emailed an Excel file to a colleague. It was sent as an attachment in
Thunderbird. The recipient - who uses Outlook - saved the spreadsheet to disk.
Now if she tries to launch the file (either from Explorer or from within Excel
itself), it actually opens up inside Outlook and starts to create an email
message. This only occurs if Outlook is already active. It also only occurs with
some of the spreadsheets that I sent her.
You sure your colleague isn't just seeing the "envelop".
File|send to|and see if "mail recipient" is depressed.
> ...Creating views of customized folders and filters programmatically
I am writing an application in which i need to create a customised
mail folder, which will sort the incoming mails of my company as and
when the user receives it. The problem is that i don't want to go to
each and every machine and configure this manually, but want to create
a setup/exe, which will create this customized folder for me along
with the necessary filters i.e. grouping of mails according to the
Any help on this will be appreciated.
...#Deleted in feilds of record in Table Access 2003
Periodically we find a record in a table that has #Deleted in all feilds of
the record. It can not be deleted. The database must be compacted and
repaired and then the record can be deleted. This is usually discovered when
a user open a form that uses a query linked to that table and they receive
"Record is deleted" window. The record is not deleted by any users. Seems
to be a false state.
Last occurance - someone indicated they were in the record put in this
state. They used the back space to clear information in the record. That
was only known change to the record.
Help !! - I want to update my excel pricelist from an
updated supplier's excel price list.
Column A has Suppliers Code in both Worksheets
Column B has Suppliers price in both worksheets
If text in cell of Column A (my worksheet) = Text in cell
of Column A (suppliers worksheet)
Replace Value of appropiate cell in Column B (my
worksheet) with the Value of appropiate cell in Column B
My W/sheet Suppliers W/Sheet
Code Cost Code Cost
AAAA $5.00 AAAA $5.00
BBBB $4.00 BBBB $4.50
Want to replace the val...Clearing the data in the socket..
Can anyone tell me how to clear the data in the socket after
Thanx in advance..
"Wallace" <firstname.lastname@example.org> wrote in message
> Can anyone tell me how to clear the data in the socket after
> receiving it??
static const unsigned nRead = (10*4096);
memset( pTmp, 0, nRead );
int nActual = Receive( pTmp, nRead );
I am not sure I understand, calling Receive(...) will remove the data.
if the data is greater than (10...Excel 2003 back to Excel 2002
I have been using the Office 2003 demo ans like it.
I can't afford it right now.
So I have to go back to Office 2002 XP.
Will docs I have worked on in 2003 be able to
be read back into Word, Excel 2002 XP.
Is there anything I should do before
going back to 2002 XP before un-installing 2003
to make sure I can read my the doc in 2002 XP?
Word and Excel documents will work without a problem. Access 2003 though may
Pete Carr wrote:
> I have been using the Office 2003 demo ans like it.
> I can't afford it...excel 2007 show number of recent documents
Recent documents are not displayed. When I go into Excel Options to Display
- "Show this number of recent documents" 'the number field is grayed out.
How do I set it?
Is there currently a value in the feild?, try clicking the information
icon next to it for help!
The Code Cage Team
The Code Cage Team
The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=31273...Excel 2003 + help please with button
Hi all, can anyone tell me why i'm getting a Compile Error: Syntax Error on
For lng = 0 me.ListBox1.listcount - 1?
Dim lng As Long
Dim col As Collection
Dim wb2 As Workbook
Dim ws As Worksheet
Set col = New Collection
For lng = 0 Me.Neil.ListCount - 1
If Me.ListBox1.Selected(lng) Then
If col.Count = 0 Then
MsgBox "No Selections"
Application.DisplayAlerts = False
Applicat...drop down menus in excel #2
is it possible when using a drop down menu to have an error message pop up
if you've selected something that has already been used. Example - if you are
making seating plans where you want to make sure you don't select the same
There's an example here for preventing duplicate entries with data
Or you can hide used items in the dropdown list:
rowing coach wrote:
> is it possible when using a drop down menu to have an error message pop up
> ...Why would Excel slow down
I am using a basic table with no calculations or associations. A couple of
days ago it started to save very slowly. It takes it 1 1/2 minutes to save
the file. It's only 870 rows with 12 columns. It's all just basic data. I'm
afraid of loosing it. I backup every few minutes, but it makes working on it
take forever. Does anyone have any ideas? Nothing else on the computer has
"Muggs" <Muggs@discussions.microsoft.com> wrote in message
news:813C21...Is there an easy way to create a calendar look up table in excel
I want different dates for milestones in a row of my excel file. Is there an
easy way to create a date drop down table. When I click on the arrow for the
drop down list a little monthly calender would pop up and I could choose the
date I wanted from the calender.
...Linking to Files in other Folders using Excel VBA
I want to create a macro in a workbook that automatically links to
other worksheets. For instance, if i run the following code below, cell
E12 will automatically link to cell E12 in sheet "Accounting Data" of
file "6460.xls" in folder "C:\My Documents\Accounts\
Range("E12").FormulaR1C1 = "='C:\My
I could repeat this code over and over again in reference to other cell
ranges, but I'd like to clean it up. I've attempted to do so, with the
'-----------------...Outlook 2007 stops acquiring data from Exchange
A week ago I noticed that Outlook 2007 on an old desktop in a guest
room no longer was downloading any data from the Exchange server at
work. I have tried absolutely everything I can think of but nothing
seems to change this. Meanwhile, three other computers at home (we
have a site-license arrangement which allows us to use Office on our
home computers) with Outlook 2007 are having no problems at all with
my Outlook account.
Here is what I have tried so far:
1. Deleting the .ost file. Outlook acquires a few thousand kilobytes
of data and then simply stops. The last entry in event viewer is an...Removiing decimals from an excel number
Here is the issue: I have numbers like this one - 10000.01.01.200
I just want the prime number 10000. How can I do that? I tried Ctrl+F and
replace but is there a more efficient way?
Gary''s Student - gsnu201001
"Data Analyst" wrote:
> Here is the issue: I have numbers like this one - 10000.01.01.200
> I just want the prime number 10000. How can I do that? I tried Ctrl+F and
> replace but is there a more efficient way?
=LEFT(A1,FIND(".",A1,1)-1)...Excel Conditional Sum
I am trying to add items delivered to our facility by
month. I have column a listing dates by day (date format:
7/14/2004) in column A on a worksheet tab called 'daily
activ', column B lists the number of items delivered each
day. On another worksheet tab called 'growth' in the same
document I have the various months in column A (June, July,
etc). In column B I would like to apply a formula pulling
from the 'daily activ' tab to sum items for only for that
month. I would also like the formula to use a wildcard so
it only looks at the month and year. I tried applying ...camera driver problem
o.S: Windows CE 6.0
I am working on camera module for the omap3530 with sensor ov7670, I built
the application CameraDshowApp.exe from private copied into my platform. The
camera driver get loaded and successfully registered. After boot up, I
executed CameraDshowApp.exe, there are few options specified as below, I
selected options 1 to 4 and clicked OK.
1. Video capture 2. Video encoderer 3. Still image sink 4. File Mux 5.
VideoRenderer 6. AudioCapture 7. Audio Encoder 8. IntellConnect 9.
Nothing I can see in the display window, it w...SmartList retrieval of year-end data
For the auditors I have been recently extracting Credit and Debit account
What I found is that when in comparison to other dates , if the smartlist is
filtered for transaction dates restricted to 31st Dec data , the query takes
an inordinately long time [almost 20 times more] to complete and after the
query is completed , the volume of data in terms of data is not much
different from others...
What could be the possible cause for this slow response ? Is it related to
how GP stores year-end data and more crucially how can I overcome this issue?
Thanks in advance,
...Scanning and Excel
I have a great question. Would it be possible to take a
document that I scan in with monetary figures on the
document and create a corresponding spreadsheet to where
the monetary figures populated the corresponding fields
on the spreadsheet (i.e. mileage on the scanned document
would populate the mileage field in excel, so that I
could calculate the total cost for mileage)Any help would
be greatly appreciated.
I would think that this would depend on your scanner and the software that came
And if you got lucky enough to have a scanner that did it and an accurate OCR
program, t...Re: Data Summary
Can we do the summary by defining a macro?
The difficulty with the suggested solution :
1.I am not able to advance filter the unique data to a separate
2.Every day the data gets changed, so have to repeat the exercise
daily and is very time consuming.
Subject: Re: Data Summary
From: "Ardus Petus" <email@example.com>
In summary sheet, you can get the totals with a formula like:
See example: http://cjoint.com/?fmkJhzVi8q
To automate the production of ...Click on Excel Doc Starts Excel but Excel does not Open the Doc.
When I click on an Excel doc., Excel starts up but does not open the doc.
When I rgiht click an .xls and then choose Excel to open it it says that
Excel cannot find the document on the indicated path. The path shown is
indeed the path to the doc and the doc is there.
When I drag an .xls into a runing Excel it opens correctly.
Other apps. such as Word open the docs correctly but cannot open docs with
links to Excel sheets.
Try looking at this:
Tools | Options | General
Uncheck "Ignore other applications"
Tools>options>g...Event 16387 Error: Deletion Service failed to clean up some tables.
I'm having the following error with one of my CRM v3.0 deployment
Event Type: Error
Event Source: MSCRMDeletionService
Event Category: None
Event ID: 16387
Time: 10:17:20 AM
Error: Deletion Service failed to clean up some tables.
For more information, see Help and Support Center at
Got the following when I run the crmdeleteservice.exe command.
is it by importing a excel-table to visio to import also the name of the
excel-sheet as headline or name of the sheet?
Thanks - Angelika
...how do i save an excel file as .xbrl?
is there an add-on that allows .xbrl saves?
On 4/11/2010 10:45 AM, Frank wrote:
> is there an add-on that allows .xbrl saves?
I guess you'd need to tell us what an xbrl file is...
...Can I create an invisible MDI child window
I need to create a MDI child window to load document then print the document
to printer. There is no need to show the MDI child window. I tried to use:
CFrameWnd* pFrame = (CFrameWnd*)pTemplate->CreateNewFrame(pDoc, NULL);
pTemplate->InitialUpdateFrame(pFrame, pDoc, FALSE);
But the result is my document is not loaded, so print will fail.
I even tried:
CFrameWnd* pFrame = (CFrameWnd*)pTemplate->CreateNewFrame(pDoc, NULL);
But the MDI window is still visible when the document gets loaded.
Is th...how to format data with an input mask like ss# (***-**-****)
I am trying to format text with an input mask like the one used for a SS#.
But what iI need would look like this (***-***-***-**-***). Is there a way to
add this to the "canned" format selection?
Thanks in advance for your help
Try Format Cells -> NUmber -> Custom
> I am trying to format text with an input mask like the one used for a SS#.
> But what iI need would look like this (***-***-***-**-***). Is there a way to
> add this to the "canned" format selection?
> Thanks in adva...