Tip: for results matching all words only, use "AND" between your search terms.
|11. Serial Number to Barcode|
Excel Serial Number to Barcode is a component with an Excel add-in that converts serial numbers within cells to a variety of industry standard barcodes with and range of formatting and customization options. Excel Serial Number to Barcode (SmartCodeComponent) allows creating barcodes within Office and other Windows programs by using OLE object linking and embedding. The serial number to barcode component is also packaged as an Excel add-in to provide barcode generation functionality with automation within Excel documents...
Apply top or bottom bearer bars with specified thickness and quiet zones.
12. Spreadsheet to ASP/ASP.NET Converter
The Spreadsheet to ASP/ASP.NET converter can quickly create ASP and ASP.NET pages using Excel. The Excel spreadsheet can d be designed and created including all necessary calculations. Then the Spreadsheet to ASP converter generates the ASP page or the ASPX page. The Spreadsheet to ASP/ASP...An Excel spreadsheet can be designed and created including all necessary calculations for the Spreadsheet to ASP converter to generate the ASP page or the ASPX page...Back-end integration can also be added such as for saving and restoring the values to a database...Key features of the Spreadsheet to ASP/ASP...The web page looks just like the Excel spreadsheet.
13. Import Multiple Files to Access
Import Multiple Files to Access for Excel is an Access add-in allowing to import multiple Excel files into Access with detailed transformation and mapping rules. Import Multiple Files to Access for Excel (Excel Import Assistant) allows the import of Excel files from multiple sources and locations into an Access database. The solution is an Access add-in that allows to import multiple files to Access with specification of mapping and transformation rules in a single process...
Specify worksheet ranges to restrict import.
14. Convert To Flat File
Convert to Flat File for Excel converts irregular structured Excel data reports into a clean flat data table format for analysis and use. Convert to Flat File for Excel has a a powerful set of tools aimed at converting a complex Excel report structure into a flat data table. This solution is particularly useful when structured data is required to be used for further analysis in Excel or in other applications such as databases...
Extract data from text reports imported into Excel.
15. Content Emailing
Excel Content Emailing provides a suite of tools to manage the emailing of Excel content to recipients as attachments with features to split, merge and convert content based on specified rules. Excel Content Emailing (GoGoMail) is a standalone application designed to streamline the management and process for email Excel content to multiple recipients. The Excel content emailing allows the establishment of rules for defining content from within a single file or combining content from multiple files and send as attachments to specified email addresses or lists.
16. Convert Values
Convert Values for Excel is an Excel add-in to convert data values between a wide range of different formats and data types in order to facilitate data analysis and save time. Convert Values for Excel can convert cell values to different formats and data types quickly and easily. The Excel add-in provides quick access to convert selected data into consistent formats to speed up analytical tasks and data management. Key features of Convert Values for Excel include:
Convert Excel dates to weekday, month, quarter, year, day of year, hour, minute or second.
17. Enhanced VBA Editor
The Enhanced VBA Editor for Excel is a useful development tool for VBA programmers that want to build fast and robust VBA code. The Enhanced VBA Editor for Excel is a useful development tool for VBA programmers that want to build fast and robust VBA code...Easy to use and diagram-tree navigation helps to manage objects and elements.
Procedure Builder is designed to generate text from the Sub or Function.
Collections Builder helps to include a new collection class into the user's project based on the existing class.
18. Change Formula References
The Excel Add-in to Change Formula References can very quickly change thousands of formula references to a specified criterion. The change to formula references can be applied to selected cells only, the entire active sheet or the entire workbook. The Excel Add-in to Change Formula References can very quickly change thousands of formula references to a specified criterion. The change to formula references can be applied at three different levels:
Selected cells only
Entire Active Sheet
The Excel Add-in to Change Formula References also includes a Sheet Index Creator.
19. Marketing Metrics Balanced Scorecard
Marketing Balanced Scorecard for Excel allows to use pre-defined metrics to measure the performance of Marketing department. Marketing Balanced Scorecard for Excel allows to use pre-defined metrics to measure the performance of Marketing department of the company, providing top managers with clear view over Marketing activities, their current and planned performance. Also, the Marketing Metrics balanced scorecard provides necessary indicators to benchmark marketing performance of your company against competitors.
20. Professional Reporting Templates
Excel Professional Dashboard Reporting Templates allow managers to step back from the details and see the key trends and relationships that drive their companies. Professional Dashboard Reporting Templates for Excel allow managers to step back from the details and see the key trends and relationships that drive their companies. The reporting techniques include workbook templates and tutorials to create professional Excel reports for management and presentation purposes...
The reports can adapt quickly to managers' changing information needs.
|11. Backup and Recovery|
Excel templates, add-ins and spreadsheet solutions to backup and recover lost or corrupt files and passwords. These Excel solutions are designed for performing backups and restoring lost or corrupt workbooks and passwords in order to minimize the risk of losing valuable information contained within inaccessible Excel spreadsheets.
12. Market Data Access
Excel templates, add-ins and spreadsheet solutions for accessing, retrieving and utilizing financial market data. These Excel solutions provide the ability to download or link to live feeds of financial market data and can be used for obtaining input data for technical analysis and financial market trading applications.
13. Human Resources
Excel templates, add-ins and spreadsheet solutions for the management of human resources and employees. These Excel solutions are designed to assist in management of human resource related activities and can be applied to common human resources tasks such as personnel management, employee scheduling and communication.
14. Project Management
Excel templates, add-ins and spreadsheet solutions for project management, project planning and task scheduling. These Excel solutions focus on aspects of project management including task timing, planning and resource allocation which can be utilized to plan and monitor project performance to facilitate project related decision making.
15. Business Planning
Excel templates, add-ins and spreadsheet solutions for creating and optimizing business plans and proposals.
These Excel solutions are designed to facilitate the business planning process by providing methods for projecting financial data and can be used to quickly produce reports required for business case proposals.
16. Sales and Marketing
Excel templates, add-ins and spreadsheet solutions for sales analysis and formulating marketing strategy plans. These Excel solutions focus on revenue opportunity analysis, product profitability and marketing strategy and can be applied to formulate optimized marketing plans to increase sales revenue and overall bottom line profitability.
17. Forecasting and Prediction
Excel templates, add-ins and spreadsheet solutions for forecasting time series projections and prediction. These Excel solutions are designed to assist in maximizing the predictive strength of projecting and forecasting activities and can be used to provide a solid basis for justifying forecasts of time series data used in business case and investment proposals.
18. Operations and Management
Excel templates, add-ins and spreadsheet solutions for business operations and management activities. These Excel solutions are designed to be applied to specific work flows and logistics in business operating environments. The Excel templates and solutions assist with the streamlining of business operations and facilitate management decision making for operating activities.
19. Excel Productivity
Excel templates, add-ins and spreadsheet solutions for enhancing productivity and efficiency in working with Excel. These Excel solutions are designed to enhance the efficiency of working with Excel and optimize the performance of Excel spreadsheet applications.
20. Portfolio Management
Excel templates, add-ins and spreadsheet solutions to assist in the management of portfolios of financial investment assets.
These Excel solutions focus on asset allocation for portfolios of financial investments and can be applied to optimize trading and investment strategies in financial markets.
|Excel Help Forum Topics:|
|11. How to launch Windows Explorer rooted to LAN folder|
I need to assign a macro to a button to launch Windows Explorer in single pane view (files names only, no folder tree) rooted to a specific network folder. Using the hyper-link option to the LAN folder works, but it opens up Explorer with the folder pane showing.
12. Similar to
Hi, I think my problem is similar to the above listed one, but I'm pretty new to VB and so didn't make too much sense of the replies - apologies if this is going back over old ground... First off I tried the VB Wait command, but that seems to pause everything, including the =blp formulas.
13. Dynamically pass ticker symbol to web queries
You can automate downloading the list of ticker codes from the first URL using the following code...WebSelectionType = xlSpecifiedTables . WebFormatting = xlWebFormattingNone .
14. Automating a web query login to download data
I have a funamental earnings and valuation model spreadsheet that downloads stock data from a number of different websites via certain add-ins. One of the sites that it gets information from is investors...Go to "Data" on the Menu bar, then "Import External Data" 2.
15. Pass cell value variables to web query via VBA
We queries can be run using VBA code by looping through the cell values that are required to extract the data. I suggest that you look at the post here which gives an example of doing this and includes a downloadable workbook to use, test and modify.
16. How to make this into a macro
Was able to use this to locate row, very good, but I then need to copy datato that row. HYPERLINK("#"&ADDRESS(MATCH(A1,B1:B5,0),2),"Go to row") tried many combinations of this to create a macro without sucess
17. Unable to make Excel Macro to work in OpenOffice
Hey I am unable make the Macro created in Excel to work with OpenOffice...asp to convert the code but even that failed... I just wanted to list all the files in a Folder (including Subfolders) in to the calc sheet.
18. Web query post
Please see the forum post on using web queries via VBA here.
19. Welcome to the Excel help forums
It's nice to have you and feel free to post your Excel related business issues and/or apply your expertise to help others.
20. Unable to Convert Worksheets Data To a FlatFiles
I am trying to convert all the work sheet data to a flat file...Please help to resolve this issue. Iam getting "Export failed" when i call this ExportToFile() function using a menu...WriteLine(tempCell...Write(tempCell...RefersToRange...RefersToRange...RefersToRange tempRange.
|Excel Help Forum Categories:|
|11. Charting and Performing Technical Analysis|
Find Excel help and share Excel solutions relating to time series technical analysis and charting. The Excel help forum for charting and performing technical analysis focuses on problems and solutions for analyzing and predicting time series financial data trends through trend analysis and charting techniques.
12. Automating Data Analysis Tasks
Find Excel help and share Excel solutions relating to the automation of data analysis tasks in Excel. The Excel help forum for automating data analysis tasks focuses on problems and solutions for saving time when analyzing data or building analytical models by applying appropriate formulas and utilizing visual basic for applications (VBA) code.
13. Building Market Trading Systems
Find Excel help and share Excel solutions relating to the building of trading systems for financial markets. The Excel help forum for building market trading systems focuses on problems and solutions for integrating Excel applications with financial market data sources as well as the construction of trading systems with Buy and Sell signals.
|Download Write To Web Reference
|For iTunes & iOS Device