Blog

javascript open excel

Submitted by Support on Mon, 10/13/2008 - 19:19

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

Try the following code and get it going.

======

Break Excel VBA Password

Submitted by Support on Sat, 07/12/2008 - 20:42

1. Create a new simple excel file.

Why Use Addin-Express

Submitted by Support on Wed, 03/09/2011 - 16:37

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

Submitted by Support on Fri, 04/02/2010 - 10:41

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?

Submitted by Support on Thu, 04/01/2010 - 16:56

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?

Submitted by Support on Mon, 01/25/2010 - 23:20

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

Submitted by Support on Sun, 11/22/2009 - 22:20

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

Submitted by Support on Wed, 11/11/2009 - 17:45

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

Submitted by Support on Fri, 10/30/2009 - 09:48

Please find attached your Loan Calculator sheet.

Learn How to use VBA uBound in Excel

Submitted by Support on Fri, 08/14/2009 - 22:06

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()