Hi, I too did something similar like what you have at hands. Earlier i had done it with VB 6.0, the next time i did it in VBA i.e. the VB editor which comes with MS-Office. I found that the coding in VBA is much more easier than directly through VB. Also you need not know VBA programming, all you have to do is record macros of all the operations you wish to perform, and embed the code produced by the macros after changing it suitably to suit your requirements. Hope this helps you. Regards, Jerome Nuno Fernando Afonso Oliveira <[EMAIL PROTECTED]> wrote: Why don't you use the VBA in Excel? You could have a form like you want and it's easier to work with the sheets.
-----Original Message----- From: monoo_76 [mailto:[EMAIL PROTECTED] Sent: quarta-feira, 29 de Dezembro de 2004 8:05 To: [EMAIL PROTECTED] Subject: [Visual Basic 6 programming] Visualbasic with Excel background Hallo everybody, i have a question. I want to create a VB frontend and excel as back end where in excel file there will be lot of data. in VB frontend i want to give the main data which has to search in those excel sheets and give a report in new excel sheet which will be printed for the latter use. hope u have understood the situation. is it possible to do such programming. for example: excel file with lot of sheets inside with number of data. now i wanna give the basic data in frontend VB tool and then after clicking the final command button these excel sheets have to be checked through and give the data in new excel form as my report where in some of the cells in excel reports should be filled manually latter on. thank you for reading my question and awating for ur prcious answer. monu Yahoo! Groups Links Yahoo! Groups SponsorADVERTISEMENT --------------------------------- Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/visualbasic6programming/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. Yahoo! India Matrimony: Find your life partneronline. [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/k7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To reply to this message, go to: http://groups.yahoo.com/group/visualbasic6programming/post?act=reply&messageNum=18569 Please do not reply to this message via email. More information here: http://help.yahoo.com/help/us/groups/messages/messages-23.html <*> To visit your group on the web, go to: http://groups.yahoo.com/group/visualbasic6programming/ <*> 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/
