Calling Macro Visual Basic Procedures of a Different Project

July 23, 2009 by vba excel · 1 Comment
Filed under: Excel Vba 

Excel Macro Vba Calling macro visual basic procedures of a different project [Q]
I have different excel macro VBA procedures in different excel workbooks and I need to call a procedure from one workbook to another. How can I d..... Read The Solution..

Macro Interactive Code on Excel Worksheet

July 21, 2009 by vba excel · 2 Comments
Filed under: Excel Vba, Excel Worksheet 

Excel Vba Macro Interactive Code on Excel Worksheet [Q]

I have a workbook with one worksheet. The worksheet has a list of 50
questions ranging from B4:B54. I am looking for a code that will select each question randomly..... Read The Solution..

Using Relative Excel Spreadsheet References in Vba macro

July 20, 2009 by vba excel · 2 Comments
Filed under: Excel Spreadsheet, Excel Vba 

Excel Vba Using Relative Excel Spreadsheet References in Vba macro [Q]
I want to move the contents of excel spreadsheet cell (in an array) when I know its column and relative row number using excel vba macro. The requested cell..... Read The Solution..

Saving Excel File with Name and Date Details

July 20, 2009 by vba excel · Leave a Comment
Filed under: Excel Tips 

Excel Tips Saving Excel File with Name and Date Details [Q]
I need excel tips to save Microsoft excel file I am working on (template) with the name of
the file and the date?

ex. “filename - 2008-10-29.xlsR..... Read The Solution..

Resize Range for Column in Workbook

June 23, 2009 by vba excel · 1 Comment
Filed under: Excel Spreadsheet, Excel Tips, Excel Worksheet 

Resize Range for Column in Workbook [Q]

I dont know how to resize range for column in excel workbook, i have four named ranges that relate to a column of data starting on row 1 going
to the end of the column data on my e..... Read The Solution..

« Previous PageNext Page »