Видео

2024 I am here !

Libreoffice Writer -> insert table -> right click -> design(?) -> select academic and bob is your uncle.

I certainly wish there was an easier way to do that, but your video was still very helpful--thank you!

Thank you😁

I am an undergraduate from pakistan , this vedio made my day by making it easy for me , Thank you so much sir , lots of love from pakistan ❤

This video made my life easier and I can't thank you enough for it.

Great tutorials! The approach to remove all borders first is the easiest and best way. Select the table, remove all borders; and then, select the table again, select LAYOUT tab following the design tab and select VIEW GRIDLINES at the extreme left to show the virtual table grids

This is very helpful thank you.

Thanks already into 2nd hour of trial i saw ur video. Never thought it wud be so simple

Why can't I extract the comment? It doesn't work for me :(

thank you so much for this video. but somehow download worksheet doesn't work. can you check it, pease?

Thank you. All I needed was from 8:07 😂😂

Thank you Harold! This video saved me a lot of trouble

This is such a wonderful explanation. Thank you so much

Very informative Dr. Harold. I am looking for a video like this that is easy to understand.

Thanks. It was really helpful.

love your videos! thank you StdDevp = standard deviation of population (ie: you know entire population "n") ; 1/n stand dev formula StdDev = use a SAMPLE to "Estimate" standard deviation (coz it is usually impossible to investigate entire pop'n) ; 1/n-1 stand dev formula

THanks harold! Keep it up brother

Hi Dr. Harold. Thanks for sharing the videos. Just wanna ask you how to extract comments to macro? I watched your video (Coding Text Using Microsoft Word) but I couldn't do it when I do in my file. Could you help me with this?

Hello dear Harold. Thanks very much. Unfortunately, the link did not work. how can i get the excel template?

Thank you very much.

Thanks very much, it is really helpful.🌼🙏🌸. I cannot understand CVI in table, may I have your interpretation?!

Great instructions Harold that are easy to follow, showing the depth of your knowledge on the subject. Thank you.

Thank you!!

Thanks so much

Thank you for the tutorial and the provided link. I found your explanation and instructions very useful.

Thank You!

You are awesome

This video was very helpful. It saved me a lot of time. Thank you.

Thanks Harold

Thank you! Big help

Helpful. Thanks

it is so helpful and will save me a lot of trouble. Thank you Dr Peach

You Sir are a hero

Is there a way to set word references like in Excel. For Example, I have a Template which uses text to describe things, like a movie title, number of theaters, and P&A Budget. Like this: "Galaxia will be released in 500 theaters with a P&A Budget of $500.00 per theater." Is there a way (without find and replace) to use a code for each, i.e. MovieTitle, NumTheaters, P&ABudget and insert the code words into the text so that wherever the code word appears, it will insert the text value of the code word? This way, I can simply change the value of the code word and all entries in the document will update automatically.

the spreadsheet not open

Where can I get the macro from and how do I use??

Thank you so much Harold!

OMG, thank you.

Thank you sir

Thank you so much sir it helps me a lot😊😊

Why not using the automated numbering of tables feature in Word? Manually renumbering everything (including in-text references to tables) is a nightmare when you have to add or remove tables on a reviewer's request...

That's a dirty work around but It works and I'm using in an undergrad psych lab rep XD many thanks for the vid

thank you so much!

Thank you Sir, this was really helpful

So if you want to make an excel sheet with page number, line number, author, time comment was made, comment and reference text you can use this : Sub ExportComments() ' Note: A reference to the Microsoft Excel # Object Library is required, set via Tools|References in the Word VBE. Dim StrCmt As String, StrTmp As String, i As Long, j As Long, xlApp As Object, xlWkBk As Object StrCmt = "Page,Line,Author,Date & Time,Comment,Reference Text" StrCmt = Replace(StrCmt, ",", vbTab) With ActiveDocument ' Process the Comments For i = 1 To .Comments.Count With .Comments(i) StrCmt = StrCmt & vbCr & .Reference.Information(wdActiveEndAdjustedPageNumber) & vbTab StrCmt = StrCmt & .Reference.Information(wdFirstCharacterLineNumber) & vbTab & .Author & vbTab StrCmt = StrCmt & .Date & vbTab & Replace(Replace(.Range.Text, vbTab, "<TAB>"), vbCr, "<P>") StrCmt = StrCmt & vbTab & Replace(Replace(.Reference.Text, vbTab, "<TAB>"), vbCr, "<P>") End With Next End With ' Test whether Excel is already running. On Error Resume Next Set xlApp = GetObject(, "Excel.Application") 'Start Excel if it isn't running If xlApp Is Nothing Then Set xlApp = CreateObject("Excel.Application") If xlApp Is Nothing Then MsgBox "Can't start Excel.", vbExclamation Exit Sub End If End If On Error GoTo 0 With xlApp Set xlWkBk = .Workbooks.Add ' Update the workbook. With xlWkBk.Worksheets(1) For i = 0 To UBound(Split(StrCmt, vbCr)) StrTmp = Split(StrCmt, vbCr)(i) For j = 0 To UBound(Split(StrTmp, vbTab)) .Cells(i + 1, j + 1).Value = Split(StrTmp, vbTab)(j) Next Next .Columns("A:D").AutoFit End With ' Tell the user we're done. MsgBox "Workbook updates finished.", vbOKOnly ' Switch to the Excel workbook .Visible = True End With ' Release object memory Set xlWkBk = Nothing: Set xlApp = Nothing End Sub

Hi, Dr. Peach - thank you so much for posting this video and sharing the link to the macro. Quick question - when I review the macro code, I do not see the "line number" in with the location (page number). Can you help? I get to do multiple layers of coding for my Capstone Project and it would be really helpful. Thank you!

Thanks, mate. U save time, pain, and is just beautiful, Harold

Thank you!

Dear Dr. Peach, thank you very much for your video. It helps me to save time and internet data to code data without spend times for learn and spend too much internet data for new analysis software. From hundred videos about coding data on youtube, I fastly understand yours. Thank you!