VBA algorithm

[MAHAVISHNU]

Dear All,

I have one query in VBA. I have attended interview. they ask "what kind of algorithm you have used in VBA". I have written VBA for automate the Pivot table , Saving the report from pivottable .

Now what kind of answer i have to give. what are the Algorithm available in VBA.

Please suggest.

Thanks,
C.Mahavishnu

 

[joeu2004]

You have already answered your own question.

One definition of "algorithm" is: ``a process or set of rules to be followed in calculations or other problem-solving operations, especially by a computer``.

So a VBA algorithm is any sequence of statements in VBA that performs an operation. Simply put: it is any VBA implementation.

The interviewer simply wants to know what kinds of problems you have solved by implementing VBA subroutines and functions.

You have already provided examples: automate the set up of a pivot table; and saving a pivot table report.

There is no way for us to know what kinds of VBA implementation the interviewer is interested in.

 

[MAHAVISHNU]

Dear,
thank you very much. it is helped me a lot.