Posts

How to scroll to the last Excel tab

You may think that scrolling could be the easiest thing to automate in VBA. Unfortunately, task to scroll to the last Excel tab became one of the toughest things to me to code. Today I’ll explain You, why I had troubles to implement that in complex macro tool.

How to scroll to the last Excel tab
Continue reading “How to scroll to the last Excel tab”

Replace double angle quote problem

Until recently, I was not even aware of various quotation marks such as double angle quote. In today’s article, we will discuss the replace function and problems that can be caused by a simple attempt to replace double angle quote with standard Word settings.

Continue reading “Replace double angle quote problem”

List separator in conditional formatting

Have You ever thought about list separator and its connection with conditional formatting before? If not, hop in, read and You’ll be surprised what I found out about it!

List separator in conditional formatting
Continue reading “List separator in conditional formatting”

Find word and get its paragraph number from Word file

If You want to learn how to find a word or phrase in Word file and get its paragraph or word number stay here, You’ve come to the right place!

Find word and get its paragraph number from Word file
Continue reading “Find word and get its paragraph number from Word file”

How to create XmlHttpRequest summary report

Last time I showed You how to download files using function URLDownloadToFile and XmlHttpRequest. In this article I am going to show You, what You can add into old code from previous post to create XmlHttpRequest summary report.

XmlHttpRequest summary report
Continue reading “How to create XmlHttpRequest summary report”