CREATING AN EXCEL SPREADSHEET IN VISUAL BASIC FORM

Sorry Experts,
I'm new to the exchange and this is my first time posting. I just posted the same questions and then awarded points! So, I'm trying again.

I am attempting to create an excel spreadsheet on a vb form using a button. I believe I have the references and import statements correct. However, it throws the error "System.Security.Permissions.SecurityPermission" when it attempts to execute the first line of code "Dim ex As New Excel.Application".

I have tried to correct it by reading other posts but am lost when it comes to assemblies and changing them.

Any help would be appreciated.

Thanks

reeseer74Asked: 2009-07-15

Who is Participating?

Experts Exchange Solution brought to you by

Enjoy your complimentary solution view.

Get every solution instantly with Premium. Start your 7-day free trial.

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

LVL 1

xemophoraCommented: 2009-07-15

What is your code thus far? I am relatively new to this as well but actually got a start doing almost this same thing a little while back.

Are you trying to generate a form from scratch or are you modifying a template for you have already created in excel? I am attaching code I used on my most recent project doing just this (based off a template though). Please let me know if you have any specific needs (naming convention for generated forms, .xls files from scratch with formating, etc.

Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet
 
xlApp = CType(CreateObject("Excel.Application"), Excel.Application)
 
xlBook = CType(xlApp.Workbooks.Open("Ifyouhaveatemplate.xls"), Microsoft.Office.Interop.Excel.Workbook)
 
xlSheet = CType(xlBook.Worksheets(1), Excel.Worksheet)

Open in new window

reeseer74Author Commented: 2009-07-15

What references and import statements did you use/

reeseer74Author Commented: 2009-07-15

I tryed code very similar to yours earlier and got the same error.

reeseer74Author Commented: 2009-07-15

I attempting to create an instance of excel on a vb project form using a push button.

reeseer74Author Commented: 2009-07-15

Tried you code and got this:

Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

LVL 1

xemophoraCommented: 2009-07-15

Alright just to clarify, the direction I initially assumed was for creating an instance of excel From your vb form. Is this correct or do you want the contents to be displayed On the form in an area?

If the first is true, after creating your form you will apply this code to the push button. Upon pressing the button excel will open with (if specified) your sheet. Any controls for saving the spreadsheet or modifications to this spreadsheet (ie taking data from your text boxes and adding to cells) will be done in this area as well. Hope this helps get things rolling.

LVL 1

xemophoraCommented: 2009-07-15

try this...
http://social.msdn.microsoft.com/Forums/en-US/csharpgeneral/thread/e91bfb53-5148-4122-894c-56dc0d0b6a29/

reeseer74Author Commented: 2009-07-16

Hey Xemophora,
Your link worked! Many thanks!

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial

LVL 1

xemophoraCommented: 2009-07-16

awesome glad it worked for you. best of luck on the rest of the project :)