Hi,
I have written this procedure that converts decimal time (1.75) into analogue time (1hr 45 mins). It works ok, but seems a little verbose. Any suggestions for making it more efficient and shorter?
Regards,
Sub testString()
Dim Duration As String
Dim hrs As String, mins As String, totTime...
Hi Everyone,
I have a .txt file that has been exported from Business Objects. I am formatting the file as a word document and then converting the text to a table. The resulting table can be in excess of 2000 rows. Each range of data within the table is separated by a blank row. I want to split...
Hi All,
I have a template that a user opens and produces many 'child' documents from. Rather than the user having to save the child and then open a new parent (template) document manually every time, is there any way to fire up the template after saving the child with Document.SaveAs?
I have...
Hi,
I am trying to loop through a table in a Word document to find certain text in column 1. If the text is found, the selection is extended into column 2 and both cells selected.
The resultant found text is destined for another table in the same document. The destination table is just a one...
Hi,
I have a table cell that contains text from another document. The text can contain many paragraphs and some paragraphs have duplicate paragraphs within the same cell.
I have tried to loop through the text to find and delete all duplicates, but without much success. To illustrate, the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.