Sponsored White Papers, Webcasts, and Downloads
Additional Resources
- SAS Macro Programming for Beginners
- Macro programming is generally considered an advanced topic. But, while macros certainly can be challenging, it is also true that the basic concepts are not difficult to learn. This paper is designed for people who know the basics of SAS programming, but know nothing about SAS macro programming. The paper...
- Tags: SAS Institute, Programming, Macro Programming
- White papers 2004-04-14
- How to disable Macros in spread sheet...?
- Hi Guys I want to disable a macro in spread sheet it wont let me do it as when I try to take out the formula from the spread sheet the data also disappears how can I disable the macro but keep the data Please Help!!!!!Disabling macrosOpen the spreadsheet and...
- Tags: PRODUCTIVITY, sanaullahkhalil@..., spread-sheet
- Discussion threads 2007-07-09
- Writing a Macro in Excel 2007
- Would like to edit data below so that the first $ sign is removed from the formula in the first cell, then moving to right it is removed in the 2nd cell, etc. When the end of the first row is reached, the macro should drop down to the next...
- Tags: Microsoft Office, Programming languages, AMS@..., Microsoft Excel 2007, Col, Microsoft Excel
- Discussion threads 2007-10-25
- Excel formatting
- What formula should I use to copy the value and format of reference cell.Example in A1="World" in blueWhat should I type in C1 to copy the value and color?thanks.What version of Excel?2007? 2003? XP?versionis there any different due to the version?unfortunately i'm using 2000 version.There are some significant...
- Tags: Microsoft Office, cell, Microsoft Excel
- Discussion threads 2008-06-12
- SAS Macro Variables and Simple Macro Programs
- SAS macros can be a wonderful extension of the SAS language. This paper introduces SAS users to SAS macro variables and simple macro programs. The SAS programming language has a rich toolbox of features that can offer a lot of power to the user. Using macro variables and macro code...
- Tags: SAS Institute, Macro Variable, SAS Programming Language
- White papers 2005-03-09
- Sum cells in as yet uncreated worksheets
- HelloI am trying to reproduce a formula I found in a locked worksheet. Copying and pasting formula has not worked.Formula is =sum('Day (0):end'!d16).The formula is designed to add values automatically when new sheets are added. If it helps am adding new sheets via a macro.Please help
- Tags: morrison_paul002@...
- Discussion threads 2007-07-24
- SAS Macro Design Patterns
- The qualities which SAS macros share with object-oriented languages account for the power of macro programming. This paper illustrates some examples of specific design patterns which can be partially or fully implemented with the SAS macro language. The material is intermediate to advanced, and assumes knowledge of macros and macro...
- Tags: Design Pattern, SAS Institute
- White papers 2006-02-28
- Macro Recorder ActiveX Control 1.5 (Windows)
- Macro Recorder component provides an easy way to enable your VB, VC++, C#,VB.NET, or other COM environment applications to record and playback mouse clicks, keystrokes and bundle them into a file in order to playback later.
- Tags: Recorder, Environment, Microsoft Windows, CprinGold Software, ActiveX/COM/COM+/DCOM, Software Development, Software/Web Development
- Software downloads 2006-07-26
- Keyboard shortcut to follow formula-generated hyperlinks in excel?
- Hi,I have an excel file with many formula-generated hyperlinks. Instead of clicking them, I would prefer opening them with a keyboard shortcut so I made a macro :Sub followMyLinkActiveCell.Hyperlinks(1).FollowEnd Subwhich works for cells in which the hyperlink was built using ctrl+k, but not when the hyperlink is the result of...
- Tags: Keyboards, keyboard shortcut, keyboard
- Discussion threads 2008-08-06
- code to calculate sum of rows in excel using .net
- ddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddApparently, your question isn't very obvious... but I'll give it a try.If you want to know the VB code of commands in Excel, the following approach always works (for me, though ;-)Create a new macro, record precisely all the steps you wish to actually code in VB, end the recording...
- Tags: Microsoft .NET, programming, r_nair83@...
- Q&A 2006-05-05
- Excel 2007 Macro and VB
- Hi. I just received a project to work on and need lots of help. I need to create a marco using visual basic to be used in excel. I have never used VB so I am not sure what I am doing. We have an excel book with two worksheets...
- Tags: Microsoft development tools, Programming languages, Microsoft Office, boardin4life85@..., Microsoft Excel 2007, Microsoft Visual Basic, Microsoft Excel
- Discussion threads 2007-08-06
- spreadsheet formula help
- I have a spreadsheet with dates and text in it.I would like to count the number of accurrances of one of the words in each column.remembering that some have dates and some have the word I need to count.Sounds like you need to write a macro...If you have cells that...
- Tags: PRODUCTIVITY, cell, spreadsheet
- Discussion threads 2008-07-23
- Quick Macro 6.2 (Windows)
- Quick Macro QMacro is an intelligent software to record, replay and edit keyboard & mouse macros. It has easy-to-use script editing interface for novice users to quickly create macros. It also has programmable macro script editing interface for professional programmers to program macro script in VB Script language. Quick Macro...
- Tags: Macro, Softcows, Mice, Microsoft Windows, Keyboards, Networking, Hardware, Peripherals, Operating Systems, Software
- Software downloads 2007-05-01
- Macro to look values from .csv and place them in Excel-spreadsheet?
- Hi,I'm a newbie what comes to programming, but now I need to get a thing done. I need a macro for Excel, to get data from server generated .csv and place those in some particular cells in a ready customized spreadsheet. How this can be done? I'm not even sure...
- Tags: Microsoft Office, Programming languages, CSV file, Microsoft Excel, cell
- Discussion threads 2008-03-08
- The LATEX3 Programming Language - A Proposed System for TEX Macro Programming
- This paper gives s brief introduction to a new set of programming conventions that have been designed to meet the requirements of implementing large scale TEX macro programming projects such as LATEX. The main features of the system described are classification of the macros (or, in LATEX terminology, commands) into...
- Tags: Programming, Universitat Heidelberg, Development Tools, Software Development, Software/Web Development
- White papers 2008-08-01
- Formula-In-One 5.0 (Mobile)
- Too many formula to remember? Here is a program to help you to organise them in a very systematic way. You can key in the title of the formula, description and sketch and erase the formula. So, next time when you forget about certain formula, just check it up using...
- Tags: Mobile, Formula, Lee Kit Siang, Advertising & Promotion, Marketing
- Software downloads 2006-02-23
- Intermediate and Advanced SAS Macros
- The SAS programming language has a rich toolbox of features that can offer a lot of power to the user. The SAS macro language can be used to generate and alter SAS code. By combining these two languages the user can create some very dynamic systems. Combining these two languages...
- Tags: SAS Institute, SAS Programming Language
- White papers 2006-02-28
- Excel 2003
- Good morning:I have a formula I use in Excel to find the average of three totals, which then puts the results in a seperate column. Is there a way to lock the result so if I delete the formula, the result does not disappear when I delete the formula?Thanking...
- Tags: Microsoft Excel, Microsoft Office
- Q&A 2005-03-28
- Easy Macro Recorder 3.71 (Windows)
- Easy Macro Recorder is a handy utility that automates repetitive and tedious tasks on computers. It records all operation of mouse and keystrokes, and saves them as macros, then Easy Macro Recorder can play back the recorded macros to automate tasks any number of times. There is an easy-to-use macro...
- Tags: Recorder, Macro, GoldSolution, Easy Macro Recorder, Mice, Microsoft Windows, Hardware, Peripherals, Operating Systems, Software
- Software downloads 2008-12-10
- << Previous
- page 1 of 1
- Next >>
What it takes to stay on the edge of innovation
Going green and managing costs during tough economic times
Taking chances with the core brand
Transforming the company and developing new delivery platforms