Home > Excel Help Portal > Programming Excel

<<  (Page 2)  Previous              Next  (Page 4)  >>

Programming Excel

The ExcelUser portal offers links to help pages created by top
Excel web sites. This section discusses ways to program
Microsoft Excel using VBA.

101. How to Pass Variables in Visual Basic for Applications Macros In Microsoft Excel, when you use a Microsoft Visual Basic for Applications macro or procedure, you can retain the value of a variable by doing any of the following: Pass the variable to another workbook. (This way you can retain the value of... KB#213365. Keywords: VBA, Macro, File Name, Toolbar, Web

 
102. How to Use File DSNs and DSNless Connections When you use a connection string that does not use a data source name (a DSN-less connection string) to connect to an external data source in Microsoft Excel, information that is required to connect to the external data source is stored in the... KB#165866. Keywords: Query, Microsoft Access, Errors, VBA, Setup, Error Message, File Name, Files, Registry, Save A File, Setup Program, Toolbar, Text Files

 
103. How to Use the WebBrowser Control to Open an Office Document in Visual Basic .NET You may want to display, or embed, an Office document directly on a Visual Basic .NET Form. Unlike earlier versions of Visual Basic, Visual Basic .NET does not provide an OLE control that allows you to embed an Office document on a form. If you... KB#304643. Keywords: ActiveX, OLE, Errors, Printing, Class, Command Button, VBA, Object, Setup, Toolbar, Internet Explorer, Web

 
104. Font Also see Changing Font etc in cell comments Menus (place holder) sheet tabs (place holder) Right-click on your desktop and choose PropertiesDisplayAdvancedActive Title Bar*set the font size to suit your needs*OKOKOK. Go into Control Panel, Display, Appearance and enlarge the size of the scrollbars.... Keywords: Download, API, Colors, Fonts, Format, Styles, Formulas, Links, Printing, VBA, Macro, UDF, User Defined Function, Files, Templates, HTML, Web, Comments

 
105. How to Programmatically Measure the Visible Range in Points You may want to measure the exact range of a Microsoft Excel worksheet in points. This information can make it easier to fill the visible range or a worksheet with a graphic object, such as a chart. This article describes a sample Microsoft... KB#213323. Keywords: Charts, Graphic, Borders, Fonts, VBA, Macro, Object, Web, Column Width, Window

 
106. Excel - adding data to a list People often want to display a form to spreadsheet users in which they can enter data which is then added to a list, possibly on another worksheet. The form may incorporate some form of checking to ensure that the new record is valid. There are two processes described here, one using a visual basic... Keywords: SERIES, Data Table, Format, Errors, Formulas, VBA, Macro, Toolbar, Links, Web, Window

 
107. Excel COM Addins and Automation Addins Microsoft Excel 2002 supports Automation Add-ins in addition to Component Object Model (COM) Add-ins. This article explains the differences between these two types of... KB#291392. Keywords: Add-In, ActiveX, Formulas, Startup, Object, VBA, Registry, Toolbar, Web

 
108. How to Use the TabStrip Control on a UserForm This article explains how to use the TabStrip control on a UserForm, and provides Microsoft Visual Basic for Applications sample code for this... KB#213254. Keywords: Borders, Colors, Command Button, VBA, Macro, Object, UserForm, Web, Window

 
109. How to Use Macros to Set Row Height and Column Width Microsoft Excel uses the font assigned in the Normal style as the basis for column widths. There is no direct way to assign exact column widths in inches or centimeters without trial and error. Excel bases its measurement of column widths on... KB#213422. Keywords: Fonts, Format, Styles, Errors, VBA, Web, Column Width

 
110. Macro to create a table of contents Thanks to Matt who sent this week's question: I have a large and growing worbook (lots of sheets). I have included page numbers in the footer while printing, however it is getting harder and harder to navigate when we are in a meeting. Is there a way to print a table of contents based on worksheet... Keywords: Format, Arrays, Errors, Page Setup, Printing, VBA, Macro, Object, Web, Window

 
111. SHELL invoked from VBA This should work, it will output one line per selected cell cells are numbered left to right and down, so selecting a single column should work. In Excel 2000 you can have multiple selection ranges if you have multiple selection ranges each range will be processed independently in the order that it... Keywords: Export, Startup, Printing, VBA, Object, File Name, Files, Text Files, HTML, Hyperlinks, Web, Comments

 
112. How to automate Microsoft Excel from Visual Basic .NET This article demonstrates how to create an Automation client for Microsoft Excel by using Microsoft Visual Basic... KB#301982. Keywords: Charts, SERIES, Download, Sales, Borders, Colors, Fonts, Format, Styles, Arrays, Formulas, VBA, Object, Web, Window, RAND, COLUMN

 
113. How to Use the TabStrip Control in a UserForm This article explains how to use the TabStrip control in a UserForm and provides a Microsoft Visual Basic for Applications... KB#155009. Keywords: Borders, Colors, Command Button, VBA, Macro, Object, UserForm, Web, Window

 
114. How to Display a Custom Office Assistant Balloon You can customize the Office Assistant to display messages in balloons with buttons or check boxes that you specify. At the bottom of the Office Assistant, you can display several types of buttons, such as: OK ,  Cancel ,   Retry , and so... KB#213731. Keywords: Sales, Arrays, Printing, VBA, Macro, Object, Web

 
115. Contextures Sample Spreadsheets Assign Employees to Single Task Per Day-- Names are removed from the data validation dropdown list once they've been assigned to a daily task. DataValDailyList.xls 31 kb Create Dependent List for Selected Column -- The first dropdown list is based on column headings. The second list contains unique... Keywords: Charts, Plot, Advanced Filter, AutoFilter, Sorting, Dates, Days, Sales, Formulas, PivotTables, Printing, Combo Box, Macro, UserForm, Scenarios, Validation, RAND

 
116. How to identify and Remove PLDT, CAR, and SGV Macro Viruses in Excel 2000 This step-by-step article shows you how to identify and remove PLDT, CAR, and SGV macro viruses in Excel 2000. In November 1997, Microsoft identified a new macro virus, the PLDT macro virus, that infects workbooks in Microsoft Excel for Windows.... KB#213512. Keywords: Export, Third-Party, Format, Styles, Macro, VBA, File Name, Files, Web, Window

 
117. How to Run Office Macros by Using Automation from Visual Basic .NET This step-by-step article describes how to call Office macros from a Visual Basic .NET Automation client. You can use Microsoft Office Automation to open a document or create a new document that contains a Visual Basic for Applications (VBA) macro... KB#306682. Keywords: Download, Microsoft Access, Styles, Errors, Combo Box, VBA, Macro, Object, Error Message, Web

 
118. How to Programmatically Manipulate a UserForm The programming object model in Microsoft Office 97 for Windows allows you to create a custom dialog box (a UserForm) by using a Microsoft Visual Basic for Applications macro. This article contains sample Visual Basic code that creates and... KB#185774. Keywords: Class, VBA, Macro, Object, UserForm, VBE, Web, Window

 
119. How to Obtain the Window Handle for an Office Automation Server by Using Visual Basic .NET This article demonstrates how to obtain the window handle of a Microsoft Office application while automating that application from Microsoft Visual Basic... KB#302281. Keywords: Download, API, Microsoft Access, Class, VBA, Object, Web, Window

 
120. How to Automate Excel from Visual Basic .NET to Fill or to Obtain Data in a Range by Using Arrays This article demonstrates how to automate Microsoft Excel and how to fill a multi-cell range with an array of values. This article also illustrates how to retrieve a multi-cell range as an array by using... KB#302094. Keywords: Download, Arrays, Errors, VBA, Object, Window

 
121. Configuring Excel Excel 2002 for Dummies When a new spreadsheet spreadsheet is started you may wish to use a selection of preferred options such as the font name and size of a title in cell A1, headers and footers and number formats. These items can be stored in a template called Book.xlt which is automatically... Keywords: Wildcard, Fonts, Format, Patterns, Styles, Errors, Formulas, Startup, Page Setup, Printing, Macro, VBA, Files, Templates, Toolbar, Window

 
122. How to custom Sort or Prevent Auto Sort in PivotTable in Excel 2000 This step-by-step article describes how to custom sort a PivotTable or keep a PivotTable from being automatically sorted. In Microsoft Excel, data in a PivotTable is automatically sorted. There are no options available to turn this automatic... KB#235537. Keywords: Sorting, Format, Arrays, Formulas, PivotTables, PivotChart, VBA, Macro, Web

 
123. How to Use the WebBrowser Control to Open an Office Document When working with Office Documents you may want to display these documents directly in Visual Basic, but do not want to create an embedded OLE object using the OLE container control. Instead, you would like to link to an existing document and open... KB#243058. Keywords: ActiveX, OLE, Errors, Printing, Command Button, VBA, Object, Setup, Toolbar, Internet Explorer, Links, Web, Window

 
124. Excel Window, Workbook Window, Worksheet Window Keywords: Borders, Gridlines, Formulas, Printing, Macro, VBA, Toolbar, Web, Comments, Window

 
125. How to Automate Microsoft Excel from Visual Basic This article demonstrates how to create and manipulate Excel by using Automation from Visual... KB#219151. Keywords: Charts, Sales, Borders, Colors, Fonts, Format, Arrays, Errors, Formulas, VBA, Object, Window, RAND, COLUMN

 
126. Changes Made to Excel CommandBars Through Automation Are Not Saved When you make changes to the Microsoft Excel CommandBars through Automation, the changes are applicable only in the instance of Excel that is being automated. The changes made do not appear in later instances of... KB#241652. Keywords: VBA, Macro, Object, Toolbar

 
127. How to Create/Format an Excel Workbook Using Visual J++ Automation This article describes Automating Excel 97 or later from a Visual J++ client using the Java programming language. The project uses the Excel type library, and illustrates object oriented... KB#219430. Keywords: Charts, DLL, Sales, Borders, Fonts, Format, Arrays, Errors, Formulas, Class, Object, VBA, Window, RAND

 
128. How to Record a Macro Using Relative Cell References In Microsoft Excel 97, unlike in earlier versions of Microsoft Excel, there is no menu command to record a macro that uses relative cell references. However, you can click Relative Reference on the Stop Recording... KB#161677. Keywords: VBA, Macro, Menu Command, Toolbar, Web

 
129. Error Message: An Error Occurred While Loading 'Sheet1111111111111...' In Microsoft Excel 2000, when you try open a file that was saved in Excel 97, you receive an error message similar to the following: An error occurred while loading 'Sheet111111111111111111111111111'. Do you want to continue loading the project?... KB#236299. Keywords: Add-In, Download, Errors, VBA, Macro, Error Message, Links, Web, Window

 
130. Securing Visual Basic Code in Microsoft Excel In Microsoft Excel 97, unlike earlier versions of Microsoft Excel, you cannot hide Visual Basic for Applications modules. If you want to prevent users from seeing Visual Basic code, you can lock the Visual Basic project in the workbook and... KB#167909. Keywords: Add-In, Arrays, VBA, Macro, File Name, Toolbar, Web

 
131. How to set Up and Use the RTD Function in Excel 2002 This step-by-step article discusses the new functionality that the RealTimeData (RTD) function provides. Microsoft Excel 2002 provides a new worksheet function, RealTimeData (RTD), which allows you to call a Component Object Model (COM)... KB#289150. Keywords: Add-In, Dates, Errors, Formulas, Links, Startup, Macro, Object, VBA, Setup, Error Message, File Name, RTD

 
132. How to Use the MultiPage Control in a UserForm This article explains how to use the MultiPage control in a UserForm and provides a Microsoft Visual Basic for Applications... KB#155374. Keywords: VBA, Macro, Object, UserForm, Web, Window

 
133. Overview of the Excel 97 Security Patch: November 11, 2003 Microsoft has released a patch to Microsoft Excel 97 for Windows. This patch fixes a vulnerability under certain scenarios where an Excel file can be modified in such a way that a macro that includes Microsoft Excel 4.0 Macro Language (XLM)... KB#830356. Keywords: Download, Errors, Macro, Object, CD-ROM, Error Message, File Name, Files, Hyperlinks, Scenarios

 
134. How to save Files in Other Formats in Excel 2000 This article explains how to save Excel 2000 files in different formats and provides additional information to consider when you save files. Save a File in a Different Format By default, Excel saves files in the Microsoft Excel Workbook format.... KB#212174. Keywords: Add-In, Charts, Format, Class, Macro, VBA, Files, Save A File, Templates, Text Files, Web

 
135. How to Record a Macro Using Relative Cell References In Microsoft Excel 2000 and Excel 97, unlike versions of Microsoft Excel earlier than Microsoft Excel 97, there is no menu command to record a macro that uses relative cell references. However, you can click Relative Reference on the Stop... KB#213740. Keywords: Formulas, VBA, Macro, Menu Command, Toolbar, Web

 
136. How to Help Protect Visual Basic Code in Excel In Microsoft Excel 2000, unlike versions earlier than Excel 97, you cannot hide Microsoft Visual Basic for Applications modules. If you want to prevent users from seeing the Visual Basic code, you can lock the code in the workbook and thereby... KB#213903. Keywords: Add-In, Arrays, VBA, Macro, File Name, Toolbar, Web, Window

 
137. How to Use Input Boxes with Visual Basic for Applications In Microsoft Excel, you can create a Microsoft Visual Basic for Applications procedure that uses an input box to gather data from a user. To create an input box, you can use the InputBox method or the InputBox function. The main difference between... KB#142141. Keywords: SERIES, Errors, VBA, Macro, Object, Error Message, Web

 
138. Worksheet Functions, HELP Keywords: Download, Format, Formulas, Links, Macro, Object, VBA, VBE, Toolbar, Web, Comments, Window

 
139. Create a Magic Square for any number in Excel Many years ago, I worked at Telxon with Dave Strong. Dave had mentioned that his grandfather would perform a trick where he would ask someone in the room for any number. He would then think very hard and slowly but deliberately build a 4x4 matrix. Every row, column, and diagonal of numbers would... Keywords: Years, Download, Patterns, Formulas, Macro, VBA, Files, Web

 
140. How to export Data in a DataGrid on an ASP . NET WebForm to Microsoft Excel Use this step-by-step guide to populate a DataGrid Web server control on an ASP.NET WebForm and then export the contents of the DataGrid to Microsoft Excel. Techniques This article describes two techniques for exporting the data in the DataGrid... KB#317719. Keywords: Export, Microsoft Access, SQL, Format, VBA, HTML, Internet Explorer, Web, Window

 
141. How to transfer Data to Excel by Using SQL Server Data Transformation Services SQL Server Data Transformation Services (DTS) is a powerful tool that you can use to easily transfer data between OLE DB data sources, transforming that data in the process (if you chose to do so). This article describes how to use the... KB#319951. Keywords: Export, OLE, SQL, Errors, VBA, File Name, Files, DB

 
142. How to Set Print Areas and Print Titles on a Worksheet This article describes different methods that you can use in Microsoft Excel to set a print title and a print area on your... KB#214012. Keywords: Graphic, Page Setup, Printing, VBA, Macro, Toolbar, Web

 
143. How to Use Dynamic Arrays in a Macro In Microsoft Excel, an array can be declared to be dynamic so that the number of elements and dimensions can be changed later while the code is... KB#142134. Keywords: Arrays, VBA, Macro, Web

 
144. Inserting and Formatting Text in Headers and Footers In Microsoft Excel, you may want to use a header or footer in a worksheet. The More Information section of this article discusses the formatting codes that you can use to automatically insert and format text in a header or footer, and it... KB#142136. Keywords: Fonts, Format, Outline, Printing, VBA, Macro, Setup, File Name, Web

 
145. DDE Clients Cannot Use a RUN Command to Run an Inline Macro After a Security Update Client applications can use Dynamic Data Exchange (DDE) to issue a macro RUN command to Excel 2002. This command may stop working after the user updates to Service Pack 2. To the client application, the method call appears to succeed, but the... KB#821136. Keywords: Dates, DDE, Errors, Macro, VBA, Error Message, File Name, Files, Web, Window

 
146. How to save Files in Other Formats in Excel 2002 This article explains how to save Microsoft Excel files in different formats, and provides additional information to consider when you save files. How to Save a File in a Different Format By default, Excel saves files in the Microsoft Excel... KB#291064. Keywords: Add-In, Charts, XML, Format, Class, Macro, Files, Save A File, Templates, Toolbar, Text Files, Internet Explorer, Web

 
147. How to Convert Text to Numbers When you import a file that was created in another program (such as dBASE or Lotus 1-2-3) or that was downloaded from a mainframe, Microsoft Excel may recognize some numbers as text. This causes functions such as SUM and AVERAGE to ignore the... KB#181298. Keywords: Format, VBA, Macro, Web, AVERAGE, TRIM, CLEAN, VALUE

 
148. Find Command Doesn't Work Across Worksheets in Group When you use the Find dialog box to locate specific information, Microsoft Excel finds only the first occurrence of the value (even if you have selected multiple worksheets that contain this information). If the information is not located on... KB#124105. Keywords: VBA, Macro, Web, Window

 
149. How to Use Dynamic Arrays in a Macro In Microsoft Excel, an array can be declared to be dynamic so that the number of elements and dimensions can be changed later while the code is... KB#213619. Keywords: Arrays, VBA, Macro, Web

 
150. How to automate Excel Text to Speech in Another Office Program This step-by-step article explains how you can use the Text to Speech functionality of Microsoft Excel in other programs, including Microsoft Word, Microsoft PowerPoint, and Microsoft Outlook. Microsoft Excel is the only Microsoft Office XP... KB#287120. Keywords: OLE, Errors, Speech, VBA, Macro, Object, Web

 

<< (Page 2)  Previous              Next  (Page 4) >>