Search results

Hi , Anybody help to retrieve pivot data table to mail body in outlook -> I want to create pivot table from data and covert pivot range table data to mail body and delete blank column from pivot table

How to open outlook with subject line "Report-02/16" and read table data in body of mail or export table in excel using VBA

ok thanks

okay fine is there any possibility to add one more criteria in my given code

yes its different, i dont want to hide i just want to filter with given conditions

@arnelgp, please help me on this. Thank you

can anybody help me on this : I Want to filter column A with name like , "ESAF", "E S A F" OR any name like "FBI *" i am trying to do below code: strName="FBI" Activesheet.Range("$A$1:$CT" & lastRow).Autofilter Field:=1, Criteria1:="=*" & strName & "*", Operator:=xlOr, Criteria2:="ESAF" i...

using VBA only

yes that is the issue for two criteria it is working fine

Can anybody suggest what to do?

Its done thank you

I want to filter the column value which should not contain string starting with "Bank", "HDFC", "SBI" trying to do below code but not getting required results Activesheet.Range("$A$1:$CT & lastRow").AutoFilter Field:=13, Criteria1:=Array("<>Bank*", "<>HDFC*","<>SBI*")

Ok i will try that ...thank you

Getting update , not update pop up despite of keeping "Application.screemupdating= False" in the beginning of code. Is there something else i need to keep?

No is there any other approach for that ?

getting error in handling DLL , what all refrences need to keep?

First i am creating pdf files from excel format sheet and it is getting save in one folder ....... 1)If pdf file in folder is more than 30 then it should merge all pdf files into one pdf file can anybody suggest how to do this using vba ? I did below Code: Sub CreatePdf_form() Dim str AS...

Hi Yes i have tried , but getting some error like file not found something thank you

I am trying below code, but confused how it will count one by one Hi @arnelgp, kindly look into this 1) I want to zip different different folder with same category , if file is in pdf and excel with "dbk: string in it, then it should zip both file together 2)If hdfc found then it should zip with...

Given code is for same files , i want for different files name in same folder