1 out of 1 rated this helpful - Rate this topic

Excel 2007 Technical Articles

Office 2007

Read technical articles about developing for Microsoft Office Excel 2007.

This section of the MSDN library provides technical articles to help you get started developing solutions that take advantage of Microsoft Office Excel 2007.

Office 2007 logo

Documentation

We publish new content continuously. To view content relating to Microsoft Office Excel 2007, click the items to the left, in the table of contents.

  • Excel 2007 Developer Reference. Developer or API references are extended documentation sets. They usually provide application programming interface (API) documentation, sample code, and other supporting information.

  • Excel 2007 XLL SDK Documentation. Software development kits (SDKs) or references are extended documentation sets. They usually provide application programming interface (API) documentation, sample code, and other supporting information.

  • Excel 2007 Technical Articles. Technical articles are 10-35 pages in length and provide detailed technical information and code examples. They may serve any number of purposes: getting started, providing best practices, describing a solution, discussing the use of a given object or method in depth, and so on.

  • Excel 2007 Visual How Tos. Visual how-to articles are 2-15 pages in length and combine some of the best elements of blogs, video, and technical articles by providing a brief overview, a code sample, and a how-to video. You can read the overview, review the code snippet, view the video, and explore the additional resources.

  • Excel 2007 Book Excerpts. Book excerpts are online excerpts of published books. Each chapter often focuses on one key solution or set of tasks as well as providing you a free, in depth look at a book. Links are included for viewing the entire book online or purchasing the book.

Learn

Getting Started

Learn about the new features in Office 2007.

 

Twitter

Facebook

RSS

Stay Connected

Keep connected with the latest happenings with Microsoft Office.

Chat

Provide Feedback

Provide feedback about Office 2007.

Provide feedback about the documentation for Office 2007.

  • Classic View. Use the Click to Rate and Give Feedback link at the top of the topic in the MSDN Library. This delivers your feedback directly to the documentation team.

  • Lightweight View. Click the feedback icon. This delivers your feedback directly to the documentation team.

  • Scriptfree View. Click the Feedback link at the top of the topic in the MSDN Library. This enables you to provide feedback about the scriptfree view to a forum.

Did you find this helpful?
(1500 characters remaining)
Community Content Add
Annotations FAQ
Macro script concatenating Column A(i) and ColumnB(i)
Hi Everyone, $0$0 $0 $0I am in need of a Macro script concatenating Column(i) of A combining with the values from column B till the last valued cell and loops till the last cell with value of A. I need the output to be displayed in Column C.$0 $0$0 $0 $0Example:$0 $0$0 $0 $0A1: Avalue1B1: Bvalue1$0 $0A2: Bvalue2B2: Bvalue2$0 $0B3: Bvalue3$0 $0B4: Bvalue4$0 $0B5: Bvalue5$0 $0$0 $0 $0The output should be:$0 $0$0 $0 $0C1: Avalue1Bvalue1$0 $0C2: Avalue1Bvalue2$0 $0C3: Avalue1Bvalue3$0 $0C4: Avalue1Bvalue4$0 $0C5: Avalue1Bvalue5$0 $0 $0C6: Avalue2Bvalue1$0 $0C7: Avalue2Bvalue2$0 $0C8: Avalue2Bvalue3$0 $0C9: Avalue2Bvalue4$0 $0C10: Avalue2Bvalue5$0 $0 $0$0 $0 $0Sort of there's a counter variable that counts for Column A1 till the last and counter variable for Column B1 till the last, and the cell A(counter) combines with column value B(counter). Sorry my english is not good but pretty much the example I illustrated defines what my goal is. I'm new in learning in customizing VBA scripts in Excel but I'm having problem learning the syntax. It confuses me.$0 $0$0 $0 $0Hope to receive a reply from a person which can show me the light LOL$0 $0$0 $0 $0Best regards,$0 $0Kuratz$0