Editing options disapear when document is changed to compatibility
I have an excel (2007) document with makro content that has been edited by
other people. One of them changed the document to a shared document
(compatibility mode) to be able to track changes. Now the document seems to
be partially locked. I am hadly allowed to change any kind of formating or
insert anything. How do I change back the document or get rid of whatever is
blocking me from using many functions?
> I have an excel (2007) document with makro content that has been edited by
> other people. One of them chan...Referring to a range that has been copied (Excel-VBA)
Can anyone confirm if there is a way in VBA to refer to a range that
has just been copied but that it is not the selected range?
For example: I select Range A1:A2, I press Ctrl+C and dotted moving
lines appear around A1:A2. Now, I move to any other cell, say B4. At
this stage, A1:A2 remain highlighted with the dotted lines, so I
understand that the Application "knows" of them, therefore how can I
return their address through code? Selection.address will obviously
not work as it is no longer the selected range...I looked within the
Application object but could not fin...Counting words............
How can I give the total of how many times a word appears in a column?
Smokey_Vol's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29717
View this thread: http://www.excelforum.com/showthread.php?threadid=495182
have a look at
"Smokey_Vol" <Smokey_Vol.firstname.lastname@example.org> wrote
in message news:Smokey_Vol.email@example.com...
>...how do you rotate a visio drawing in word?
It's easy to insert a visio drawing into Microsfot word, but it doesn't seem
possible to rotate the drawing...?
zoom out to see full page, hold ctrl key down, place cursor via mouse to
corner of drawing page, see cursor pointer change to curved arrow, drag to
rotate page, angle shows in bottom left corner of screen, angle accuracy
controlled as usual.
"TJ" <TJ@discussions.microsoft.com> wrote in message
> It's easy to insert a visio drawing into Microsfot word, but it doesn't
> po...the application microsoft (word, excel and powerpoint) quit unexpectedly
Operating System: Mac OS X 10.5 (Leopard)
installed microsoft office 2008 in october 2008, and had no trouble.
as of may/june 2009, i no longer wanted these icons (icons for word, excel and powerpoint) on my dock, and so removed.
now when i try to open these applications, the message;
the application microsoft word quit enexpectedly. mac os x and other applications are not affected. click relaunch to launch the application again. click report to see more details or send a report to apple.
the report then says:
Process: Microsoft Excel 
Path: /Applicati...Problem with vba directory function
We have an access application that has a button when clicked opens an excel
worksheet showing all exported data based on code
The access sql system is in Citrix with a single front end copy.
Here is the code part that is throwing the error for just one user.
Rest all are working fine
Dim strSourceFileName As String
Dim WorkBookName As String
strSourceFileName = "c:\CarLogOutPut\CarLogExportTemplate.xls"
WorkBookName = "c:\CarLogOutPut\CarLogExport.xls"
If Dir(strSourceFileName) = "" Then
MsgBox "CarLogExportTemplate.xls doe...Word Documents
Operating System: Mac OS X 10.5 (Leopard)
Hi, How do I make tool bars appear automatically upon opening a new document? Each time I open a new or previously saved document I have to re-open my tool bar. I have been unable to find where I can make the tool bar freeze in place and open when I open documents. I am a college student with lots of papers to write. This gets cumbersome after a while. Please help. Thank you Wendy.
Click the oval button at the right end of a document window to turn off
Apple's poorly documented & unidentified 'minimize...Compress pictures in word 2000
How can i compress the pictures in my document using word 2000. I can not
find it in format picture and am now at a loss
Thank you for reading my post. Hopefully you can answer my querie
...Lotus Documents in Excel
At my business, we use Lotus 1-2-3 for any of our worksheets. However, more
and more of our customers are using Excel and no one really has Lotus. My
boss was wanting to know if there was a way to transfer all of our Lotus
Documents into an Excel spreadsheet instead of Lotus.
If they are simple, you can simply save them from 1-2-3 as Excel files. If they have macros, you're
in for a rough time.
MS Excel MVP
"Krissy86" <Krissy86@discussions.microsoft.com> wrote in message
> At my ...how do you insert a document in words 2007
I need help inserting a document in Office 2007, please help.
Insert - Object
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"Likita Rucker" <Likita Rucker@discussions.microsoft.com> wrote in message
>I need help inserting a document in Office 2007, please help.
If you click Insert > Object and pick Object from the dropdown, you'll
get only the first page of the insert because an "object" can't cross
a page boun...M2005 -- one word.... UGGGHHH!!!
I just got the demo... was using M04 small biz. Very disappointed.
1) Runs like a SLOTH in need of a NAP, on my 3.4GHz P4 / 1GB ram.
2) MSN crap littered in every nook and cranny possible.
3) Apparently uses IE engine to "render" all pages so everything has a
clunky "web-browsery" feel to it.
4) No "Find" function?? How do I just "Find" a transaction across all
5) Money Express has gone by the wayside... apparently they want you to use
MSN Alerts. Well, I don't have MSN Messenger installed on my machine
because I...Can't See Word Check Boxes in Outlook
I have a Word Document that I wish to send via the File->Send To->Mail
Recipient once it is filled in. The document has questions that require the
User to select a check box for the different selections (Excellent, Good,
Poor, Very Poor). When I send the document, the check boxes show up in
Outlook, however when the email arrives the check boxes are no longer there.
Is there a way to have the check boxes show up in the email, or, are they
somehow being stripped?
...how do i print a smaller image of my saved document?
I forgot how to do this. My age is taking its toll!
Don't blame age, as I don't think Word has any built-in way to do this
unless you're thinking of the Zoom feature in the Print dialog, which allows
you to print multiple pages per sheet.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"wallyb" <firstname.lastname@example.org> wrote in message
>I forgot how to do this. My age is taking its toll!
...How do I create a horizontal document in publisher?
I want to create a 6" high X 11" wide document in Publisher and do not know
how. Anyone have the answer?
Start a new document and set your page up with those dimensions.
Microsoft MVP - Publisher
How to ask a question
"chirostv55" <email@example.com> wrote in message
>I want to create a 6" high X 11" wide document in Publisher and do not know
> how. Anyone have the answer?
What version Publisher?
If you ar...Word as Editor in OL 2003
I'm trying to use Word as my html editor in OL 2003. I must have changed a
setting and now the text I see is about 18 pt. Arial instead of the 10 pt.
Arial I see if I use plain text. Is there a setting I can change? Thanks.
"hank" <firstname.lastname@example.org> wrote in message
> I'm trying to use Word as my html editor in OL 2003. I must have changed a
> setting and now the text I see is about 18 pt. Arial instead of the 10 pt.
> Arial I see if I use plain text. Is there a setting I can change? Thanks.
...Contatcs interfering with Word Mailmerge
Hi - I have been using MVP Doug Robbins' solution for sending attachments
with email merges in Word
everything is fine EXCEPT that Outlook seems to be overriding the email
addresses I specify in the Wred directory file and replacin with email
addresses it 'thinks' fits the addressee best. I've no idea how irt is doing
this. I have corresponded directly wit Doug in the Mailmerge Group - he had
never seen this - suggested I try here. Any ideas!?
Not without any information. The followi...how to only show first 20 words of a memo field
I have a memo field on a form, how can i show the first 30 characters and
add 3 periods after the first 30 words.
Message posted via AccessMonster.com
Use the Left function and add 3 periods:
Left(string, length) & "..."
"sheniece via AccessMonster.com" wrote:
> I have a memo field on a form, how can i show the first 30 characters and
> add 3 periods after the first 30 words.
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums...VBA Help #4
I have a list of clients with their associated outstanding dollar
amount and their return (%). I would like to know if there is code
that would allow me to break up these clients by return (%) groupings.
For example, I would like to group below 10%, 10% to 17%, and above
17%. So at the client on the list that is just before 10% I would
like to add two rows and put a dollar subtotal in the immediate row
and sum the dollar amounts.
Can anyone help?
Public Sub ProcessData()
Const TEST_COLUMN As String = "A" '<=== change to suit
Dim i As Long
Dim LastR...expanded comments on documents
I would like to have the ability to put lengthy transaction descriptions on
documents and in GL transactions. Currently, description fields are limited
in the GL. Additionally, notes/comments can be lengthy, but report fields
for them are limited in the number of characters that appear on the reports.
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 Mic...you do not have credentials that allow you to open this document
When i open a existing .doc document.It shows message "like you do not have
credentials that allow you to open this document.Do You want to open it using
a different set of credentials? " i can't able to open any .doc document
...How to dete items in 'Recent Document' window
When one clicks on the office button, a window pops up showing a long list
of previous opened Excel files. I would like to delete those items that
reference a CD drive. How do I do that?
See the Ribbon Tips section on this page (Dictator examples)
There is a workbook that you can download with a example to disable the list
Regards Ron de Bruin
"OldManEd" <email@example.com> wrote in message news:O%23LyAb5jIHA.5956@TK2MSFTNGP03.phx.gbl...
> When one clicks on the office button, a window p...Need A formula in VBA ,Similar to NETWORKDAYS in excel
I would like to get only working days after excluding satuday and sunda
and holidays. Holidays will be there in the range of sheet
There is one formula in xls (NETWORKDAYS) , It would be appreciated i
you can make it similar one. The format of NETWORKDAYS is
Message posted from http://www.ExcelForum.com
On Mon, 12 Jan 2004 22:03:12 -0600, jophy <<firstname.lastname@example.org>>
>I would like to get only working days after excluding satuday and sunday
>and holidays. Holidays will be there in the rang...Export Data to MS Word Table and Format
I've gathered code from other posts and have come up with output to a
Word document that is acceptable (thanks to everyone for sharing).
I would like know if it is possible to format the table in MS Word.
1) Left justifying the 1st column, and centering the data in columns 2
2) Is there a better way of handling the column widths to
automatically size to the widest data in the column.
3) Any good resources to help export data to MS Word.
Here's what I have so far...
Dim oWord As Word.Application
Dim oDoc As Word.Documen...Send the Document, may differ some place due to cell contents...
I think subject wasn't so good that tell you what i wanted to do...
I have a text that is about an a4 page in Word.
I have an Database of about 150 firms. And two colums; Company name &
Company name Producktivety
And so goes.
And the text is like;
Company name: a
Company productivety: 90
-...Converting Excel with Word
Hi to everyone.
I have a table in an Excel sheet. In every row of the table included some
information’s of a number of persons (Name, address, age, work hours,
I also have a doc file in Word, which i use it like a form, to connect the
above information’s in some points in the doc.
I would like to convert somehow the Excel table to word doc applying 2
a) Every time that i change a value of a person at the Excel table,
automatically updating the corresponding doc file
and b) If i must add new persons in the table (that means new rows), also to