Displaying Multiple-Page Linked OLE Files in Excel
Is there a way to display more than the first page of a multiple-page Word
document linked to an Excel spreadsheet as an OLE object? It's possible to
click through to the original document, but I'm unable to find a way to
display the entire document within Excel without distorting the image.
...Data not downloading to .xls file but it is in the database
OK, I am relatively familiar with Access 2003, but I have been asked to
figure out why the data in that is entered into the database shows it when
looking on the database but it is not generating it to the list of updated
documents. Here is a bit of the background...I just started working at this
company 2 days ago, well the file is an excel file but the path for the file
is generated to a person's C: drive who no longer is employed here. I am
trying to change that path...and am having no luck. Any help would be so
Is the file even on their machine? You...The best photographer
He is the best famous photographer..
...how disable msg: "Your files are attached & ready to send"
In Windows explorer when I want to e-mail a file, I right
click on the file, select Send To and then Mail
Recipient. In the resulting Outlook window, It always
includes in the body of the e-mail: "Your files are
attached and ready to send." How do I disable getting
this message in the body of the e-mail. It really serves
no purpose and gets in the way of any message I want to
write. Thank you.
Just delete the text & change the subject line - or instead of doing it this
way, create a new message, and attach the file (browse to it).
> In Windows explorer w...downloaded file has no file extention
Downloaded a file using utorent but the file has no file extention. Tryed to
unrar the file but that did not work.
Thanks for sharing.
How to ask a question
How To Ask Questions The Smart Way
"b11_" <email@example.com> wrote in message
> Downloaded a file using utorent but the file has no file extention. Tryed
> unrar the file but that did n...Best text books / manuals for MS Office (intermediate-Advanced use
What are the best (most highly reccomended) text books / instruction manuals
you can get for Access, Excel, PowerPoint, Publisher, & Word and also VBE?
I consider myself to be Quite proficient in Excel......Can produce a decent
document in Publisher.......Can "Get by" in Word....Not enough knowledge of
Access......Only used PowerPoint once.......
I started using BASIC (the programming language) back in the '80s, so I have
some knowledge of VBE (Formulas & syntax are quite simular from what I see
I have created several Excel projects with Macros bu...Windows File Explorers could allow fonts face and color changes.
When I look at the desktop, I sometimes wish I could sort my files and folders.
I imagine a system of boxes or cells to group items. The Desktop would look
like a table of cells and the user would be able to put for example all the
work files & folders in a cell, all the personal files&folders in another
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 ope...Where is the best place to put notes?
We are new to MSCRM and are not used to all of the possible places that you
can enter notes. Has anyone created a structure for their company as to what
notes should be entered where?
There are many ways to handle notes. You have accurately identified that
notes are kind of disjointed. What you might consider doing is creating a
central notes depository in Sharepoint and then adding a customization with
an inline frame that shows the Sharepoint notes repository in several
different parts of CRM.
In general, you have not provided enough information on what you are trying
to ac...Loading PivotCache directly from a text file
According to the Excel online help, the PivotCache.Connection property can be
set to "the path to and file name of a text file". I tried setting it to the
path and file name of a .csv file and it returned an error. Is there a way to
load a PivotCache directly from a flat file without having to load into a
spreadsheet or database? (The flat file has more than 1 million rows.)
...what is the best way to resize test that "best fits" the text box
I just want to know how to resize text to fit the text box.
Select the text and reduce the font size until it suits your requirements.
There is no automatic function for this.
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
"utahjohn" <firstname.lastname@example.org...Macro to Fomat Excel to .csv File
I have an Excel spreadsheet with contact information I want to import
to a CRM lead system. Current Excel sheet format is all in one column
going down as follows: Company Name, Address, City State Zip (all one
field), Phone number, then empy cell then repeat of 4 cells listed
above. Want to convert to a new .csv file with listing going left to
right on on line as follows (ending up with 6 column fields - 1.
Company Name 2. Address 3. City 4. State 5. Zip 6. Phone
Any suggestions on how to accomplish this? Thanks.
...Upgraded to Beta 2007 and files aren't being read
The files we created a week ago w/ the first Beta verson are now, not being
read in the latest Beta upgrade. Any one having this issue or do you know a
How to use Office programs with the Norton AntiVirus Office plug-in
Mary Sauer MSFT MVP
"Mqueen" <Mqueen@discussions.microsoft.com> wrote in message
> The files we...Outlook 2007 cannot open .pst file
I just installed Outlook 2007, then moved older outlook pst files
successfully into my new Outlook.
However, I closed it and then restarted it. It claims that it cannot
open the Outlook.pst file anymore.
In trouble, need any and all input as to how to fix it; other than
completely reinstalling it. I will loose some new email that I
Which method did you use to reconnect your older pst-files? "Moved it" is
not a valid action nor does it describe exactly what you did.
The proper way to reconnect...Defrag/Reduce STM File
Can I reduce or defrag the STM File?
We have Exchange 2000 organization. All the clients use Outlook to access
their mails. We have some users for whom we have configured to forward
e-mails to their external mail accounts. We have not enabled OWA. Then
also, the STM file size has reached around 5GB.
My EDB file has also reached almost 11GB. I am reducing it by offline defrag.
But, how to defrag STM file? How can I reduce the size of STM file?
Thanks in Advance,
On Fri, 26 May 2006 04:51:01 -0700, Denis
>Can I reduce...Error saving a Shared Workbook
I have a user using a shared workbook and gets an error
everytime she does this ONE specific change. She deletes
a line and then saves and gets a message that
says, "EXCEL.exe has generated errors and will be shutdown
by Windows... blah blah blah". If she makes anyother
type of changes it saves just fine. I also had another
user do the SAME change and that person also got that
error message. When the file is changed to "Not Shared"
then the line is deleted it saves fine also. The problem
is obviously with the file itself and that is shared out.
can anybody ...How can I save embedded files as gifs
I use Outlook. When I try to save an embedded gif file by right click/save
files I can only get the option to save a s BMP. How can I change this?
Empty your Temporary Internet Files and try again.
> I use Outlook. When I try to save an embedded gif file by right click/save
> files I can only get the option to save a s BMP. How can I change this?
...Best way to forecast individual sales territories?
I have a spreadsheet with twelve months of sales data per territory (100
territories.) I need to forecast the next three months. The product being
sold is just moving from launch phase to high growth phase, so it's still
growing pretty quickly. What is the best method to forecast each individual
territories' sales over the next three months?
<No response from other forum>
Hello, I have a Exchange 2003/OWA frontend that is protected with RSA two
factor authentication inside a Checkpoint Firewall.
The RSA part works fine and everything is good. Now I buy a Motorola Droid
and need to set up the Exchange Sync and the RSA poses a problem. If I
remove the RSA protection the Droid connects to the OWA and syncs well.
Calls to RSA says it will not work with a Droid so I'd have to get rid of
the RSA authentication.
The question is: it looks like if I want to use a Android 2.0 based Droid
phone to sync with outlook...filtering out "temporary internet files" from journal
I like logging the word documents I work on in my
journal. However, word documents that I open as e-mail
attachments also record in the journal (those that get
filed in my "temporary internet files." I'd like those
Word attachments NOT to be logged in my journal. I know
there is a filter in viewing the journal. I would like a
way to filter out those word documents from the "temporary
internet files" folder.
what really is the best practice method for brining in monthly GL figures so
users can get comparative statements this year/lastyr.
do you bring in all the old detail journals? or do you load via a
maintenance or IM the historical balance for each month in some file.
You mean when you are starting up a new company?
If so, unless someone needs the detail imported into GP for other reasons, I
bring in a beginning balance and monthly net changes only. For example,
let's say you're starting to use GP with January 2009, your fiscal year ends
in December and y...Exceptionally large files
I have found that Excel files for which I pivot tables and filters take up a
lot of storage space. Is this normal?
It depends on what is in the file and what you mean by "a lot" of
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Ronaldo" <email@example.com> wrote in message
>I have found that Excel files for which I pivot tables and
>filters take up a
> lot of storage space. Is this normal?
> Ronal...Money 98 'caching' *.mny file?
I know-- it is an antique. But Money 98 works for me & I've tried to
upgrade once- spent a couple months to determine it would be more work
than it is worth. [I have a couple accounts that will not make the
change and I can't figure out why.]
So I upgrade my desktop and install Money 98. I am struck with how
fast it loads, but figure it is the new processor.
I have a home network & sometimes use the mny file on my laptop. but
when i synchronize the mny file- though it doesn't complain then- When
I open Money it says the file might be read only. Or it mig...Restore Outlook 2000 without .pst?
I backed up a computer to a dvd but forgot to export outlook 2000 to a
pst. Is there anyway to get the info back?jho
jho <firstname.lastname@example.org> typed:
> I backed up a computer to a dvd but forgot to export outlook 2000 to a
> pst. Is there anyway to get the info back?jho
No. If you don't have the PST file, you don't have any data.
Note - you don't need to export anything. You can just copy/back up the
existing PST file(s) next time.
jho <email@example.com> wrote:
> I backed up a comput...double click excel file doesn't open it
I have astrange problem when i double click excel file, it opens exce
but doesn't load the file. (excel opens with blank worksheet).
anybody can help
kman's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=333
View this thread: http://www.excelforum.com/showthread.php?threadid=48815
Try Tools/Options/General and untick 'Ignore other applications' (if it's
"kman" <firstname.lastname@example.org> wro...Outlook data file dupe listings in navigation pane
After installing Office 2003, I made the mistake of creating an email
account BEFORE redirecting Outlook 2003 to use theexisting .pst file,
residing in the My Documents directory. I finally succeeded, but with the
unwanted consequence that there were TWO personal folder files listed in the
navigation pane. At first, they mirrored one another. After some fiddling,
the details of which I've forgotten, one functioned as a normal default
Outlook data file, while clicking on the second resulted in an error message
to the effect that the object could not be found. This occurred even after...