Blog

javascript open excel

Ok, Here is how you use Javascript to open Excel.

Try the following code and get it going.

======

Break Excel VBA Password

1. Create a new simple excel file.

Why Use Addin-Express

As I was coming from VBA it was very difficult for me to do very good with VSTO. I went through a few tutorials which helped me get started with Visual Studio.

How to enable grouping in protected sheet

Many in times we are faced with a situation where in we want to enable groups in protected sheets.

How to do vlookup Using VBA?

If you want to use any Excel function in VBA all that you need to is to use "worksheetfunction" statement follwed with the name of the function.

VBA function?

This is going to be a quick tutorial on how would you go about creating a VBA function.

Finding the Last row on Excel sheet with VBA Macro

Below is the quick VBA code which you can be used to return the last row on an Excel sheet.

How to find last row in an Excel sheet with Macro VBA

I am sure, many a times you want the VBA code to automatically find you the last row which is blank in a particular worksheet.

Loan Calculator excel sheet-calculate payments for upto 360 months

Please find attached your Loan Calculator sheet.

Learn How to use VBA uBound in Excel

Ok. Lets assume we have a variable called MyVariableTest which is of the data type string.

below is the code...

--------------
'Code starts below

Sub uBoundVBA()