Automatically run a macro when opening an Excel file

Excel Macros in VBA are really a great way to do repetitive or an automated task. So if you have a specific macro that you'd like to be run every time a specific file is opened, then you need to write the VBA code for that macro in the Workbook_Open() procedure.

Follow the following steps to do that:

Open the Visual Basic editor from the Developer Tab. (Go to the following link if you can't see the Developer Tab)

Look for "This workbook" in the Project Explorer and double-click it.
Select Workbook from the 1st drop-down
Select Open from the 2nd drop-down for excel to automatically create a procedure for Workbook_Open().
Insert the VBA code that you want to run every time the specific excel file is opened.

Microsoft Visual Basic for Applications

There are many other similar procedures that you can add in "This Workbook" like BeforeClose, BeforeSave, Sheet Change etc..,

Comments

Power Query - "SUBSTITUTE" Function: Remove/Replace multiple values in a column in One Step.

Often times, when you get data from a source, there will most probably be something incorrect that needs to be fixed using an ETL process of Power Query. And most of those transformations would require either Replacing or Removing string's that are not necessary. For example, if you extract any financial data from a source which has multiple currency symbols, there's a chance that the numbers get extracted along with the currency symbols like "$700"/"€700" instead of 700. And these type of cases makes it tough to Transform the Data to our wish as the value will be considered as a text instead of a number. In those type of cases, we would most likely have to create multiple steps to remove the multiple currency symbols from the Column. But thanks to the solution provided by Marcel for one of the questions posted on Stack Overflow, with a little manipulation of the Query language (M), we can replace/Remove multiple strings in one step using the List. ...

Grasshopper: Voronoi Holes on a Planar surface

One of the best natural examples for a Voronoi is the Wing structure of a dragon fly.Grasshopper can help us to build a shape like this in Rhino. Image Courtesy: The Pond blog Grasshopper by default has a node for Voronoi, we just have to prepare the necessary information to feed into the node. The following example shows how to create a Voronoi shaped holes in a surface Create a planar Surface from rhino or grasshopper Randomly Populate the surface with points using the Populate 2D Node Feed the surface and the points into the Voronoi node and feed a number slider too to adjust eh radius This forms the required Voronoi structure which you can edit the number of points or radius. To create the holes we need to offset each and every inner portion towards its centre using the Scale node We can find the centre of each of the inner portions using Area node I'm not sure why but using the offset command su...

Grasshopper: offsetting curves on surface vs scaling curves on surface

Though in Grasshopper Offset and Scale are two different node functions, when it comes to a planar surface, the results of the both are similar. But, I found the " Scale" node to be effective when you want to loft the resultant curve with another. The following images show the different results of a Voronoi structure that yielded when scale and offset nodes are used. When the Offset node is used When Scale is used

Group and Scribble in Grasshopper & Rotating scribble

Grouping & Scribbling in grasshopper can be helpful, especially when your document is filled with hundreds of nodes with wires going all around the screen. Often you might find it difficult to locate the set of nodes you'd like to adjust or alter for your project. So grouping the nodes and annotating the groups would be a nice idea to keep your document organised. Grouping In order to group a set of nodes, you just select them and right click on the screen(not on any of the nodes). You'll find the option to group. You can even name the groups just by right clicking on the group. Although naming the groups would be enough to identify the group. The name bubble of the group will disappear when you zoom too far out. So, the solution to be able to identify the group from a zoomed out fairly far is to add a scribble(with a text height of min 25) in the group. Scribble & Group in Grasshopper Scribble Like the name says, Scribble is just to add some notes f...

Guru-G

Search This Blog