For the most part the act of controlling Excel or Word from a Delphi application is not terribly challenging. Hi all, Please give me your suggestions for making a cell in Excel to Number format with 4 decimal places using OLE method. Technology November 16, 2011 Embedding a PDF in an Excel Worksheet The strangest thing happens after embedding a PDF in Excel. Excel VBA Worksheet object is the one of the most frequently used object while automating any task with VBA. And we also need two SSIS variables. An object is information an OLE server program exchanges with OLE clients. I experienced locked Active-X-Controls in Excel 2003 and not in parralelly installed Excel 2013 on the same computer. Step 3: The function below receives as input an reference to the excel workbook. Development experiences The aim of the project was to create a Class with exactly the same properties, methods and events as it is in the Calendar Control. My task is to copy the indvidual text values and paste them in a template in AutoCad. An Excel spreadsheet can be used in a VB. Select the Paste icon. Iam using T-code FBL1N which will put out the details of a particular vendor. 1 reference. I am controlling Acrobat Pro 10 from MS Excel. From the following pictures to show how to add Excel reference library in your project. The Table references the Species column in a Table named Table3. In the example shown, the formula in C5 is:. VBA - Excel Objects - When programming using VBA, there are few important objects that a user would be dealing with. To specify the OLE server running on the local machine, do not specify the MachineName parameter. Select Database. Adding an Excel spreadsheet to your OneNote page is a great way to create a copy of your Excel data to view in OneNote, so you don’t have to switch back and forth between applications. OLE is a compound document standard developed by Microsoft Corporation. This project has been started in June 2001 and is still in progress. Excel actually offers a very nice way to embed files into your sheet very easily. In Microsoft Windows applications programming, OLE Automation (later renamed to simply Automation) is an inter-process communication mechanism created by Microsoft. Iam using T-code FBL1N which will put out the details of a particular vendor. OleObject property returns an OLE server by its name and the name of the machine on which it is running. Controlling Word from Excel using VBA. Excel ColorIndex. How to format an Excel file using C# When programming with Microsoft Office Excel, you can interact with the objects provided by the Excel object model. What’s in this guide? This document provides a detailed reference of all the calls needed for OLE, DDE, and Apple events. If you choose an other name, then make sure to also change that in the script task of step 3. Microsoft Excel Object Library This defines all of the elements of Excel. After installing the July update of Power BI publisher for Excel, open Excel and go to the Power BI ribbon tab. The following tricky way will help you find out and list all links in workbook quickly. JC Zalog’s suggestion is good advice, but is specific to a problem that was common around the time the question was originally posted. I named mine "MyExcelFile". So I stopped it and begin again from 0 and read again the DXL Reference Manual. 19 November 1990. Excel and OleDb basics to advance operations DescriptionThere are several ways to work with Excel, no one method is proper for all situations which is important to know. It clears all the data in the current word document and it reads the values from the workbook:. View 5 Replies. The ScriptMain is the entry point class of the script. xlsx to other type of formats PDF, Image, CSV, XML, inserting OLE object and etc. Then make sure the reference Microsoft Office PowerPoint 12. Basic information about OLE automation using VBA in Microsoft Excel. I have created a SQL query procedure called from Excel by an External SQL connection: There is a Where clause to limit the data by a date field between "StartDate" and "EndDate". Note: Nested OLE objects may cause problems. When you copy from one Microsoft Office application into another, the default Copy-Paste sequence embeds an object of the source application into the target application's document. The object definition is. Hide/Show Zero Balance Rows - Use this option to hide or show zero balance rows on the Excel spreadsheet. Free to try with no limitation in 30 days. A cell reference in spreadsheet programs such as Excel and Google Sheets identifies the location of a cell in the worksheet. In the From OLE DB dialog, enter your connection string, then press OK. Then, if you change the original information, you need to update only the links in order to update the document containing the OLE objects. VBA-Excel: Reference Libraries in Excel WorkBook. Opening and Saving Excel/Workbooks ; 2. See Excel’s Help system for more details. When you install Office 2007 or Excel 2007, make sure that you select the Visual Basic Editor component, otherwise you will not be able to write VBA code. Set objExcel = CreateObject("Excel. Close all Microsoft® Excel® Workbooks. Select the range within Excel that you want in AutoCAD, right-click and select 'Copy'. Development experiences The aim of the project was to create a Class with exactly the same properties, methods and events as it is in the Calendar Control. They are named, origianlly enough, lstData1 -> lstData4. In the From OLE DB dialog, enter your connection string, then press OK. 1401 64 bit. As a valued partner and proud supporter of MetaCPAN, StickerYou is happy to offer a 10% discount on all Custom Stickers, Business Labels, Roll Labels, Vinyl Lettering or Custom Decals. The References added are: a) Visual Basic for applications b) Microsoft powerpoint 14. Here are some examples of the connections strings you can use to open databases in Exportizer Enterprise. Also, we all know how essential Excel application is, so it is important to handle the Excel file properly and follow best preventive steps to protect the Excel files from getting corrupted. Often I find myself with data in an external database, such as Access and continuously editing the query there to get the data how I want it in Excel. Hi all, Please give me your suggestions for making a cell in Excel to Number format with 4 decimal places using OLE method. become available to use in the application. If you had tried one or a few of them before but failed, then choose those you haven't tried yet. 1000) 64 bit, Power Query 2. I have an existing SQL data connection in Excel using a SQLOLEDB. An OLE file can also contain storages. C# OLEDB Connection The C# OleDbConnection instance takes Connection String as argument and pass the value to the Constructor statement. Excel 2010: (14. Store documents online and access them from any computer. Recent Posts. Project -excel-. From the following pictures to show how to add Excel reference library in your project. You can now write code in VBA, C#, Powershell or other languages,. Let’s start by building a basic web bot to open a search page, submit a search request, evaluate and scrape the results page, and return the results to Excel. 1 reference. A reference website for students and beginners Latest Articles. In Excel 2016 you can now use Macro Recording and Object Model (VBA, PowerShell, C# etc. For instance, if we place a command button on a worksheet, Excel will give it the default name CommandButton1. I am controlling Acrobat Pro 10 from MS Excel. With user forms you can create GUIs (Graphical User Interface) for user who do not have much excel knowledge and make you excel programs more professional looking. CopyFromRecordset of Excel VBA Range method can be used if you want to copy the data from a record set. Here, for example, are the steps required to link an Excel spreadsheet: 1. The problem is that there are certain things that aren't obvious that you need to know about, and you feel awkward about asking such simple questions. Set a reference to an Excel worksheetcell in the SQL where clause? Is it possible with the OLE DB-Query in Excel (query to Oracle Database) to refer to an Excel worksheetcell in the where clause? E. Hide/Show Zero Balance Rows - Use this option to hide or show zero balance rows on the Excel spreadsheet. VBA / Excel / Access / Word examples (example source code) Organized by topic. In the From OLE DB dialog, enter your connection string, then press OK. While you use Automation to work with the objects in another component's object model, you use OLE to include objects from other components in a Microsoft Access form or report. The cells I want to update are spread across different locations in the Excel file. What I have been doing is AutoCad erasing the graphics from my drawing but the link still remains in the xref manager window. Preparing MS Excel 2007. xls, *,xlt, *. 0 Object library c) OLE Automation d) Microsoft Office 14. Before you write code, you must add a reference to the Microsoft Excel object library. VBA Wait and Sleep Functions - Explained Wait and Sleep functionality in programs is required to hold or pause the program execution for a specified time. xlApp – will be a reference to a hidden Excel application; xlWb – will be a reference to the workbook opened as a result of opening the file to import; xlWs – will be a reference to the worksheet having data to import. I recently had the need to display an Excel spreadsheet in a drawing. Microsoft® Office External Reference Links; Microsoft® Office Object Linking and Embedding (OLE) Links; To resolve this problem, do the following: Check for unresponsive instances of Microsoft® Excel®. In this short article, we will see how you can get Excel to better handle your pictures, and then we will explore another option by using RowShare, a collaborative table that integrates with Excel. I should note that we have both Excel 2010 and Excel 2016 installed on all of our desktops due to some issues we have when just using Excel 2016 as this refresh works fine in Excel 2010. See Excel’s Help system for more details. Re: SQL Query (ODBC) with Cell Reference Hi All, New to this forum and SQL, Found the post above and all was working fine, problem is when i closed the file and reopened it, hit refresh, Excel hangs up and says the file is corrupt. The dialog shown below opens. Thanks & Regards Teja. See this post if you receive Microsoft Excel is waiting for another application to complete an OLE action. exe to create a self-signed test certificate that can be used with IIS for SSL; how do i limit the number of rows returned by an oracle query after ordering. In this AutoCAD excel data link table creation is explain. Access has the capability to act as an OLE client. I've searched the web high and low and can't find anyone with the same issue yet I've found this on 2 out of 5 machines in a test group. An AS/400-specific ADO reference, A Fast Path to AS/400 Client/Server Using AS/400 OLE DB Support (SG24-5183-00), is also available at www. Listing all of them along with their syntax and examples would require an entire book. But in the earlier blog, we have covered how to merge data in a single sheet when the data are coming from the same sheet. In Microsoft Windows applications programming, OLE Automation (later renamed to simply Automation) is an inter-process communication mechanism created by Microsoft. The Code I added in RED. Visual Basic has established a reference to Excel because of a line of code that calls an Excel object, method, or property without qualifying the element with an Excel object variable. Sign in - Google Accounts. Rather than create a new instance of the OLE object in each PeopleCode program, you should create one instance of the OLE object in a PeopleCode program that runs when the component starts (such as RowInit) and assign it to a global variable. Let’s start by building a basic web bot to open a search page, submit a search request, evaluate and scrape the results page, and return the results to Excel. 152 (inclusive). This tool will be explained in a separate section below. You can join data from different areas or worksheets. Using this command they can’t seems to control the area that they are trying to show, so the display of the information showing is incomplete most of the time. It draws the document using native geometry so the result is a bound collection of mtext (and table) objects that is linked to the original document, can be plotted without problems and is highly portable to other users. It is important to note that OLE objects in ACA drawings are not displayed or plotted in external references or block references. How to Extract Properties from Excel/Word without Opening File using VBA How to get CustomProperties from Excel Workbook/Word Document (VBA) without physically opening the file There are many cases where we need to get the document property without the file being opened in VBA. Database Connectionstrings. Select ACT! OLE DB Provider for Reporting 2. VBA Wait and Sleep Functions - Explained Wait and Sleep functionality in programs is required to hold or pause the program execution for a specified time. Solution: This behavior indicates that the OLE was not inserted as a linked object. 19 November 1990. 0 Object Library It is worth noting that Automation has been around for quite a while in MS-Office. Drag and resize it as needed. Follow the steps to get to the Add-Ins dialog (Developer tab > Excel Add-Ins, File tab > Options > Add-Ins > Go, or Alt+T+I). First, we will create a schema based on XML source data. Lookup Wizard A wizard that helps you create a field whose values are selected from another table, query, or list of values. Include the needed components which are already developed by experts. L'utilisation du Variant est quasi générale. Preparing MS Excel 2007. These Acrobat calls support OLE automation, DDE interapplication interfaces, and Apple events, including the use of AppleScript. We can have as many as 125 internal links within Word (i. You can add data tables to any chart you create. This database does not store the OLE objects, just their location and type. The results are lines, fills and mtext that can plot without problems and is highly portable to others. DAO is also multi-lingual-you can use it from VB and VBA environments, FoxPro, and Visual C++. ***** * This is a simple program that can be used as a reference for OLE * automation using MS-Excel. Object Linking and Embedding allows Office apps to interact with others. Here, for example, are the steps required to link an Excel spreadsheet: 1. It is important to note that OLE objects in ACA drawings are not displayed or plotted in external references or block references. Excel Basics – but first, if you’re new to Excel you should start here. 0 Object library c) OLE Automation d) Microsoft Office 14. , from Excel to Word). Get it Now. A collection of all the OLEObject objects on the specified worksheet. Right-click on the project then select Add Reference then select Microsoft. , Author, Title etc) into an excel spreadsheet. These sources can copy the data using Unicode vs non-Unicode. Select the Paste icon. Creating a linked server with the Microsoft. As previously stated, an Excel data source with a listing of places in Hawaii Counties will be used. Les commentaires au code sont minimaux, ceci n'étant pas une explication du fonctionnement d'Excel, mais simplement l'interfacage avec Delphi et le code étant, je pense, explicite par lui-même. Just for the sake of argument, suppose I, in developing an Excel add-in, included a few extraneous References in the VBE - i. OLE automation for Acrobat 10. My task is to copy the indvidual text values and paste them in a template in AutoCad. First we will need to create an excel spreadsheet. I can't add an DSN entry because it is not a static data source, I need process dynamic, uploaded excel files, which name/path I don't know in design time. Open(strPath) End Sub. Sheet Function Examples. excel worksheet name followed by a "$" and wrapped in double quotes. Basic information about OLE automation using VBA in Microsoft Excel. Assume that you have two formula that link to another workbook, for example. In Excel, select Data > Import External Data >Import Data. Though it has usability on various fronts, MS Excel can give headaches too. Visible = True Set objWorkbook = objExcel. Everytime you link an Excel workbook to other workbook, OneDrive changes the reference to the file, making reference to an online files. AutoCAD 2008 was the first release to include Data Links, a linking mechanism which relies on AutoCAD’s table feature. I can see a parameter button at the bottom of the definition of the Connection Property window, but it is grayed out. Development experiences The aim of the project was to create a Class with exactly the same properties, methods and events as it is in the Calendar Control. ) to automate your ETL solutions. Also, an OLE object that is not in the current view plane is not plotted, but the frame is plotted based on the setting of the OLEFRAME system variable. At find-more-books. I experienced locked Active-X-Controls in Excel 2003 and not in parralelly installed Excel 2013 on the same computer. Net GridView control. Description. I don't have Headers for each cell. Re: OLE object (Excel) only showing x amount of lines I agree, I have had multiple problems in the past with Ole documents rotating on plots etc. This would have successfully displayed the data in my drawing (see fig. true_values : list, default None Values to consider as True. Using the Create New option will not be linked to the external file. Using this command they can’t seems to control the area that they are trying to show, so the display of the information showing is incomplete most of the time. 0 Object library e) Microsoft Excel 14. Exemple : But : Tester si référence existe existe sinon ajouter. A storage is a folder that contains streams. 0 Object Library It is worth noting that Automation has been around for quite a while in MS-Office. This means you can take information from other OLE servers, such as Excel, and insert it in your Access tables. References to the different libraries must be created within the VBA client before any of the methods, objects, etc. Thanks Nigel Roach. Microsoft Word From Wikipedia, the free encyclopedia Jump to. I do have Microsoft Excel drivers installed in ODBC. At find-more-books. xls, *,xlt, *. VBA-Excel: Reference Libraries in Excel WorkBook. This errant reference interferes with automation code when the code is run more than one time. xls template spreadsheet and populate it. Linking Excel And AutoCAD With Data Links. Unfortunately this is not supported. make a back-up copy first and then open while holding down the [Shift] key. Excel VBA Workbook LinkSources Method. Does anyone know when the OLE reference is to be released for EG 4. The text box can be linked to a worksheet cell. VBA / Excel / Access / Word examples (example source code) Organized by topic. The last few blogs have been tough going, there's been a lot of reading and a lot of tech talk. I do have Microsoft Excel drivers installed in ODBC. Then make sure the reference Microsoft Office PowerPoint 12. For instance, if we place a command button on a worksheet, Excel will give it the default name CommandButton1. This document contains a description of the binary file format of Microsoft Excel, including all available Excel versions (for Windows) from Excel 2. Run the code and click Export to Excel to make a copy of the TheScarms. Click on Special 3. DOORS DXL - Adventures in Microsoft OLE Automation •Starting with the Excel Application, references to other embed into Excel as OLE Object. Posted 17-Jul-17 9:48am. Well, you can get at the sheet itself by specifying an index (apparently: 1-based). This means you will be unable to edit, perform relates, or make selections on the map. Go ad-free to support Sports Reference and get our fastest browsing experience Subscribe to the Play Index and get access to more data than you can imagine All logos are the trademark & property of their owners and not Sports Reference LLC. The SaveToDB add-in allows connecting to databases, to text files, and the web using Data Connection Wizard, and supports OLE DB, ODBC,. An Excel spreadsheet can be used in a VB. For more information on ABAP/OLE, search on "OLE" in the ABAP forum and check out this great article called An Easy Reference For OLE Automation by Serdar Simsekler. tlb What I have tried. The external links can be as simple as one number being. If you choose an other name, then make sure to also change that in the script task of step 3. VBScript Reference Manual InduSoft Web Studio 8 InduSoft, Ltd. This is from Office Support article on how to connect to Oracle Database. For reporting, particularly for financial reporting, see Excel Reporting and Financial Topics. The Excel document will look like Figure 2. In this post, I describe how to make an AutoCAD "Data Link" first, and then inserting a table using this Data Link. Here we are using OleDbConnection , OleDbDataAdapter , DataSet for doing these operations in an Excel file. I don't have Headers for each cell. REPORT Z_OLE_AUTOMATION_EXCEL. In earlier times, the (Missing) library was often associated with Adobe Acrobat, and uninstalling their PDFMaker. An Object Linking and Embedding (OLE) Compound File (CF) (i. Excel used to be the poor schmuck’s database, with spreadsheets that just sort of sat there. “ References- VBAProject ” dialog will appear. I want to make some changes in this load schedules. This AutoCAD tutorial is about excel data link, table to excel, drawing to excel, and insert excel with easy command, check it out!!! More Video Tutorial Aut. Created by Kevin Wilson, Object model (Excel VBA reference). To get a peek on all objects currently installed on your system, the "OLE/COM Object Viewer" is a very helpful tool. become available to use in the application. ) to automate your ETL solutions. MySQL for Excel is an Excel Add-In that is installed and accessed from within the MS Excel’s Data tab offering a wizard-like interface arranged in an elegant yet simple way to help users browse MySQL Schemas, Tables, Views and Procedures and perform data operations against them using MS Excel as. Net Web Application. MS Excel is used by individuals and business organizations for doing complex calculations, preparing charts and illustrative graphics, and storing large amount of data. Trim spaces in cells or columns in Excel The preceding and trailing spaces in cells are often unnoticeable. A linked OLE object is a reference to data that is not stored in the DGN. For example, the main stream of a MS Word document containing its text is named "WordDocument". OLE DB driver can be used on SQL Server 32-bit editions for Excel 2007 files, or later, or on SQL Server 64-bit editions for any Excel files. Older versions of Excel did not allow more than that number of rows, but the new Excel 2007 version supports up to a million rows per worksheet. Tired of download always the same excel sheet ? Without colours, borders, validations, etc… Let's see how to create a lovely excel sheet like this using ole2 objects: 😀 First you need to know the different parts in MS excel. A cell is one of the boxlike structures that fill a worksheet, and you can locate one by its references, such as A1, F26, or W345. I'm trying to migrate elaborate Word and Excel templates from Office 2003 (yes, I'm a dinosaur) to Office 2013. exe sample illustrates how you can use ActiveX Data Objects (ADO) with the Microsoft Jet OLE DB 4. 0" for linked server "XXXXXXXXX". You can name cells in Excel. from your c# application. Annotations are particularly useful for storing information about nodes that can be used by BimlScript code. Recovery of damaged *. Once I import the data – I need to remove any link between excel and Autocad so they are not dynamic. A good reference is Writing Excel Macros by Steve Roman, O'Reilly books ISBN 1-56592-587-4 I have the first edition, 1999, but surprisingly little has changed. Excel find all external links and broken links in workbook. For now 2 days, I try to add a new sheet on Excel from DOORS OLE Automations. , Author, Title etc) into an excel spreadsheet. 1) but in my experience I have found it can be. I can find the VBscripting. In the WHERE clause I have set the values as '4/1/2015' and Excel SQL Data Connection Reference Cell with Date Value. We’re going to show you how to record a macro in Excel 2016 so that you can free up your time and stop wasting it on repetitive actions. download the zip file containing the fix here. In some cases, to make the changes take effect in AutoCAD, it may be necessary to open the file in Excel again by double-clicking it and then closing it. Perl commands for Windows Excel with Win32::OLE module Related Examples. Right-click on the Task Bar and select Task Manager. Cannot initialize the data source object of OLE DB provider "Microsoft. Complete list of Excel 2019 functions of the Lookup and Reference Functions category Log In. Copy content in programs like Excel or Word, switch to PowerPoint and choose Edit, Paste Special and put a checkmark next to Link Use Insert, Object, Create from File and put a checkmark next to Link OLE links are different from File Links; PowerPoint and Windows don't allow them to be pathless or to have relative paths. xlsx file formats. Net, Excel Here Mudassar Ahmed Khan has explained how to upload Excel File and then read and import its data into DataSet or DataTable using C# and VB. Unfortunately this is not supported. Please advise If you can tell me a way to add in this functionality then I think this will fix the issue. 0 Object library c) OLE Automation d) Microsoft Office 14. VBA / Excel / Access / Word; Excel /. Using the Create New option will not be linked to the external file. Click the command button on the sheet. Fortunately, Excel lets us refer to an ActiveX control on a worksheet by using its name, without reference to the OLEObjects collection. Access has the capability to act as an OLE client. The connection passes an SQL Select statement to a MS SQL Server via OLE DB. 0 Object Library and click OK button. so what should I do to make the changes as I want. Technology November 16, 2011 Embedding a PDF in an Excel Worksheet The strangest thing happens after embedding a PDF in Excel. From the following pictures to show how to add Excel reference library in your project. We refer different Worksheets in Excel Workbooks and perform various operation on Excel Worksheets. Once I import the data – I need to remove any link between excel and Autocad so they are not dynamic. Once the reference to Excel is created we can declare variables types defined there. Therefore, it is always safe to do some trimming first, to trim out the preceding and trailing. Refer to oleobject picture in worksheet from VBA I want a picture in a form take it's picture (i. Development experiences The aim of the project was to create a Class with exactly the same properties, methods and events as it is in the Calendar Control. 0 Object library c) OLE Automation d) Microsoft Office 14. Just curious but what is the stdole library and does it need to be there?. 0 Object Library). make a back-up copy first and then open while holding down the [Shift] key. An embedded OLE object means that the other application s native data is stored within the DGN. We'll create a simple spreadsheet to illustrate the process, and place it in to Word document. Often I find myself with data in an external database, such as Access and continuously editing the query there to get the data how I want it in Excel. In the WHERE clause I have set the values as '4/1/2015' and Excel SQL Data Connection Reference Cell with Date Value. Recently I wanted to pass some input parameters to my SSIS package and had to struggle to figure out how this can be done. Excel and/or Word Help If this is your first visit, be sure to check out the FAQ by clicking the link above. From time to time, you may need to bring some worksheet data or charts that you've created in your Excel workbooks into a Word document that you're creating. The problem is that there are certain things that aren't obvious that you need to know about, and you feel awkward about asking such simple questions. Once installed, you need to add the "Developer" tab to the ribbon. This post is the second in a series about controlling other applications from Excel using VBA. The external links can be as simple as one number being. Because the data values that Excel plots on a chart can come from different ranges of data, data tables work well for showing the actual data values from the chart in a concise table. Can I get a link to the VBA library with the correct Excel VBA syntax for available commands? I have already successfully tested a subset of commands in the API reference manual because they are documented in the Acrobat Object library in MS Excel. You'll see the following dialog, which lets you select the source data to connect to in Power BI. ) you can use a formula based on the ADDRESS and SUBSTITUTE functions. This Excel tutorial collects the VBA color code list for reference purpose, which includes ColorIndex, RGB color, VB color. The References added are: a) Visual Basic for applications b) Microsoft powerpoint 14. com Using Excel with Other Office Applications. But our company has An Excel file that they want to use as reference. The results are lines, fills and mtext that can plot without problems and is highly portable to others. You could create something more sophisticated with LOOKUP functions, but they were a huge hassle to. With OLE, we are linking to the component and embedding it to our application. NET program. From time to time, you may need to bring some worksheet data or charts that you've created in your Excel workbooks into a Word document that you're creating. VBA Excel ColorIndex Property is to set color or get color for Objects like Cell color and Shape color. excel worksheet name followed by a "$" and wrapped in "[" "]" brackets. Assume that you have two formula that link to another workbook, for example. Linking Dimensions and Parametric Values into Excel: AutoCAD. Furthermore, Microsoft Excel will terminate even if the reference to it was created from a previously running instance. See Excel’s Help system for more details. When refreshing a report in Crystal Reports based off a MS Excel spreadsheet, it fails with the error: Logon Failed. A, B, C, etc. Or press Ctrl+Alt+Delete and click Task Manager. The Apache POI Project's mission is to create and maintain Java APIs for manipulating various file formats based upon the Office Open XML standards (OOXML) and Microsoft's OLE 2 Compound Document format (OLE2). Hi, In the VBEditor there are several libraries from the drop down list like MSOffice, VBA itself and Excel. Opening and Saving Excel/Workbooks ; 2.