Visual Basic Archives Page 61

-       Selva V Pasupathy , Hyderabad, India

   600. How to Play Sounds Using Visual Basic for Applications In Microsoft Excel 2000, cell notes have been replaced with cell comments and sound notes are no longer supported. However, you can use a Microsoft Visual Basic for Applications procedure to play sounds. To play a sound in a Visual Basic… KB#213777. Keywords: API, Sounds, VBA, Macro, Web, Comments

   601. How to Determine Whether VBA Is Enabled for Office XP Application This article explains how to determine whether Microsoft Visual Basic for Applications (VBA) is installed and enabled for Microsoft Office… KB#285884. Keywords: API, VBA, Object, Reg istry

   602. How to Programmatically Change the Project Name Property By default, when you open a new workbook in Microsoft Excel 97, the Name property for the workbook project is VBAProject (without the quotation marks). This naming convention may cause a proble m if you manually or programmatically attempt to… KB#161214. Keywords: Errors, VBA, Macro, Object, VBE, Web, Window

   603. How to Make Sure That Your Office Document Has a Valid Digital Signature This article describes how to: Make sure that a digitally signed Microsoft Office document has a valid digital signature. Make sure that a document was not tampered with after t he document was originally digitally… KB#329228. Keywords: VBA, Web, IS

   604. How to Use Application.Match to Locate Date Values on a Worksheet In Microsoft Excel, you may run into problems if you use the Match method in a Microsoft Visual Basic for Applications macro or procedure to locate date values on a worksheet. When you use a macro to search for dates, you need to search for the… KB#213643. Keywords: Dates, Errors, VBA, Macro, Web

   605. How to convert Excel column numbers into alphabetical characters This article discusses how to convert integers into alphabetical… KB#833402. Keywords: VBA, Web

   606. How to Programmatically Save a File to a Network Drive In Microsoft Excel, you can save a file to any drive to which you have write and delete privileges. In addition, you can use a Microsoft Visual Basic for Applications macro to save the active wor kbook and use a variable for the file name. You can… KB#141512. Keywords: VBA, Macro, File Name, Save A File, Web

   607. How to Programmatically Hide and Unhide the Windows Taskbar By using API calls in Visual Basic for Applications, you can programmatically hide the Microsoft Windows 95/98 or Microsoft Windows NT 4.0 taskbar. This article shows you how to create the t wo functions that you need to hide and unhide the… KB#202099. Keywords: API, VBA, Web

   608. How to Use Visual Basic to Create a Dynamic Chart When you record a macro to create a chart, the source address of the cells that you use to create the chart are fixed by Microsoft Excel. This article contains a Visual Basic for Applications macro th at you can use to create a chart when the… KB#213780. Keywords: Charts, VBA, Macro, Object, Web

   609. How to Remove the Control Menu and Program Window Controls In Microsoft Excel, you can create a Microsoft Visual Basic for Applications macro to remove or disable the program window and worksheet… KB#213456. Keywords: Errors, VBA, Macro, Web, Windo w