Converting a Microsoft Word document to a PC document
Operating System: Mac OS X 10.5 (Leopard)
I have created a Resume and a cover letter in Microsoft Word on a Mac to be uploaded to the Institute ORACLE recruitment system. <br><br>When I checked how it looked, the format, the bullets and formating were blown apart! I was told to convert the documents to PC format. <br><br>I don't know how to do this. I got some guidance to make them PDF files, but the formating still goes haywire! How do I do the conversion on my Mac?
The most important thing to do is DO NOT TEL...Copy and Paste not saving format changes
Operating System: Mac OS X 10.5 (Leopard)
I just bought Microsoft Office for Mac early this month and am still getting used to it. Can someone help me with this:
I have several documents typed onto a notebook layout with lots of bullet points, color changes, cross outs and the like. I wanted to copy and past all of that into a new document but when I did ALL of the formatting changes were lost. There were no bullet points, so the text flushed left, yada, yada, yada.
I looked around the toolbar to try and find a setting that would allow me to do the cut an...EzPaste-xl2ppt Excel add-in, automating the copy/paste of charts and data
This is to notify about the release of EzPaste (http://
www.EzPaste.net), an Excel add-in intended to completely automate the
transfer of charts and data from Excel to PowerPoint.
EzPaste identifies automatically all the charts and the tables defined
in the active workbook. The user then selects which of them he wants
to paste to PowerPoint=AE , and EzPaste does all the work, would you
have to paste one or one hundred tables/charts at once
Even if you have to paste the selected range or chart, EzPaste does it
with the click of a button
Sorry if this message is a bit advertising, b...Exchange rich-text format
What are the results from the client side if I change my Exchange 2003 server
to "Alwayes Use" Exchange Rich-Text format from "Determined by individual
On Thu, 22 Jun 2006 08:31:01 -0700, CK <CK@discussions.microsoft.com>
>What are the results from the client side if I change my Exchange 2003 server
>to "Alwayes Use" Exchange Rich-Text format from "Determined by individual
Depends on what your users are sending messages as. Most will be using
HTML or RTF anyway unless you have some policy in p...Defaults on Print Sales Documents screen
Is there a way to set defaults on the boxes selected under the Picking Ticket
column on the Print Sales Documents screen? Currently when we open the
screen, we have to select which boxes to tick and since we always select the
same boxes we wondered if there was a way to have them default when the
screen is opened so we don't have to click each time. We want the "Picking
Ticket Per Site" box, the "Include Kit Components" box and the "Bin
Sequenced" box selected as default values.
You can accomplish this with a small VBA customization, b...How to remove the alternative text box from the publisher email?
I have created a publisher email and have email it to myself for testing
I find there is a small alternative text box appearing whenever my mouse
cursor station at any point of the email.
How to remove this alternative text box from the publisher email?
Sounds like all the text has was converted to an image. Try to select the
text and you will see it is an image.
Go to tools > Options > Web tab and under Email options uncheck the option
to send as an image.
If that doesn't fix the problem, reference: Tips and troubleshooting for
...hyperlinks within the same document are not working
I am trying to create an email publication in MS publisher 2007. It has
several stories that will be sent out in email and the first section is
supposed to contain a summary with hyperlinks to each story within the same
email for more details.
I am adding a bookmark at the begining of each story, and then trying to
create a hyperlink in the summary section to the bookmark.
However, when I send the publication as email, or do an email preview, the
hyperlinks do not work.
...spell check does not visually cycle through cells when run from macro?
I'm trying to recreate the same behavior in a macro that spellcheck has when
the spellcheck button is pressed. The spellcheck does not cycle through the
cells visually when run from a macro, so when there is a misspelled word,
you cannot see the cell it is a part of.
If anyone knows how I can get this behavior to work, it would be GREATLY
I did a record new macro, and got code similar to the following:
Add the fiollowing to your code as shown:
...If statement with formatted text
Is there any way to have an if formula such as:
If (A1="Active", "KAE",KPE")
where the two letters after the K are formatted as subscript?
The best I've done is to paste a picture over the cell. The picture's
formula refers to named formula that selects one of two cells, the one with
correct string. One cell contains KAE and the other KPE with the subscript.
However, it means that I'm using a picture and it would be much nicer if I
could just do it in an If formula.
I hope that makes some kind of sense, and thanks in advance for your help.
I am trying to set up our Business Portal to be as easy as possible for our
One of the requests they have made is the ability to find out WHAT PO is
COMMITTED to the SPECIFIC line item in an order. Similar to actually looking
at GP Sales Transaction Entry window where it gives an icon to show that the
item has been purchased, what PO it's been committed to.
I have spent hours trying to make this happen. Has anyone else been able to
do this? If so, I would appreciate detailed steps.
...Setting directory for file save in macro
Thanks to a generous poster I now have a great bit of code to use in a macro
for Excel which saves a text file (I'm no VBA programmer so this was really
Open "Test.txt" For Output As #1
(rest of code)
My problem now is this:
The macro saves test.txt to Excel's current active folder, rather than the
folder that the current workbook is contained in.
For example, if I last saved an Excel workbook to c:\workbooks\, and the
workbook that I have open exists in c:\workbooks\workbook1\, when I run the
macro it saves the text file in c:\workbooks\. If I ...Change from MS Outlook Rich Text to HTML
I use Outlook 98 and I want to change my message format to HTML so that
I can have nice backgrounds etc on my mail. For some reason this
facility doesn't seem to be available to me on the 'Mail Format' Tab.
It is blacked out and I cannot change it from Rich Text to HTML. Is
there anything I can do to sort this out? Could it be because I am on
a network at work and they have disabled it? If so, how can I enable
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www...Using cell text in a formula
I am trying to use derived cell references in a VLOOKUP formula to matc
data in several tables. For example, A1 contains the cell reference fo
the top left of my array (A3) whilst cell A2 contains the cel
reference for the bottom right of my array (D14). The array I'
checking against starts in column E3.
However, when I use the formula =VLOOKUP(E3,A1:A2,4,FALSE) I get a #N/
error. I need to use the cell references in each VLOOKUP as the arra
sizes may vary in each case. (PS, I've used =INDIRECT(ADDRESS(A1,A2)
to derive the cell references.
Message posted from http://www.Excel...Trouble with hyhens within text when using LOOKUP
I have two columns, each containing a list of part numbers. Some of the part
numbers contain hyphens.
I am using LOOKUP and/or VLOOKUP to determine if the value in one column
exists in the other. This works great on non-hyphenated part numbers.
However, it will not find or return the hyphenated part numbers from the
specified arrays. As a test, I did a quick if statement to compare the
instances of identical hyphenated values that exist in both columns. Those
statements did not have a problem with the hyphens. Can anyone offer any
help? If hyphens cannot be used in conjunction with the ...Saving html message as Draft changes text formatting...
WIN XP HE,
I have recently noticed that whenever I write an email (using Word as
editor) in html format, and instead of sending it, save it (to the drafts
folder), the text itself changes format from my default to another one.
It seems to change in the paragraph style which then changes the text
The only change I recently made was to edit my signatures in html, rtf and
plain text format.
When I write a new email, it opens up with the signature already in it and
perhaps there are format/style conflicts..?
Tx for shedding some light into this.
As an added information, t...instructions disppear when users begin type (text field)
I need to customize the outlook contact form and I want to add one text
field to allow users to add details info and instruct users how to add.
Instructions shows in the field and the instructions disappear when users
click and begin to type. How should I do this? exchange 2003/outlook2003
It's hard for me to visualize exactly what you're expecting to happen. If
you want the instructions to stay on the screen, you could display them in a
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumps...cannot view all of text in large cell, even though I have it to w.
I have cell format to wrap text and it works fine to a p[oint then no more
text is displayed....casn increase the size of the cell, but still only so
much will display....rest of the cell show blank.
+the limit is 1024 characters. You can extend this with manually inserting
linebrekas using aLT+ENTER
> I have cell format to wrap text and it works fine to a p[oint then no
> more text is displayed....casn increase the size of the cell, but
> still only so much will display....rest of the cell show blank.
...Can you record a macro in Publisher like you can in Excel?
In Excel I use the feature to Record a Macro. Excel records the keystrokes
and converts to VB. Does Publisher have that option? In my version,
Publisher 2003, I can Create a Macro, and it takes me into VB. However, I
don't know how to code VB.
> In Excel I use the feature to Record a Macro. Excel records the keystrokes
> and converts to VB. Does Publisher have that option? In my version,
> Publisher 2003, I can Create a Macro, and it takes me into VB. However, I
> don't know how to code VB.
Publisher does not have a Macro Recorder, sorry.
I have an Excel Workbook that I created for a PC Order Form. I set it up to
only make certain rows visible based on the Machine Model that they choose.
I digital signed the Worksheets and exported the Digital Signature
Certificate and installed it on the User’s PCs. The code works great. The
user opens the Workbook and it runs the Macros with no problem. The problem
I have is when the user goes to save the Workbook. They get an error that
“Excel can not sign VBA macros when saving to this file format. Do you want
to remove the digital signature and continue saving this workbook?”...Automated Copy Paste
I have a template with 7 sheets that I continuously update with new data that
I get from a seprate file. Each sheet is named "sheet1", "sheet2" "sheet3"
and so on.
My template has a series of summary sheets based off of the data that lies
in these 7 inputs sheets. Currently, I use copy, paste special to update
sheets 1-7 in my template.
Instead of using copy, paste special one at a time, I would like to the move
7 sheets from my other file in my template. If I do this, the sheets will
show up as duplicates so I will have "sheet1 (2)"...How to create an XML document with XmlTextWriter?
Hi, I'm trying to create an XML document with XMLTextWriter but I want to store it in memory (not write it to a file like so many examples do). I tried the following but with no luck. Should I not user this object for this purpose? Thanks, Dave
MemoryStream stm = new MemoryStream()
XmlTextWriter writer = new XmlTextWriter(stm, System.Text.Encoding.UTF8)
writer.WriteComment("This Is A List of My Books")
writer.WriteAttributeString("ISBN", "1861005...document elements (et. al.) toolbar in Word 2008
I may be in the minority here, but I happen to love the Ribbon UI on
the PC version. It can collapse down to nothing when needed, and
expand out (and even be customized I hear in 2010). That's on the PC.
On the Mac I want a Mac-like UI. The Document Elements bar is so out
to planet Jupiter on both functionality and as an accelerator into
functions writers need most that it's laughable it made it into a
release. (I'd much rather have a Mac ribbon that the Document Elements
toolbar since at least the ribbon exposes USEFUL functions.) I mean,
really =97 how many UPS or Del Mon...Referring to a FileName in Macro
I have a Macro with the following code
TestQry is the name of the file. Is there anyway that this macro cod
can refer to the activeWorkbook or filename so that if the file i
saved to a new name this macro will still ru
Message posted from http://www.ExcelForum.com
How about just:
"DoctorV <" wrote:
> I have a Macro with the following code
> Application.Run "TestQry!Macro2"
> Application.Run "TestQry!Macro1"
&g...Macro Copy and Paste
I am currently trying to copy from one workbook that has 7 differen
tabs and paste into one worksheet on a separate master workbook. M
problem is that when I set up the macro to copy from one of the tabs i
the workbook and paste to the other work book, I only want the the row
to come in where there is data. Currently I am having to run a macr
that takes every 100 lines, but ideally I only want the informatio
copy and pasted where there is only data.
In addition, once I have copy and pasted everything from the first tab
my next step is to copy and paste information from the second tab t
th...Combine small documents into one master document
I currently have an "engagement letter" that is created for our clients to
set the expectations for our business relationship (I work for attorneys).
We have about 10 different paragraphs that may be inserted into the letter
based on different factors (3rd party payor, if a retainer is required,
etc.). So I start with the basic letter and then have a userform with
checkboxes where you can select the text block options (stored in Autotext).
When you click OK the various paragraphs are inserted at bookmarks.
While this works, I find working with Autotext cumber...