Question

 Using macro, how do i refresh all worksheets in excel file?

Answer First of all, you did not specify which version of MS-Excel you are using. So I will assume it to be 2003 or earlier. Here is the basic information to refresh imported data.Refreshing Data-------... Read More »
http://answers.yahoo.com//question/index?qid=20090619045304AAaokOr

Top Q&A For: Using macro, how do i refresh all worksheets in...

How to List All Worksheets in Excel Using VBA?

The Worksheet class in VBA is a powerful tool that can be used to create, manipulate and remove sheets in any Excel workbook. Each Worksheet object has a property called "Name," which refers to the... Read More »
http://www.ehow.com/how_8503026_list-worksheets-excel-using-vba.html

How to Disable One Macro in Excel 2003 Using the VBA?

Macros are snippets of Visual Basic for Applications (VBA) code that let a user automatically perform repetitive tasks by clicking a button or pressing a key combination. When certain macros are no... Read More »
http://www.ehow.com/how_7364719_disable-excel-2003-using-vba.html

How can i select records in excel using macro procedure?

There are several ways to select cells using VBA code, either individually, by rows, and/or by columns. It would take several pages of documentation to cover the basics of the very general questio... Read More »
http://answers.yahoo.com//question/index?qid=20090514011200AA30guo

How to Password Protect an Excel Worksheet Using a Macro?

The Visual Basic editor provided with Microsoft Excel gives more advanced users the tools necessary to create almost limitless macros to customize the way Excel works. A simple macro can password-p... Read More »
http://www.ehow.com/how_6815682_password-excel-worksheet-using-macro.html


feedback
loading