Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Introduction to Excel Services and Excel Web Access
- Excel Services is a Microsoft Office SharePoint technology that makes it simple to use, share, secure, and manage Microsoft Office Excel 2007 workbooks (.xslx, xslb) as interactive reports in a consistent way throughout the enterprise. Excel Web Access is a Web Part that displays data and charts from an Excel...
- Tags: Microsoft Corp., Excel Web Access, Excel Services, Microsoft Excel, Microsoft Office, Office Suites, Software
- White papers
Additional Resources
- Connect Filter Web Parts to Excel Web Access
- Similar to other Web Parts that enable connections, a user can use Filter Web Parts to pass values to the Microsoft Office Excel Web Access Web Part, and then change the view of data in the workbook based on the value. For example, the user can select from a list...
- Tags: Web, Microsoft Corp., Sales Strategy, Microsoft Excel, Microsoft Office, Sales Force Management, Sales, Office Suites, Software
- White papers
- Input to Excel File Help Needed
- Hi all,What i'm looking to do is input information from a form into an excel file.I need to build a user friendly interface to input the data and then use excel to sort through the data so information could be displayed for a single client for instance.Is there any way...
- Tags: Microsoft Excel, jkdunne@...
- Discussion threads 2007-01-18
- TechNet Webcast: Microsoft Office Excel Services Technical Overview (Level 200)
- This webcast look at the new Excel Services, which is part of Microsoft Office SharePoint Server 2007. It shows how Excel Services extends the capabilities of Microsoft Office Excel 2007 by allowing broad sharing of spreadsheets, in addition to improved manageability and security. Attendee of this webcast will learn how...
- Tags: Webcast, Microsoft Corp., Microsoft TechNet, Microsoft Excel, Microsoft Office, Digital Media, Office Suites, Software, Consumer Electronics, Personal Technology
- Webcasts 2006-10-27
- Integrate Microsoft Excel and Access with VBA to create sophisticated applications
- There are numerous situations when VBA is not only the preferred way to obtain data, but the only way. This chapter excerpt from Integrating Excel and Access explains when VBA is required and how to incorporate it into Microsoft Excel and Access. Extracting data and moving it...
- Tags: Microsoft Access, Microsoft VBA, O'Reilly Media Inc., Microsoft Corp., Scripting Languages, Microsoft Excel, Microsoft Office, Databases, Software/Web Development, Web Development, Office Suites, Software, Enterprise Software, Data Management
- Book chapters 2006-02-24
- Stock sheet
- Hi I want to link my invoice to my stock sheet so that when creating the invoice in excel I type in the code name for the goods and the name of item and price will pull through to the invoice and I would also like it to take...
- Tags: Microsoft Office, Investment, mickydm@..., stock, Microsoft Excel, stock sheet, Microsoft Access
- Discussion threads 2007-10-26
- Open Access Qry in Excel Cmd Button
- I have an Access form from which I need to open a different Query in Excel. How do you do that?I know how to open tables, queries, spreadsheets or documents with a command button, but how do you open a query in excel the way you can with the...
- Tags: Microsoft Office, Databases, Microsoft Excel, Microsoft Access
- Q&A 2006-02-28
- Link an Excel database table to an Access database
- How about vice versa?What about linking an Access table to an Excel file?I have Excel files that need data from Access, but when I create links it takes way too long to open the Excel file.
- Tags: Microsoft Access, Microsoft Excel, database, access, excel, link, db, Excel File, Tink!, hardware, Click OK
- Discussion threads 2006-07-20
- Export Data to Excel
- If the user's goal is to temporarily or permanently move some of the Access data to Office Excel 2007, he or she should consider exporting it from the Access database into an Excel workbook. When the user exports data, Access creates a copy of the selected data or database object,...
- Tags: Microsoft Access, Microsoft Excel, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management
- White papers
- Next Evolution of Data Integration Into Microsoft Excel: Bringing Live Data Feeds to the Business Analyst Via Web Services Within Microsoft Excel
- Now that technology exists to almost effortlessly pull data feeds via Web services into Excel, the creativity and innovation will be limitless. Productivity and profitability based on this surge of information will in turn provide an incentive for more Web services to be created, reinforcing the Web services and Excel...
- Tags: Web, Web Service, Microsoft Corp., Data Integration, Microsoft Excel, Web Services, Microsoft Office, Channel Management, Office Suites, Software, Enterprise Software, Marketing
- White papers 2005-10-13
- Excel Website Pro (zip)
- Excel Website Pro produces Web sites from Excel at the click of a button. No need to understand Web programming languages. No need to use Website editing software such as Mascromedia Dreamweaver. Instantly produces your Web site. Simply upload to the Internet and you're done. With Excel Web site Pro...
- Tags: Web, Web Site, ImageSkill, Excel Website Pro, Web Site Development, Microsoft Excel, Web Technology, Microsoft Office, Channel Management, Internet, Office Suites, Software, Marketing
- Software downloads 2006-07-25
- Access-To-Excel Tool (zip)
- Control Excel from Access with a click of a button. Export/Import data, create charts, format cells. Automatically generate Visual Basic code to use in your own programs. Control Excel from MS Access now easier than ever before.
- Tags: Microsoft Access, Microsoft Excel, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management
- Software downloads 2006-04-19
- Access 2007 doesn't export to Excel
- Access to ExcelSeems like a major deficiency....Has this been reported elsewhere...has MS commented or suggested a fix?Interestingly... there was a MS ad touting a positive review by one of the major mags right next to your postRayRE: Access 2007 doesn't export to ExcelI said 'WHAT???!!!' This does seem like a...
- Tags: Microsoft Office, re@..., Microsoft Excel, Microsoft Access, Access 2007
- Discussion threads 2007-10-17
- Microsoft Office Excel Services: Technical Overview
- Excel Services, part of Microsoft Office SharePoint Server 2007 MOSS, extends the capabilities of Excel 2007 by allowing broad sharing of spreadsheets, improved manageability and security and the ability to re-use spreadsheet models through a scalable server-based calculation service and interactive web-based user interface. Excel Services provides both a web-based...
- Tags: Web, Microsoft Corp., Enterprise Content Management, Excel Services, Microsoft Excel, Microsoft Office, Productivity, Office Suites, Software
- White papers 2006-10-04
- Problem with Sharing in Excel linked access database
- Hiya,I have created an access database with table linked from Excel. There is only one user who has full control of Excel file. There are many users in the office who can open the Read-Only access database to view reports. The problem i face is, when an user opens the...
- Tags: Microsoft Excel, database, desktop, jazz_siva@..., windows, security, software, it management, networking, ms access, Microsoft Access
- Discussion threads 2007-02-20
- Convert Any date in to Word
- thank for quike replyI want to Convert Any date in to Word like 18/10/1975 ---- Eighteenth of October Ninteen Seventy Five like that i want to use access or excelAccording to above I agree with u With Excel but i want to apply in access how can possible.replyTechrepublic published an...
- Tags: Microsoft Office, Microsoft Word, Word processors, Microsoft Excel, Convert
- Q&A 2004-10-08
- Bridging access and excel macros?
- I have a project in which I need to go back and forth between access and excel over and over (200+ times each time I run the project). Within each application, I run a macro, then go to the other and run a macro, then back to the former... and...
- Tags: davidson.dj@..., macro, Microsoft Access, Microsoft Excel, software
- Q&A 2006-08-03
- Link an Excel database table to an Access database
- Microsoft Office is more than the sum of its parts—you can link an Excel database table to an Access database, integrating your data and adding value. Here's how. You don't have to import an Excel database table into a new Access table in order to work with it...
- Tags: Microsoft Access, Microsoft Excel, Microsoft Office, Databases, Mary Ann Richardson, database, Microsoft Office Suite Access Tips Newsletter, Office Suites, Software, Enterprise Software, Data Management
- Technical articles 2006-06-30
- Access 2007 doesn't export to Excel
- You cannot export a report to an Excel format in Access 2007 This might be a bit of a gotcha if you upgrade a database that exports Access reports to Excel. by Susan Harkins
- Tags: Microsoft Access, Microsoft Excel, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management, Susan Harkins
- Blog posts 2007-10-16
- Use Excel Functions Inside Access
- Excel has many powerful built-in functions for such things as financial and statistical analysis. If one wants to do the same type of analysis in Access, one can do one of the following three things: purchase an off-the-shelf code solution, write their own code for analysis, or use automation to...
- Tags: Microsoft Access, Microsoft Excel, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management
- Book chapters 2005-04-14
- << Previous
- page 1 of 1
- Next >>
