3 Replies - 2698 Views - Last Post: 16 April 2012 - 05:17 PM Rate Topic: -----

#1 timotz  Icon User is offline

  • New D.I.C Head

Reputation: 4
  • View blog
  • Posts: 34
  • Joined: 01-April 12

excel macros and visual studio 2010

Posted 16 April 2012 - 12:59 AM

i want to learn about making macros in excel. from what i have read in a couple of pages and sites all over the internet, you have to use VBA (Visual Basic for Applications). my problem is i have never used the Visual Basic Editor in Excel and I am too used in using Visual Studio 2010. I am having a difficult time coding because of my unfamiliarity to the environment.

is there anyway to be able to make the macros in Visual Studio 2010's VB.NET and somehow import it to my Excel file? i tried exporting the macro files to Basic Files (*.bas) and trying to add it at my project in vs2010 but that did not help.


thanks in advance :)

Is This A Good Question/Topic? 0
  • +

Replies To: excel macros and visual studio 2010

#2 DimitriV  Icon User is offline

  • They don't think it be like it is, but it do
  • member icon

Reputation: 583
  • View blog
  • Posts: 2,738
  • Joined: 24-July 11

Re: excel macros and visual studio 2010

Posted 16 April 2012 - 01:08 AM

At least in VS 2008 Professional, I've noticed that there is a section for Microsoft Office components and the like (under the New Project window).
Probably not so helpful!

This post has been edited by DimitriV: 16 April 2012 - 01:50 AM

Was This Post Helpful? 0
  • +
  • -

#3 Ionut  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 385
  • View blog
  • Posts: 1,057
  • Joined: 17-July 10

Re: excel macros and visual studio 2010

Posted 16 April 2012 - 05:06 AM

I don't think this is possible. As far as I know, from VS you can only create add-ons for Office Apps.

I sincerely don't see what is so hard with VBE:it's simple, it has intellisense and it behaves like every other editor(which I find it a bit smarter than the one from VS). I think you should spend 1 hour(and it's to much) to adjust to it. If you have questions, post them in VB6 forum and i'll give a hand to learn faster.

This post has been edited by Ionut: 16 April 2012 - 05:07 AM

Was This Post Helpful? 1
  • +
  • -

#4 timotz  Icon User is offline

  • New D.I.C Head

Reputation: 4
  • View blog
  • Posts: 34
  • Joined: 01-April 12

Re: excel macros and visual studio 2010

Posted 16 April 2012 - 05:17 PM

thanks Ionut. i guess i will just have to get used to it. i'll snoop around the vb6 forum :D. i really would have liked it if this was possible on vs 2010 though xD
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1