Tags » Vba

Reporting. So simple with VBA

I have to prepare a daily, weekly, monthly, quarterly report… This is what managers do. Why? Why writing reports is more important than leading people or solving problems or proposing ideas? 334 more words

Home Page

Problem

There is a web based “course-structure” data downloading system. The university uses the system time to time to generate report.The downloaded data are in excel format as shown in the figure 1. 431 more words

Visual Basic For Applications (VBA)

VBA: How to Get a Spreadsheet of File Names

I recently found a really cool article from Software Solutions Online that shows you how to get a list of files in a folder or a list of subfolders in a folder. 407 more words

Gif Guides

Visual Basic for Applications (VBA)

Source: Visual Basic for Applications (VBA)

Problem: How to set your page format automatically using VBA so that print report can be generated without formatting the page through page setup. 392 more words

Visual Basic For Applications (VBA)

Excel VBA - Check if your workbook exist or not?

Before opening your workbook, you will need to verify if the workbook exists or not, so that it won’t return error or the VBA will stop improperly. 72 more words

VBA

Making Data Entry Exciting Again

Data entry has a bad reputation. It basically translates to repetitive work with lots of manual typing with error-filled issues. Yet – how can we lift this load off without compromising on the quality but yet at a faster rate? 162 more words

Automate

SLA Perfomance - Month Till Date(MTD) - VBA / Excel

What usually happens in the service industry is that we have monthly report from a tool – HPSM / Remedy / SNOW – whatever.

And we need to present management the status every day. 1,235 more words

Excel