Hey guys Im creating a macro that takes a specific paragraph from a word file and then dumps it into Excel. I have some code but it doesn't work: Private Sub ImportCommandButton_Click() Dim FilePath As String Dim wrdApp As Word.Application Dim wrdDoc As Word.Document Dim para As Paragraph FilePath = Application.GetOpenFilename("Microsoft Word Document (*.doc), *.doc") Set wrdApp = CreateObject("Word.Application") wrdApp.Visible = False Set wrdDoc = wrdApp.Documents.Add ' create a new document Set wrdDoc = wrdApp.Documents.Open(FilePath) wrdDoc.Select para = wrdDoc.para(1) Worksheets("sheet1").Range("A1").Value = para wrdDoc.Close End Sub The error is Invalid use of property where it says "para = wrdDoc.para(1) Any help is appreciated!! If a person is perseverant, although he/she is hard of understanding, will become intelligent; and although he/she is weak will be transformed into strong

Just a thought. Is "para" a valid variable name?

I don't see why not!! If a person is perseverant, although he/she is hard of understanding, will become intelligent; and although he/she is weak will be transformed into strong

Try using para = wrdDoc.paragraphs(1) and then learn to use the Help features.