Hi Again, I can generate in PDF for that u will require to have Office 2007, but password protection is not possible at present.
Is it OK. Sent on my BlackBerry® from Vodafone -----Original Message----- From: Ankit Agrawal <ankit.agrawal...@gmail.com> Date: Mon, 29 Nov 2010 11:42:43 To: <in.vaib...@gmail.com> Cc: <excel-macros@googlegroups.com> Subject: Re: $$Excel-Macros$$ Salary sending problem Again a recommendation, if it is transfer in to the PDF with password.can it possible. Regards, Ankit On Mon, Nov 29, 2010 at 11:19 AM, Ankit Agrawal <ankit.agrawal...@gmail.com>wrote: > thank you sir, > > Its done dana done. > > > On Sun, Nov 28, 2010 at 11:12 AM, <in.vaib...@gmail.com> wrote: > >> Dear Ankit, >> >> Thanks for your appreciation, Is your query solved. If not then what type >> of error is occurring. >> >> You need to create payslips folder in C drive. And all files are stored in >> that folder. >> >> Pl note folder name is Payslips and not payslip. >> >> The location and name of folder can be also changed by editing cell in red >> colour on sheet Form which contains "C:/payslips". >> >> Please revert. >> >> Sent on my BlackBerry® from Vodafone >> ------------------------------ >> *From: * Ankit Agrawal <ankit.agrawal...@gmail.com> >> *Date: *Sat, 27 Nov 2010 08:37:47 +0530 >> *To: *in.vaib...@googlemail.com<in.vaib...@gmail.com> >> *Cc: *<excel-macros@googlegroups.com> >> *Subject: *Re: $$Excel-Macros$$ Salary sending problem >> >> Namste Vaibhav ji, >> >> *Unbelievable task. *how I tell you what you are? but sir after clicking >> it, it add sheet and creating the file as well. but not saving it and >> occurring a error. so please implement it also. >> >> Thanks & Regards >> Ankit >> ~~~~ >> >> On Fri, Nov 26, 2010 at 8:37 PM, in.vaib...@googlemail.com < >> in.vaib...@gmail.com> wrote: >> >>> Dear Ankit, >>> >>> Check the attached file. It meets all requirements. >>> >>> Create folders name "payslip" in C: >>> >>> //BR >>> >>> VaibhavJ >>> >>> Life is cool... >>> >>> >>> 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-macros@googlegroups.com >>>> *Date: *Tue, 16 Nov 2010 18:53:55 +0530 >>>> *To: *<excel-macros@googlegroups.com> >>>> *ReplyTo: * excel-macros@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
