Make your office life easier with simple and fast Excel VBA solutions.
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.
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”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!
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!
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.
In this post You will learn how to get http request with XmlHttpRequest, get original file name from URL and download it to chosen location.
