$$Excel-Macros$$ Excel VBA Code for Zip Password

2012-10-07 Thread Dhartikumar Sahu
Hi Experts Kindly provide me a code for Zip file with password Protection. Q. How to Zip the folders with password in excel vba. -- *Regards,* *Dhartikumar Sahu* Sr.Database Manager - Institutional Equities * **IDBI Capital Markets Services Ltd* 5th Floor, Mafatlal Centre | Nariman Point |

$$Excel-Macros$$ Spark lines in Excel 2003

2012-10-07 Thread amar takale
Hi all, Can Anybody help me for create Sparklines in excel 2003.Any formula or any VBA code.Pls Suggest me Thanks in Advance Amar -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, acc

Re: $$Excel-Macros$$ Re: Macro to create Pivot Table for each sheet in the workbook

2012-10-07 Thread prkhan56
Hello Ashish, When I run call_pivot It gives Run-time Error '9' Subscript out of range and highlights the following line: Call create_pivot_table(Sheets(Sheets("List").Range("a" & i).Value)) Am I doing something wrong? Thanks for your time once again. Rashid On Sunday, October 7, 2012 9:56:2

Re: $$Excel-Macros$$ .xls to .vcf vard format

2012-10-07 Thread V S Rawat gmoz
sorry for rushing, this MS page "Applies to: Outlook 2003", not to excel. Thanks. -- Rawat On 10/7/2012 9:38 PM India Time, _V S Rawat g_ wrote: http://office.microsoft.com/en-us/outlook-help/file-types-you-can-import-or-export-HP005243412.aspx MS page is also saying that we can export/impo

Re: $$Excel-Macros$$ .xls to .vcf vard format

2012-10-07 Thread V S Rawat g
http://office.microsoft.com/en-us/outlook-help/file-types-you-can-import-or-export-HP005243412.aspx MS page is also saying that we can export/import save as .vcf (Virtual card format). But I am not getting that .vcf file type in save as, nor in export. Thanks. -- Rawat On 10/7/2012 9:24 PM I

$$Excel-Macros$$ .xls to .vcf vard format

2012-10-07 Thread V S Rawat g
http://www.ehow.com/how_5708670_convert-excel-mailing-list-vcard.html the page suggests that we can directly save an xls file by choosing vcard format (.vcf) by selecting that in File Type list in save as. But my 2013 doesn't show .vcf - vcard file type at all. What gives. ehow page misguidin

$$Excel-Macros$$ Fwd: Macro for convert to Million

2012-10-07 Thread Aamir Shahzad
waiting for your response plz -- Forwarded message -- From: Aamir Shahzad Date: Fri, Oct 5, 2012 at 10:44 AM Subject: Macro for convert to Million To: excel-macros@googlegroups.com Dear Group, I require the Macro in Add-in form which convert the full amount into the million e.g

Re: $$Excel-Macros$$ Copying table borders from excel sheet .

2012-10-07 Thread ashish koul
are you using VBA On Sun, Oct 7, 2012 at 6:35 PM, Vignesh S R wrote: > Hi all, > > I am trying to send mail from Excel sheet.i have copied the contents > from the excell sheet but i cant able to get the values in Tables in > my mail. > its just copyingthe values as paragaraph and not like table

$$Excel-Macros$$ Copying table borders from excel sheet .

2012-10-07 Thread Vignesh S R
Hi all, I am trying to send mail from Excel sheet.i have copied the contents from the excell sheet but i cant able to get the values in Tables in my mail. its just copyingthe values as paragaraph and not like tables(eg 3 x 3 tables values). Kindly do the needful. -- Vignesh .S.R -- Join offici

Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.

2012-10-07 Thread Indrajit $nai
*@ Krishna, Sir right now it's working fine.thanks a lot for all your kind support throughout. :) it's really make my job simpler.* * * * * *Thanks & Regards,* *Indrajit* * * On Wed, Oct 3, 2012 at 7:27 PM, Indrajit $nai wrote: > *@ Krishna, waiting for your reply. :)* > > > > On Wed,

Re: $$Excel-Macros$$ Macro for Insert and delete worksheets according the list in sheet1

2012-10-07 Thread chhajersandeep
Swapnil I am getting a problem when ever I am trying to change any of the sheet it is saying run time error 9 code out of range. Can it be fixed? Thanks in advance. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: chhajersand...@gmail.com Date: Sun, 7 Oct 20

Re: $$Excel-Macros$$ Macro for Insert and delete worksheets according the list in sheet1

2012-10-07 Thread chhajersandeep
Thanks Swapnil. Its working fine. It will be beneficial to us if you may try to explain the code. :) Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Swapnil Palande Sender: excel-macros@googlegroups.com Date: Sun, 7 Oct 2012 13:25:41 To: Reply-To: exc