Thank you fernando for your response. I have started with VBA in Excel but main thing is i am not so good in excel how to create all buttons and combo boxes and so on.
if you say its easy in VBA in Excel, how to bring to cells as a sigle cell in output. for example in one cell there is DN150 and in someother cell there is PN40 and i want the output as DN150-PN40 in the main excel output sheet. is it possible. well untill now i haven gone so deep inside to create such output. and one mroe thing is i wanna make the front end bit beautiful as i have idea in VB doing it so. thank you once more and awaiting for ur response. monu --- In [EMAIL PROTECTED], "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 Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/k7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To reply to this message, go to: http://groups.yahoo.com/group/visualbasic6programming/post?act=reply&messageNum=18568 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/
