Pages

Search

Microsoft Word - Macro That Saves A Word Document as a Renamed Word Document and As A PDF.

Microsoft Word - Macro That Saves A Word Document as a Renamed Word Document and As A PDF.

Macro That Saves A Word Document as a Renamed Word Document and As A PDF.

Posted: 19 Jan 2015 02:47 PM PST

I want to create a macro that allows me to "save as" an existing documents with a new title, and creates a PDF of it. I want to be able to create both simultaneously, name them the same thing, and I want to choose where they get saved.

So far, I've scoured the web and found this; it creates a new document and a PDF, but saves them both in the same place the original document is saved in.

Dim strName As String

ActiveDocument.Save

strName = Left(ActiveDocument.FullName, Len(ActiveDocument.FullName) - 4)

strName = strName & "pdf"

ActiveDocument.ExportAsFixedFormat OutputFileName:=strName, _

                              ExportFormat:=wdExportFormatPDF, OpenAfterExport:=False, OptimizeFor:= _

                              wdExportOptimizeForPrint, Range:=wdExportAllDocument, From:=1, to:=99, _

                              Item:=wdExportDocumentContent, IncludeDocProps:=True, KeepIRM:=True, _

                              CreateBookmarks:=wdExportCreateNoBookmarks, DocStructureTags:=True, _

                              BitmapMissingFonts:=True, UseISO19005_1:=True


Also, I've found this; It does half of what I want. It allows me to name and choose where the PDF goes, but doesn't include the document. 

Dim StrPath As String, StrName As String, Result

With ActiveDocument

 On Error GoTo Errhandler

 StrPath = GetFolder & "\"

 StrName = Split(.Name, ".")(0)

 While Dir(StrPath & StrName & ".pdf") <> ""

   Result = InputBox("WARNING - A file already exists with the name:" & vbCr & _

     Split(.Name, ".")(0) & vbCr & _

     "You may edit the filename or continue without editing." _

     & vbCr & vbTab & vbTab & vbTab & "Proceed?", "File Exists", StrName)

   If Result = vbCancel Then Exit Sub

   If StrName = Result Then GoTo Overwrite

   StrName = Result

 Wend

Overwrite:

 .ExportAsFixedFormat OutputFileName:=StrPath & StrName & ".pdf", _

 ExportFormat:=wdExportFormatPDF, OpenAfterExport:=False, _

 OptimizeFor:=wdExportOptimizeForPrint, Range:=wdExportAllDocument, _

 Item:=wdExportDocumentContent, IncludeDocProps:=True, KeepIRM:=True, _

 CreateBookmarks:=wdExportCreateNoBookmarks, DocStructureTags:=True, _

 BitmapMissingFonts:=True, UseISO19005_1:=False

End With

Errhandler:

End Sub

Function GetFolder() As String

Dim oFolder As Object

Can anyone help come up with a variation on the two or just help fill in the gaps? I would really appreciate it. Thanks.

Problem with copy & paste in office

Posted: 19 Jan 2015 01:59 PM PST

Hi all : i got the problem too few days ago, it was the copy-paste option in pushbullet. u must disable it !!!

Formatting pictures with textbox over picture

Posted: 19 Jan 2015 01:33 PM PST

I have a document with 12 pictures.  Each picture has a textbox on it with Word Art.  When I look at reveal codes there is a page break between each picture as I wanted.  When I view print view,  web (filtered), or pdf the formatting is all messed up.  In one case two pictures over lap even though there is a page break between them.  Also having trouble with some text boxes not staying on the picture and/or going to a different page.

The document looks perfect when I am looking at it, however, I can recreate the overlapping pictures by changing one of those pictures to "text wrap behind text" when I do that the other picture jumps up a page. 

I have been working on this unsuccessfully for 5 days and am about to give up.

Open to all ideas.

Thank you!

Mail merge issue -- after merging, the font size changed in the merge fields from 12 pt to 14 pt

Posted: 19 Jan 2015 01:25 PM PST

I use mail merge to create Separation Agreements/Releases in my job.  The main document is a Word document and the data source is an Excel file.  After merging the documents, the final (merged) document has changed the font size in certain fields from 12 pt. to 14 pt.  for some reason.  I can't figure out why or how this is happening.  The main Word document doesn't seem to have any formatting changes in the font size and the Excel data source uses an entirely different font and size anyway.  I have to go through the entire document and highlight the fields that are larger and change them to 12 pt.  Any solution to this problem?  Thanks.

Major Bug In Word Update 1.5

Posted: 19 Jan 2015 12:18 PM PST

Hi guys

i am learning that Microsoft word for iOS is experiencing a major error. Everytime I try to open the app, it closes on me. In addition, I cannot open any documents and edit. What should I do? I can't delete the apps because it has all of my notes on it for exams and deleting them would be bad

Where have my documents gone?

Posted: 19 Jan 2015 12:13 PM PST

I have come to use Microsoft word appand it no longer opens and has deleted all my documents. Could anyone tell me how to resolve this and why this has happened?

thanks 

Drop down List Content Control not editable

Posted: 19 Jan 2015 11:32 AM PST

Hello. I have created a word template with a drop down list content control. It should be possible that anyone can edit a content when using the template. Therefore I have not selected the locking checkboxes in the content control properties (Content control cannot be deleted and contents cannot be edited not selected). Strangely Word is working like I have selected the checkbox 'contents cannot be edited'. Any idea what the problem is? When I try to edit a content the message 'The modification is not allowed because the selection is locked'. First I tried to create the drop down list in Word 2007, then in Word 2013. In both versions the same problem exists. No chance to edit the content. Help will be highly appreciated. Tks and rgds Babazrh

URGENT HELP NEEDED.....

Posted: 19 Jan 2015 10:41 AM PST

Dear Members/Experts,

 I am recently facing a problem while opening Microsoft office documents like word, excel etc.

whenever I tried to open a file it shows a error. pls. help. I clicked on repair now tab but nothing happened.

Grouping pictures and shapes

Posted: 19 Jan 2015 10:22 AM PST

Word 2007. After I insert a picture, I sometimes insert shape and place it on top of the picture. However, I cannot group them. If I change the picture wrap from in line to floating, then the shape goes behind the picture and cannot be brought forward. Is there a way to group them?

Office 2013 - "This modification is not allowed because selection is locked"

Posted: 19 Jan 2015 10:19 AM PST

I am using Office 2013 (Word).  The document I am working on is an old document that I have been using for well over a year.  It is a running "to-do" list with check boxes.  Before my current issue, I would check off the completed tasks for the week and then at the beginning of the next week, I would copy and paste the previous week's tasks, enter a new date at the top of the list, and simply delete the checked (completed) tasks.  All of a sudden, when I go to delete a task, I receive the message "This modification is not allowed because selection is locked".

Most of the other answers to this problem (apparently a common problem) seem to revolve around the document being restricted (not in this case) or an issue with the Word version not being activated (not in this case).  I am having no problems with any other Word docs, only this one.

EDIT:  I just figured out that if I ONLY use the "backspace" key, I can delete the line (task) in question, but if I highlight the entire line and try to delete it I receive the same message.

Any help is appreciated!

Billiken

WORD toolbar defaut tab in Office 365 Home

Posted: 19 Jan 2015 10:15 AM PST

When I open WORD the tool bar tab at the top of the page defaults to the "File" tab.  Until now it has always defaulted to the "Home" tab that shows the toolbar commands used in Word documents.  If I click on "Home" to perform a command, it performs the command and then the tab goes back to "File" instead of staying on the "Home" tab.  How can I make the "Home" tab the default when opening WORD?  And also, how do I get it too remain on the tab I select until I manually change to a different tab?

Office 2010 template download error

Posted: 19 Jan 2015 09:22 AM PST

When I try to download template in word it gives me error

"Template Download Error
> The template cannot be downloaded. To fix this problem, do the following:
> - Make sure your computer is connected to the Internet .
> - Make sure your browser is not in offline mode.
> -Try to download the template again later."

I need to download a calendar, yesterday it worked and today it doesn't. I am running on windows 8.1. 

recreate a document

Posted: 19 Jan 2015 09:10 AM PST

can anyone help me I am not that computer savvy but can learn I hive loads of sheets of documents all different and they have actions written on them but they have been filled in by someone I have to keep current up to date records so need to create copies of these documents but without the ticks and comments that have been added just need the blank forms how on earth do I do this in layman's terms please have been told to use excel but don't know how

MS Word 2010 Email Merge doesn't work with the HTML Option Using Windows 8.1

Posted: 19 Jan 2015 08:21 AM PST

I am running Windows 8.1

I am using Microsoft Office Professional Plus 2010.

Outlook is my default email program.

When I complete an e-mail merge, I can send as an attachment, no issues.

I can send as plain text, though this opens a dialog box asking me to allow internet access for a specified time period, and I have to click OK on each e-mail.  At least it works.

When I choose to send as HTML, the merge completes, but no e-mails are sent.  I see the dozens of merges being completed, but there are no e-mails in my outbox or my sent e-mail folders in Outlook.

I have run the repair function for Microsoft Office.  I have downloaded all updates.  I have done a clean boot of Windows.  I even tried to use the fix (though it's designed for Windows 7), #980681.  Still nothing.

Can anyone suggest anything else?

Create a link between word documents for standardised templates

Posted: 19 Jan 2015 04:03 AM PST

Hello

I am trying to create a standard document that will be used for different purposes. I want fields such as company names and other details to be edited and maintained throughout the document. I tried to create a table of variables within excel and then import them into the different areas within my document but i always end up with boxes around the inputed data or it ruins my formatting. Is there anything i can change?

Different line spacing for English character and Chinese character

Posted: 19 Jan 2015 12:21 AM PST

Line spacing is single. I choose the minus sign, then "mark selected texts as" Chinese (PRC) or English (United States). The line spacing would change as shown in pic. 2 and pic. 3. Why?

 

Don't Show Message - Print out of Margin

Posted: 18 Jan 2015 08:49 PM PST

Hi All,

I am using Printer - Epson L210.

In Some Word Documents I require Matter out of Printable Area.

---

But, below Message show again and again

Can make it ' Don't show again'

-----

Any trick

Thanks

Ravi Vare

How to create a smaller header on the continuation page of Microsoft Word 2013?

Posted: 18 Jan 2015 08:19 PM PST

I created a letterhead using word 2013 that contains logo and contact details on the header of the first page, and a preset different header for all subsequent pages.  This means that when the content on the main letterhead goes into second and subsequent pages, a different header is created automatically, with a smaller logo on the top right corner of the page.

My challenge now is that I would like to set the header margin for the subsequent pages to be smaller but can't seem to do this without affecting the whole document.  Whenever I change the header margin, it affects the whole document.  Please help.

Regards,

Phil

Where is Word, Excel and PowerPoint found once downloaded Win 8.1?

Posted: 18 Jan 2015 08:17 PM PST

I am new to using Win 8.1 having come from an XP op system. What and where do I go to actually use my MS Office which has successfully been installed? I can't create a word document because I don't know where the heck it is!

FILE SEARCH WINDOWS 8 OFFICE 2013 WORD

Posted: 18 Jan 2015 06:19 PM PST

Hi,

Just recently the search function stopped working when I try to search for files in my folders.  It used to but now it doesn't.  Was there an update that changed that and if so, which one so I can uninstall it?  If not, how do I fix it?  I tried the indexing/rebuilding route.  It worked once and I was able to do a search but went right back to returning no results in a search and I couldn't get it to work again.  It is very frustrating as I work with a lot of word documents and folders and need to be able to search them.  Also, when I click on a help link, I get a message that the content is no longer available.  What's that about?  What's the point of having the link if it doesn't work?  I want to avoid doing a system restore if at all possible because I don't really know what restore point to go back to.  Please help.

Thanks.

Trouble with Paste

Posted: 18 Jan 2015 06:16 PM PST

Using Office 2010 on a Windows 8.1 system:

I frequently want to copy a URL from an open Chrome website and then paste it into either a new Outlook email or into a Word document.  The paste function doesn't work.  I have to repeat the copy and then repeat the paste several times before it finally works.  It just won't work the first time.

Any suggestions??

SQL Database

Posted: 18 Jan 2015 05:32 PM PST

What is an SQL database and what is it doing for me when I'm creating an App?

removing "scroll" symbol from copy and paste into Word

Posted: 18 Jan 2015 04:29 PM PST

Hello,

this is my problem: when copying  an email from Outlook/Hotmail onto Word, Word then displays all these little "scroll" symbols. They are little yellow squares, with a slightly unwound scroll, top right to bottom left. (SEE FURTHER DOWN)

I want to keep source formatting, but do not want to manually remove these symbols each time I copy and paste an email, before I save the docx. The other issue is, if I do not remove these "symbols" and save the docx, upon opening the docx again, the symbols are not there, but the "grey background rectangle" that appeared from the copy and paste of the address details remains, as well as the blank spaces there were occupied by the scroll symbols. Now I could choose just paste text option, but then that removes all source formatting - not what I want.

I encountered this years ago when in XP, but I cannot remember how I undid it (whether in Word options, or something in the control panel subheadings), or what I may have done recently and it has appeared again.

I tried the local Microsoft store today, but they (their store employees) had not seen this before, nor knew how to resolve this.

Anyone else had this issue and managed to resolve it?

Word 2013 cursor not lining up after viewing in Web mode

Posted: 18 Jan 2015 04:24 PM PST

Weird problem: when viewing a document in Word 2013 in web mode, I am getting erratic behavior (for example, text disappearing after clicking a new paragraph).   When I click back to print mode, the cursor is wacky - when I click on a place in the document, the cursor looks like its 1 or 2 lines above or below it.  So, I can't see where I'm typing!  Incidentally, this is a document with a very long, multi page table (a list of definitions).  I am running Windows 8 x64 on a Surface Pro 2.