Cyrus, I think you need to explain a little more. If you are extracting your data from Excel and returning it there post processing, why not simply use an Excel custom function? Why do you specifically need to associate a stand alone application with Excel? If you wish to use excel workbooks as a data source, have a look at using ADO and reading the excel workbook into a recordset. Much simpler that using Excel .
You make an exe program by going to the file menu in VB and selecting the Make option. Matt get2cyrus wrote: >Hi, >I am relativly new to Vb environment > >I am trying to write a VB code to slope correct a data in Excel. >Some questions: > 1> I have written a function in a module that takes the data and >store in the array.I used Cell (x,y) function(that I saw in macros) to >take the data from excel.Does the Cell function work in standalone VB >applications? > > 2>The the data is calculated from the arrays and written back to >excel.But who to make it a standalone Vb application? > >3>Even if I create a standalone application How do I male it an exe >and relate it ti excel? > > Any help is really appreaciated > Cyrus > > > > > > > > > > >'// ======================================================= > Rules : http://ReliableAnswers.com/List/Rules.asp > Home : http://groups.yahoo.com/group/vbHelp/ > ======================================================= > Post : [email protected] > Join : [EMAIL PROTECTED] > Leave : [EMAIL PROTECTED] >'// ======================================================= > >Yahoo! Groups Links > > > > > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/k7folB/TM --------------------------------------------------------------------~-> '// ======================================================= Rules : http://ReliableAnswers.com/List/Rules.asp Home : http://groups.yahoo.com/group/vbHelp/ ======================================================= Post : [email protected] Join : [EMAIL PROTECTED] Leave : [EMAIL PROTECTED] '// ======================================================= Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/vbhelp/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
