HI, User want to display SAP BI Query in Excel sheet.
what is the procedure, Please send the steps. On Fri, Nov 26, 2010 at 9:29 AM, Ankit Agrawal <ankit.agrawal...@gmail.com>wrote: > Thanks Vaibhav, > > It was great but I discussed with my boss. He said we need salary slip in > separate files so is it possible that as we click on the micro first it > create a new file after it send in e-mail id(and password also be > implements).because employee print out it.and accounts deptt also need the > separate files for every employee in particular months. > > Thanks for your effort and really its mind blowing. > > Thanks & Regards, > Ankit > > On Thu, Nov 25, 2010 at 11:05 PM, <in.vaib...@gmail.com> wrote: > >> Dear Ankit, >> >> I have made one macro this will send payslip as in-line to email. >> >> Follow the instruction sheet. If format and everything is OK then I will >> work for your other requirement. >> >> Pl note that I will able to generate password protected XLS file. >> >> Please revert for help. >> >> Sent on my BlackBerry® from Vodafone >> ------------------------------ >> *From: *Ankit Agrawal <ankit.agrawal...@gmail.com> >> *Sender: *excel-mac...@googlegroups.com >> *Date: *Tue, 16 Nov 2010 18:53:55 +0530 >> *To: *<excel-macros@googlegroups.com> >> *ReplyTo: *excel-mac...@googlegroups.com >> *Subject: *$$Excel-Macros$$ Salary sending problem >> >> Hello Sir, >> >> I have a problem related to mail through excel. basically I have to make >> salary slip. and forward it to the employees. I manage the data into the >> excel and use mail merge in MS word. now the problem is, I have to make >> separate file for each employee and have to send one by one on their e-mail >> id. >> >> Question >> >> 1- Is any way that we can make separately file automatically and send to >> it mail automatically to each employee. >> 2- is any way that every file having its own password and its password >> would be employee DOB or their PAN may be any other key >> >> Here I am sending you sample file so please illustrate it because I am >> new in the excel and don't know much more about other computer software & >> tools >> >> >> Thanks & regards >> Ankit >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> >> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts >> > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- *Thanks & Regards,* *Mohammed Abdulkaleem,* *SAP Netweaver BI-BO/EP Consultant,* *+966551836201*. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
