Ben noted that Word doesn't seem to have a built-in, offline Help capability anymore, as it did in earlier versions of the program. When he attempts to get help, all inquiries seem to have to be online. He wonders if he is missing something in his installation of Word.
Actually, Word has both online and offline help capabilities. The default settings for Word, however, always use the online capabilities in preference to the offline ones. To change the settings, follow these steps:
Figure 1. The Word Help dialog box.
If, for some reason, you still cannot access the Help system on your local system (without going online), then you may need to reinstall Word or repair your installation of Word.
WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (9352) applies to Microsoft Word 2007 and 2010.
The First and Last Word on Word! Bestselling For Dummies author Dan Gookin puts his usual fun and friendly candor back to work to show you how to navigate Word 2013. Spend more time working and less time trying to figure it all out! Check out Word 2013 For Dummies today!
As you develop a document, Word keeps track of certain statistics about the document itself. Here is how you can review ...
Discover MoreThe rulers in Word can be quite helpful when formatting your document. The rulers may not be displayed all the time, ...
Discover MoreTwo of the most common character coding schemes used in computers go by the acronyms ASCII and ANSI. This tip explains a ...
Discover MoreFREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
2017-09-06 13:29:51
MOHAMMED YACUBU
AM MOHAMMED
CAN SOME PLEASE HELP ME WITH THIS CODES
I RECEIVE SYNTAX ERROR
Sub TransferToExcel()
'Transfer a single record from the form fields to an Excel workbook.
Dim doc As Document
Dim strRegistration As String
Dim strSession As String
Dim strCode As String
Dim strName As String
Dim strIndex As String
Dim strEmail As String
Dim strDateofBirth As String
Dim strCoursetobe As String
Dim strDateofRegister As String
Dim strSQL As String
Dim cnn As ADODB.Connection
'Get data.
Set doc = ThisDocument
On Error GoTo ErrHandler
strRegistration = Chr(39) & doc.FormFields("txtRegistration").Result & Chr(39)
strSession = Chr(39) & doc.FormFields("txtSession").Result & Chr(39)
strCode = Chr(39) & doc.FormFields("txtCode").Result & Chr(39)
strName = Chr(39) & doc.FormFields("txtName").Result & Chr(39)
strIndex = Chr(39) & doc.FormFields("txtIndex").Result & Chr(39)
strEmail = Chr(39) & doc.FormFields("txtEmail").Result & Chr(39)
strDateofBirth = Chr(39) & doc.FormFields("txtDateofBirth").Result & Chr(39)
strCoursetobe = Chr(39) & doc.FormFields("txtCoursetobe").Result & Chr(39)
strDateofRegister = Chr(39) & doc.FormFields("txtDateofRegister").Result & Chr(39)
'Define sql string used to insert each record in the destination workbook.
'Don't omit the $ in the sheet identifier.
strSQL = "INSERT INTO [Doc2$]" _
& " (Registration, Session, Code, Name, Index, Email, DateofBirth, Coursetobe, DateofRegister)"
& " VALUES (" _
& strRegistration & ", " _
& strSession & ", " _
& strCode & ", " _
& strName & ", " _
& strIndex & ", " _
& strEmail & ", " _
& strDateofBirth & ", " _
& strCoursetobe & ", " _
& strDateofRegister & ", " _
& ")"
Debug.Print strSQL
'Define connection string and open connection to destination workbook file.
Set cnn = New ADODB.Connection
With cnn
.Provider = "Microsoft.ACE.OLEDB.12.0"
.ConnectionString = "Data Source=F:\Sales.xlsx;" & _
"Extended Properties=Excel 8.0;"
.Open
'Transfer data.
.Execute strSQL
End With
Set doc = Nothing
Set cnn = Nothing
Exit Sub
ErrHandler:
MsgBox Err.Number & ": " & Err.Description, _
vbOKOnly , "Error"
On Error GoTo 0
On Error Resume Next
cnn.Close
Set doc = Nothing
Set cnn = Nothing
End Sub
2014-08-04 10:37:20
JonSpain
Thank you very much, Janet, great.
Jon
2014-08-04 10:33:47
Janet Hall
Offline Help for 2013: Press F1. Click the down arrow in the upper left corner of the dialog box to the right of the words "Word Help". Choose Word Help from your computer. Close the dialog box.
2014-08-04 07:15:42
JonSpain
Allen
Thanks for that, it works on 2007, but do you have the same for 2013, please?
Jon
2014-05-01 20:51:27
Mike
Is it possible to get an offline spellchecker for Word 2013?
2014-02-27 16:56:28
Martin Kunz
Hi,
is there any possibility to get (dwonloaded or other way) the help files for Word 2013? I have got the program, but there is nothing to read when I am going offline. Where are the help files stored, in program folder?
2011-11-17 07:18:18
Dr Pam Miller
Thanks for this info re Off-line help. I never knew!
Got a version of Word that uses the ribbon interface (Word 2007 or later)? This site is for you! If you use an earlier version of Word, visit our WordTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2018 Sharon Parq Associates, Inc.
Comments