This post demonstrates how to hide or show an excel ribbon using VBA (Visual Basic for Applications). In certain cases it may not required to show an excel ribbon to the user. In such cases, hide the excel ribbon for a better user interface. The excel ribbon
Friday, 27 February 2015
Thursday, 26 February 2015
Import CSV or delimited text file in Excel - VBA
This post demonstrates how to import CSV or any delimited text file in Excel using VBA code. Each line in the text file is written into one row in a worksheet. The imported data is separated into columns in a worksheet depending on the delimited character that you
How to create a LOG file in excel and access - VBA
Welcome to Logically Proven blog. This post demonstrates how to create a log file in excel or access using VBA (Visual Basic for Applications) code. Consider a scenario, the application is logging the user details into the log file who are accessing the application. Here is application may
How to hide the password text in a textbox control in Excel - VBA
Welcome to Logically Proven blog. This post demonstrates how to hide the password text in a text box control using Excel VBA (Visual Basic for Applications). First design the user form as shown in the picture below - This form contains two textbox controls - one for Username
Wildcard pattern matching in C
Welcome to Logically Proven blog. This post demonstrates how to match a wildcard pattern against a particular string in C programming. To achieve this we are using the function fnmatch which is in-built declared in the header fnmatch.h Syntax: int fnmatch (const char *pattern, const char *string, int
Different modes of rounding float values in C and C++
Welcome to Logically Proven blog. This post demonstrates different modes of rounding float values in C/C++ programming. Floating-point calculations are carried out internally with extra precision, and then rounded to fit into the destination type. ROUNDING MODES: IEEE 754 defines the following four possible rounding modes: 1. Round to
Wednesday, 25 February 2015
Sleep function in C
Welcome to Logically Proven blog. This post demonstrates how to make your program wait for a period of time. It is required to wait out program for a little span of time before executing some statements. For example in case waiting for Input/Output signals. The function sleep gives
Extract file name from a path in Excel using formula and VBA
Welcome to Logically Proven blog. This post demonstrates how to extract a file name from a path using Excel and VBA. The following are the ways to extract a file name from a path. You can use any one of these methods to extract a file name. 1.
Update image of an image control dynamically in Excel - VBA
Welcome to Logically Proven blog. This post demonstrates how to update image of an image control in Excel with VBA (Visual Basic for Applications). It is required to update the image of an image control in Excel without manually loading the image. This post teaches you how to
Generate PDF document from Excel - VBA
Welcome to Logically Proven blog. This post demonstrates how to generate a PDF document from Excel using VBA (Visual Basic for Applications). Sometimes it is required to generate a PDF document from the Excel workbook or worksheet. This post gives you a basic idea how to generate the
Difference between worksheet display names and code names in Excel (VBA)
Welcome to Logically Proven blog. This post demonstrates the difference between worksheet code names and worksheet display name. And also explains which name is better to use in the VBA (Visual Basic for Applications) code. In an excel workbook, every worksheet has two names - display name and
Tuesday, 24 February 2015
Export Excel Worksheet(s) to a new workbook in Excel - VBA
Welcome to Logically Proven blog. This post demonstrates how to export a particular sheet or all worksheets to a new workbook using excel VBA (Visual Basic for Applications). In certain situations, it is required to export a current workbook data to a new workbook or do you want
Dictionary object in Excel - VBA
Welcome to Logically Proven blog. This post demonstrates dictionary object in Excel VBA (Visual Basic for Applications). A dictionary class is a data structure that represents a collection of keys and values pair. The key is unique (identical) in a key-value pair and it can have at most
Subscribe to:
Posts (Atom)
