Ad Clicks : Ad Views :
Excel formulas and tutorials

Excel formulas and useful tools

Category: VBA

img

VBA macro create PDF print as

By
|
In VBA
|
On February 22, 2018
A very helpful VBA macro that turns any printable excel document into a PDF file. Convert excel to pdf or save excel to pdf Sub savepdf() mo= Month(Date) d = Day(Date) y = Year(Date) h = Hour(Now) m = Minute(Now) s = Second(Now) file= y & mo & d & “-” & h & m […]

Run macro on open file event

By
|
On October 14, 2016

In order to run macro on open file event you need to have the VBA code (macro) inside the Workbook_Open() event in ThisWorkbook element on Project Explorer. You must first open the VBA editor in Excel

img

Excel VBA Macro

By
|
In VBA
|
On October 12, 2016
This is a tutorial for anyone wanting to learn how to write their first excel vba macro. These macros are very useful when we need to do a lot of manual work on large data tables and these manual actions can be automated by using a macro to execute every operation that we usually did […]
img

Making Excel file unsavable

By
|
In VBA
|
On May 8, 2014
Some companies use Excel files through intranet networks for all their staff to have access to certain information and automated reports. This usually means that this kind of file should be unsavable by the staff in order to preserve a certain degree of accuracy and format. Making Excel file unsavable Without altering the menu of […]
It is main inner container footer text