Pages

Search

Microsoft Word - Changes in Information to a Form using Macros

Microsoft Word - Changes in Information to a Form using Macros

Changes in Information to a Form using Macros

Posted: 19 Dec 2013 01:28 PM PST

Problem:  

We have a form that employees use to sign in and out each day they work.  Each form covers two weeks and the beginning and ending dates are located at the top of the form as well as the employee's name.  At the beginning of the year we print out all of the forms for the entire year for each employee.  As it is now, that means that I have to fill out the form, print it, change the information, print it, change the information, print it, etc. until I have every person's done.  It takes over an hour to complete one form set for an employee.  There's more than 100 people working in my facility and over 25 forms per person.  


Question:  

Is there any way to automate this process?  If possible, I would like to be able to have a predetermined list (that can be edited based on incoming and leaving employees), another list for the dates of each of the pay periods (editable based on changes from year to year), and then run a macro or some other process that will print out all of the forms with the names and dates filled out and ready for the new year.

'clear formatting' changes language

Posted: 19 Dec 2013 01:26 PM PST

I'm having problems with my MS Word switching from English UK to English US, and judging by the amount of posts all over the internet I don't think I'm alone

I've resigned to the fact that I cannot remove English US from MS word, so I've made a macro that at the click of a button selects the full document, changes it to English UK then deselects the text. Annoying, but it was the best solution I could find.

I have 'detect language automatically' unchecked
I have modified the new document template to be in English and not US English but this does not affect text copied off the internet (why I made the macro)

The problem I have now is when I apply 'clear formatting' to part of the text it changes the language of the highlighted text text back to English US

Is it possible to change the language assigned to 'clear formatting' like I changed 'new template'? (or even just get rid of English US altogether)

Office 2013 - Error "Cannot download the selected picture"

Posted: 19 Dec 2013 12:23 PM PST

Just installed Office 365 Home Premium, and cannot insert any picture from Office.Com Clip Art.  Just keep getting the error message "Sorry we couldn't download the picture you selected"


Can anyone help get around this?


I am running Office 365 Home Premium on Windows 7, with IE 11 installed.  I still have Office 2007 installed if that is relevant to the issue.


Thanks,

 Bob 

Find revisions only by a particular reviewer

Posted: 19 Dec 2013 11:26 AM PST

I'm working on a document which includes revisions by multiple reviewers.  I'd like to review only the revisions by a particular reviewer.

I've on the Tracking section of the Review menu, I've used Show Markup to select only revisions by that one reviewer, which does have the desired effect in that I can now use the Next Change button to find that reviewer's changes.

The trouble is that all the revisions by other reviewers are suppressed and not visible, so I'm reviewing a document that shows only some of the changes.

Is there any way to show all of the tracked changes, but do a search which will find changes only by a particular reviewer?

Thanks.

Adding a hyperlink to a mail merge

Posted: 19 Dec 2013 11:09 AM PST

I am trying to create a mail merge with a hyperlink that will open to a specific file location.  Can anyone offer a suggestion on how this can be achieved, if at all?

Word character spacing not the same as notepad's spacing.

Posted: 19 Dec 2013 10:55 AM PST

In Microsoft Office Word 2010, I have this character spacing problem. I tested some texts in Notepad and in MS Word 2010 and these are the results:

Font Tested: Times New Roman
Size: 12


In Notepad:


Now this is in MS Word 2010:


You can Easily spot the difference. In MS Word 2010 its a little bit more space between chars and in Notepad is default. Can you help me make the font in MS Office Word 2010 the same as in Notepad? I know its a little difference but this bothers me A LOT!

Help me, for gods sake.

Is there a way to PDF a Word document in a web layout?

Posted: 19 Dec 2013 10:55 AM PST

In the bottom right of Word, there are three layout modes. I am working in the web layout. The reason being is because I am trying to create a list of items and example images to be positioned according. I have a table created with 3 columns. The name of a listing is in each first column, description in second, and image in third. If I edit my document in the print layout, I get this huge gap in between two pages. If I edit in web layout, there is no gap at all, because everything is on one big page.

After I'm finished, I want to be able to PDF what I have and view it in a PDF reader. But I tested it and the document displays in Word's print layout rather than web layout. Is there a way to change this so it displays in the web layout like the way I had it setup? Or does anyone have any suggestions?

How do I change from Asian Typography to Western Typography in MS Office Word 2010?

Posted: 19 Dec 2013 10:37 AM PST

How do I do that? Please help. I want to change from (East)Asian font to Western font but I don't know how? Help.

Styles

Posted: 19 Dec 2013 10:37 AM PST

I have a lengthy document with multi-level numbering attached to styles.  On several levels, I have lost my numbering (1-4) and only the title remains.  Is there a way to get the numbering back?

Navigation pane is no longer an option

Posted: 19 Dec 2013 09:49 AM PST

I appreciate any help with this -
The navigation pane, which I used quite often, is no longer an option.  Here's what I have:





Anyone know where I can find it? How I can get it back?

Thanks all!

In Office 365, where is the toggle to turn off the onscreen keyboard?

Posted: 19 Dec 2013 09:43 AM PST

I assume there is one, because I can't imagine why there wouldn't be.


I have a Yoga 13, and in Office - and only in Office - every time I use the touchscreen to select the page or text box, an extremely annoying onscreen keyboard pops up. I clearly don't need it in laptop mode, even though I very strongly prefer to use the touchscreen to navigate and make selections (which is why I bought on a touchscreen). Windows 8 and the other apps seem to understand this. I'm hoping Office does, too. It's a deal-breaker for my trial version of Office, because it makes this program unusable for me.


Any ideas?

Thanks!

how to create mailing labels in Windows 7 from Excel 2013 to Word 2013

Posted: 19 Dec 2013 09:35 AM PST

Please answer, how to create mailing labels in Windows 7 from Xcel 2013 to Word 2013

crashing when spellchecking

Posted: 19 Dec 2013 09:08 AM PST

As soon as I press the spell check button in the review ribbon office 2013 crashes every time. I've debugged the program and it flags up the OSF.dll file as the problem, I managed to temporarily fix the issue by deleting it but now its happening again with that file both present and absent.
Tried multiple uninstalls & repairs, no luck what so ever.
. 

Mark-forward date field

Posted: 19 Dec 2013 01:53 AM PST

I'm trying to create a field in a pet care reminder letter which looks up today's date (i.e. the date the document is created) then marks it forward by 1,3 or 6 months and inserts a specified point within the document in the format dd/mm/yyyy - the owner's name,address and pet details are merged from an SQl database 

MS Office Word 2010 has random space between characters

Posted: 19 Dec 2013 01:45 AM PST

Hello, I have a problem.
I need to make a essay for school for next week. But I have recently discovered a random space between words in Microsoft Office Word 2010. I tried disabling justifying and I tried to adjust some settings but it didn't work.

I will upload a image of the problem:



I haven't made a typo, I checked and it wasn't.
I typed "ws" in Times New Roman, 12, bold, and it did get the same space.

I have MS Office 2010 with default settings.

Thanks. Hope you can help me.

Symbols option does not work fine in Word 2013.

Posted: 18 Dec 2013 11:12 PM PST

Original post: Symbols.

 

When I select Insert with my cursor and then the Symbols pull-down my cursor allows me to select from the Recently Used Symbols plus I can Select all of the font families; e.g. Webdings but when I place the cursor on a new font character nothing can be selected rather the highlight stays on the first upper left corner character in solid blue?  HELP?

I have Microsoft Office Home and Student 2007 and have problem when I input a file it comes up in compatibility mode and will not let me make any changes

Posted: 18 Dec 2013 10:08 PM PST

I have Microsoft Office Home and Student 2007 loaded on my computer.  I have windows 7 home premium.

When I open a document it brings in compatibility mode and I'm unable to make changes to it.


Also I have the document open and the convert will not work.


When I open word, it has to be installed first for some reason. 

VBA: Word has encountered a problem (5097)

Posted: 18 Dec 2013 09:49 PM PST

I'm getting the above error at runtime from an extremely innocuous looking block of code (below), on only one of our 12 machines. Not sure what to look for on that PC; our PCs all have the same release of Word and none of the others trip up there. Googling the message points me to several arcane situations, most involving automation or Outlook or proofing, but the error comes from this simple function (code stops where shown), with a few very ordinary documents open:

 

Public Function ReportIsOpen() As Boolean

Dim w As Window

For Each w In Application.Windows  <----- STOPS HERE

    If InStr(w.Document.Name, "RPX") > 0 Then

        ReportIsOpen = True

        Exit For

    End If

Next

End Function

 

Any ideas?  TIA.

Unable to cite an encyclopedia using "Type of Source" drop down menu, no option for encyclopedia articles

Posted: 18 Dec 2013 07:01 PM PST

I have an article from an encyclopedia which I would like to add using the "Create Source" dialogue box. However, under "Type of Source," encyclopedia does not appear. How should I cite an encyclopedia article using Chicago style if there is no option for doing so?

In WORD... Can I make text not prepared as one paragraph into ONE BIG paragraph?

Posted: 18 Dec 2013 03:57 PM PST

I want to prepare text so that the Natural Reader will read it without stopping at the end of each line.

 

Can I use the 2003 WORD program to convert such text so that a page of text  is made into one big paragraph so tha the reader reads straight  through?

 

I'd really appreciate any help.

Thank you,

Tom Rawlings

why won't my chapter headings start at 1?

Posted: 18 Dec 2013 03:37 PM PST

I am using the multilevel list, with the heading 1 style for chapter headings.  There is one section break prior to my first chapter so I can keep my TOC pages numbered differently.  The very first text with heading 1 style is my first chapter 'Introduction'.  No matter what I do, it is always Chapter 2 and my pages are 2-1, 2-2, etc. 

I have even removed the section break after the TOC and those pages then get numbered 2-1, 2-2...

I have tried opening a blank document and copy/pasting text only and then applying the new chapter numbering with no luck.

Help?  thanks!

Word 2013 Bookmarking and Cross Referencing...

Posted: 18 Dec 2013 03:11 PM PST

Hi


I really hope someone can help - I'm just about to do the 'computer through the window' YouTube recap.


I'm creating a template in Word 2013. I have two Rich Text Content Control elements for a 'docname' and a 'docnumber'

These are on the (different) first page. I have assigned each of these elements with an appropriate Bookmark name (as above).

In the main document section, within the Header I have placed a Cross Reference for each of these.


From my understanding I should be able to goto Print Preview to have these two Cross References update and show me the relevant bookmarks. However all I get is Error! Reference Source Not Found.


To add what I've attempted, I've put these two initial elements in the Header of the first Section to see if that helps. Doesn't.

I've kept the template unprotected, ungrouped, unrestricted for editing yet I still get the above error.


There has to be something I'm missing or not configuring properly to ensure these work correctly.


If I toggle the Cross Reference element it displays as ' {REF number \h}', presumably this is correct for a Cross Reference.


If someone has the solution why these don't work for me I'd really appreciate a response.


Cheers


UPDATE... I found the issue... so I thought I may as well update this so that others, if they are having the same problem can check their work.


Instead of clicking only the content of the Content Control box, select the whole element (if you have the element tagged select the actual tag so the whole field itself is the Bookmarked item (not just the contents).


Hope this saves some time for some others.