Pages

Search

Microsoft Word - VBA "SaveAs" not working both in WORD 2007 and WORD 2013

Microsoft Word - VBA "SaveAs" not working both in WORD 2007 and WORD 2013

VBA "SaveAs" not working both in WORD 2007 and WORD 2013

Posted: 07 Dec 2013 01:52 PM PST

I bought a brand new machine, ACER, 64b, running Windows 8.1. An MS-WORD macro I had for years running smoothly on Vista does not perform the "Save As" command. Instead, the "file picker dialog box" pops open (see below) with a blank file name and suggesting "Word Doc .docx" as default saving format although my code explicitly asks for ".TXT".


Problem happened while running WORD 2007 on Windows 8.1. Installed WORD 2013 on Windows 8.1, nothing changed, the exact same error keeps occurring.


Below the transcript of the code line where the problem lies:


    ActiveDocument.SaveAs FileName:=TxtSalva, FileFormat:= _
        wdFormatText, LockComments:=False, Password:="", AddToRecentFiles:=True, _
        WritePassword:="", ReadOnlyRecommended:=False, EmbedTrueTypeFonts:=False, _
         SaveNativePictureFormat:=False, SaveFormsData:=False, SaveAsAOCELetter:= _
        False


Once reached, the macro pauses, the file picker pops open (see below). If one fills it with a FileName, and press SAVE button, the file is effectively saved under that name but then the Macro stops with error message "Runtime error 4198".




Hope Microsoft looks into it soon because "Save As" is the kind of command that is used everywhere and I guess quite a number of users must be very upset and disapointed with that.


Best,


Alex

Mail merge label formatting

Posted: 07 Dec 2013 01:52 PM PST

In the Insert Address Block dialog box the preview label shows a single space between lines. When I click the Preview Results button the address shows a space after the paragraph marks. I want the label single spaced, and aligned center left. 

Word 2010 table question

Posted: 07 Dec 2013 11:02 AM PST

Hi all,


When I create a table or add rows to a table, Word likes to move the column, right indent toward the left. When I finish adding my data, I have to manually highlight the column, and then move the right indent all the way to the right. This occurs AFTER I have manually set the right indent during the table creation.


  • How do you control the default right indent in a table?
  • Does Word use a default value?
  • Why does Word move the right indent after I create my table?
  • It often happens when I use the Insert Above or Insert Below function.


Like most table features, this is very annoying. Many thanks.


- Lee

Email merge using a previously merge letter

Posted: 07 Dec 2013 10:17 AM PST

I used the letter merge in Word to create custom invoices for each member. I need to email each letter to the particular member's email address. How can I ensure that the email is sent to the correct recipient listed on the customized letter?

How do i open microsoft office student 2013 with the winodows 8 OS?

Posted: 07 Dec 2013 09:15 AM PST

I don't know where to find the icons needed to open the programs... Where would they be located so i can use them?

Word and New Font

Posted: 06 Dec 2013 09:53 PM PST

I have Windows 8.1 and the newest version of MS Office. I downloaded a font which installed with no problems but when I tried to use it an error popped up saying that the font could not be displayed due to insufficient memory space. What do I need to do?

convertiing microsoft word processor to word 2007

Posted: 06 Dec 2013 07:28 PM PST

how do i convert mircrosoft word processor to microsoft word 2007?
thanks

Word 2010 space key

Posted: 06 Dec 2013 07:24 PM PST

Word 2010 in the middle of a document the space key tabs all the way right, instead of moving one space.  How to stop this?

Excell 2007 to mailmerge to Word 2007

Posted: 06 Dec 2013 06:33 PM PST


The list holds a percentage value of 75% in the DiscountAmt field of the Excel list.  I need it to display on my Word Doc as 75%.  I am getting right now .75% using the following syntax.  I really need it to take the .75% amount and times it by 100 so the figure shows as 75%.  I can not get it to do the multiplication process at all.  I dont even get an error no mater where I put the * 100.....

{MERGEFIELD DiscountAmt = {DiscountOffer * 100\#"##%"}}

Been off Word for over a year and can not recall how to do this in 2007 version.  

HELP PLEASE.....

HDwight

Need Help

Posted: 06 Dec 2013 05:11 PM PST

How do i download office starter 2010 for windows 8?

Microsoft Word 2007 Corrupted Document Equations

Posted: 06 Dec 2013 03:03 PM PST

Good Evening,

I have a problem that it seems that many people have had in Microsoft word. 

Namely, I have a document that does not open, but instead gives me the error -- "There are problem with the contents -- unspecified Error -- line 2, Column 496425". 

My document has a lot of equations, so I have a feeling that this might be the problem. It does seem similar to the problem on this thread -- http://social.technet.microsoft.com/Forums/office/en-US/11c6f40d-e229-428a-9d76-cf0e5be3b8c8/corrupted-word-2007-file-unspecified-error?forum=officesetupdeploylegacy . 


I am not great with computers but did attempt to do some of the fixes specified in the above thread, but am unable to get the file to work correctly. Perhaps somebody could help me out? I would be extremely grateful.

The file is posted on Google drive at the link



Could somebody please help me out?


Thank you so much,


Jake