VBA

Programmatically Create New Workbook and Insert a Worksheet Change Event Using VBA

Zhiping Yan - Dec 15, 2019 Comments Off

It is not difficult to generate a new workbook using Excel VBA. And there are tons of materials in internet that can teach you how to achieve it. Today I

VBA

How to add multiple levels of bookmark into PDF via VBA

T.Y. - Jun 2, 2019 Comments Off

One day I got an electronic book about Oncology Statistics Rule in PDF format. The book is very good for beginners who is going to participate in oncology studies. Yet

VBA

How to reference special characters produced by RTF code via VBA

T.Y. - Nov 18, 2018 Comments Off

Once upon a time, I was requested to extract TFL titles, TFL layout orientation from individual RTF files into Excel file. It is not difficult as there are tons of

VBA

How to turn off “Microsoft Excel is waiting for another application to complete an OLE action” in VBA

T.Y. - Jun 3, 2018 Comments Off

Sometimes, we might need to manipulate a bunch of RTF or PDF files using Excel VBA. As number of RTF or PDF files to be combined goes larger, the chance

VBA

A VBA macro to convert all RTF files within one folder into PDF files

T.Y. - May 13, 2018 Comments Off

Once upon a time, we were required to convert all RTF files into PDF files. And there were hundreds of files which should be converted. It was obviously a headache

VBA

A VBA macro for you to retrieve name of all PDF files within a folder and then combine them together

T.Y. - May 10, 2018 5

Time from time, you may need to combine PDF file together. For example, you are not familiar with scanner and cannot scan multiple pages into one file. In this situation,

VBA

Randomly select a certain rows entirely from one worksheet into another via VBA

T.Y. - Aug 24, 2017 Comments Off

One day, a friend from Department of Data Management asked me for help. She has a worksheet which contains more than 10k rows of data and she’d like to select

VBA

How to retrieve comments from word document using VBA

J.L. - Jun 29, 2017 Comments Off

Tables, figures and listings must be bundled together and sent out to Statisticians for review. They usually add some comments. Programmers need to extract those comments and put them in