VSTO 개발 자료를 한개씩 모아보겠습니다. 다람쥐처럼.. 오로롱~


 VSTO를 처음 접하신다면.. 아래의 링크부터 살펴보는 것으로 시작하세요..

     http://msdn.microsoft.com/ko-kr/office/hh128771.aspx

 

▲ VBA의 사용자 정의 함수를 VSTO에서 불러오는 방법과

     반대로 VSTO에서 정의한 함수를 VBA에서 불러와 사용하는 방법에 대한 강좌 동영상입니다.

     http://timebird.egloos.com/4269867

    (updated 2013.08.05. 시작. 

         위 사이트보다는 아래 링크에서 "Call VSTO Code from VBA" 동영상을 보는게 더 좋을 듯.. 

         http://msdn.microsoft.com/en-US/office/fp123583

     updated 2013.08.05 끝)

    ( 위 링크는 다음의 링크를 참조하다 발견햇다.. http://byung.egloos.com/5539511 )

  - 다음의 MSDN Magazine도 살펴보자.. 같은 내용이다.

     http://msdn.microsoft.com/ko-kr/magazine/cc163373.aspx

  - VSTO 개발에 대해서 잘 설명된 MSDN 페이지..

     http://msdn.microsoft.com/en-US/office/hh128771


▲ VSTO 관련 북마크 모음.. 

http://jimecox.wordpress.com/2011/01/27/vsto-resources-samples-and-videos/

 

 

▲ Keyboard Hooking 관련 링크 모음..

아래 링크는 C#으로 작성됐구..

http://blogs.msdn.com/b/vsod/archive/2010/04/08/using-shortcut-keys-to-call-a-function-in-an-office-add-in.aspx

아래 링크는 VB.NET으로 작성됐음..
http://go4answers.webhost4life.com/Example/keyboard-shortcuts-custom-menu-items-43586.aspx

 

===================================================================================

 

아래 내용은 제가 동영상을 보고 정리한 내용이구요..

나중에 동영상을 볼 수 없게 되거나.. 빠르게 스캔하고 싶을때를 위한 노트지요.

From . http://www.abyul.com/zbxe/114318

 

코드를 타이핑 하기 귀찮으면 아래 텍스트 파일을 참고하세염..

다운받기 : myVBALibrary_20130122-1.txt

 

 

1) VSTO에서 VBA에 정의된 함수를 사용하는 방법은 간단합니다.

     Me.Application.Run("VBA함수명", 사용될 인수)

abyulTools_0000385-1.jpg

 

2) VBA에서 VSTO에 정의된 함수를 불러오는 것은..

 

    일단.. 엑셀을 열고.. 사용자 정의함수를 하나 만들어서 xlsm으로 저장합니다.

 

    Visual Studio에서는 만들어둔 xlsm파일을 베이스로 VSTO 프로젝트를 생성하면 되겠죠..

    우선 VSTO에서 xlsm의 속성 창에서 "EnableVbaCallers" 속성을 True로 변경해준다.

 

abyulTools_0000386-2.jpg

 

      위의 속성을 설정을 하고.. Build를 하면..

      엑셀 파일의 Thisworkbook에 아래와 같은 Property Get 구문이 자동으로 생성된 것을 확인할 수 있다.

 

 abyulTools_0000387-1.jpg

 

      Property가 설정되었으니.. 설정된 Proterty를 이용해서 사용자 정의 함수를 작성하면 되겠다.

     핵심은 아래 코드다.

** 아 이때 중요한 것은.. 처음 만들때 참조했던 xlsm파일이 아니라.. 프로젝트 폴더에 복사된 xlsm 파일을 편집해야한다는 거다..

      Thisworkbook.CallVSTOAssembly.VSTO에서정의한함수명(필요한 인수들)

 

abyulTools_0000388-1.jpg

 

 

 


VSTO관련 유용한 링크들.. 죄다 영어.. ㅋㅋ


From. http://social.msdn.microsoft.com/Forums/vstudio/en-US/852a9e55-192d-475f-b0e7-02f08962c1eb/please-read-next-vsto-resource-list


Product-specific

Visual Studio Tools for Office Developer Portal on MSDN
http://msdn.microsoft.com/en-us/office/aa905533.aspx
 
VSTO 2010 Online Documentation (MSDN Library)
http://msdn.microsoft.com/en-us/library/vstudio/d2tx7z6d(v=vs.100).aspx

VSTO 2012 Online Documentation (MSDN Library)
http://msdn.microsoft.com/en-us/library/vstudio/d2tx7z6d(v=vs.110).aspx

MSDN Subscriptions Site
VSTO 2008 is included in the Professional and higher subscription types. This page shows a comparison of these subscriptions.
http://msdn.microsoft.com/en-us/subscriptions/aa718657.aspx

Further Information

Here are some other resources you can tap for further information on VSTO

VSTO Blogs


Technical Articles and Books

What’s New in VSTO
http://msdn.microsoft.com/en-us/library/86bkz018.aspx

VSTO Deployment Scenario to Avoid Code Decompilation
http://social.msdn.microsoft.com/Forums/vstudio/en-US/81be6cc4-11a7-402a-97cf-8124405510e4/vsto-deployment-scenario-to-avoid-code-decompilation

Audio Programspodcasts Availabl for VSTO
http://social.msdn.microsoft.com/Forums/vstudio/en-US/42660ae6-1326-4f2d-816b-fd5359b32f98/audio-programspodcasts-available-for-vsto


VSTO Deployment
http://social.msdn.microsoft.com/Forums/vstudio/en-US/1666d2b0-a4d0-41e8-ad86-5eab3542de1e/deploying-office-solutions-to-end-user-computers

VSTO for Mere Mortals  This book is written by former VSTO team members Kathleen McGrath and Paul Stubbs. It targets VB.NET as the language and VSTO 2005, including Add-ins created using SE. Good introductory book for people transitioning from VBA. The basics still apply for later versions of VSTO.
http://www.awprofessional.com/bookstore/product.asp?isbn=0321426711&rl=1

Visual Studio Tools for Office 2007: VSTO for Excel, Word and Outlook (March 2009) This is a book written by former VSTO team members Eric Carter and Eric Lippert. It is a re-write of the 2005 edition, targeting VSTO 2008 and Office 2007. It covers advanced topics in Office development and VSTO technology, as well as the basics of using VSTO. Code samples and discussion revolve around using C#, but the basic discussion also apply to VB.NET. Basics still apply to later versions of VSTO and Office. Publisher: Addison-Wesley; ISBN 978-0-321-53321-0.

Reporting Bugs or Submitting Feature Requests

Please report any bugs you find on the MSDN Product Feedback Center. To ensure that you’re not posting a duplicate bug, be sure to use the Search option on the main page to determine whether your bug has already been discovered and posted.
 
You may also submit feature requests here. You can help us track these requests by using this title format: "FEATURE REQUEST: <one-line request description>". You can then provide further details in the Problem Statement section of the suggestion form.

Visual Studio and .NET Framework Feedback
http://connect.microsoft.com/VisualStudio/feedback


== 구분선 ==================================================================================================



From. http://social.msdn.microsoft.com/Forums/vstudio/en-US/5f13a675-2972-4983-a6dd-9e32b459d422/vsto-2008-2005-2003-resource-list


Further Information

Here are some other resources you can tap for further information on VSTO 2005.

 

·         VSTO Blogs

Technical Articles and Books

What’s New in VSTO 2005

http://msdn2.microsoft.com/en-us/library/86bkz018(vs.80).aspx

 

VSTO Deployment

These whitepapers are interrelated, so be sure to review both of them.

·         Deploying Visual Studio 2005 Tools for Office Solutions Using Windows Installer (Part 1) 
http://msdn2.microsoft.com/en-us/library/aa537173(office.11).aspx

 

·         Deploying Visual Studio 2005 Tools for Office Solutions Using Windows Installer: Walkthroughs (Part 2)
http://msdn2.microsoft.com/en-us/library/aa537179(office.11).aspx

 

 

VSTO 2005 technical articles on MSDN

http://msdn.microsoft.com/en-us/library/bb726432(office.11).aspx

VSTO 2003 technical articles on MSDN

http://msdn.microsoft.com/en-us/library/bb726426(office.11).aspx

 

VSTO for Mere Mortals  This book is written by former VSTO team member Kathleen McGrath.

http://www.awprofessional.com/bookstore/product.asp?isbn=0321426711&rl=1

 

Visual Studio Tools for Office: Using Visual Basic 2005 with Excel, Word, Outlook, and InfoPath  This is a book written by VSTO team member Eric Carter and former team member Eric Lippert.

http://www.amazon.com/Visual-Studio-Tools-Office-Development/dp/0321411757

 

Visual Studio Tools for Office: Using C# with Excel, Word, Outlook, and InfoPath  This is a book written by VSTO team member Eric Carter and former team member Eric Lippert.

http://www.amazon.com/gp/product/0321334884/

 

 











profile