Search results

Thank you

Ok thanks it was not known to me

Sorry but it was vba question not excel. Thank you

Hi @Uncle Gizmo, I have excel file in some folder with loan details and basically i want to zip that file so that it will give specific data row wise for the corresponding loan number in pdf files using vba code. I want to attach that pdf files in mail so i need that pdf files.

Criteria1 is fine but still filter is not working, in column blank is there but what i want date value to be filtered.

Hi, I am facing issues in converting excel rowwise data in pdf format In excel(InvestorData_06/05/20), i have below data and i want to zip loan wise data in pdf format(If 2 loan is there then 2 pdf file should come) with same folder name as excel name. ID Date InvestorId loan 44030...

yes

Its formatted number i am trying below code which is not working (My column name is closing date) strDate="06-Aug-10" With Activesheet .AutoFilterMode= False .Range("E1").autoFilter .Range("E1").AutoFilter Field:=5, Citeria1:=">" & Format(strDate, "dd-mmm-yy") End With

Hi, i want to filter column having date format in "dd-mmm-yy" Column range :=E1 and autofilter field:=5

Thank you so much its working fine :)

Hi @arnelgp Above code is fine but i want to do for the particular column till last row >> Data is given in the below format Customer Collateral Id Status Ramesh 008023378 ; 011123884 ; 0092346-9734; Suresh ;102333345 Mohan # >> I need data in below format Customer Collateral...

Hi @arnelgp, Hope you are doing good i have one doubt i want to split id value present in one row to columnwise data see below for details >> If in excel B2 value is 10001;10002;10003 it should give value column wise in C2, D2,E2 delimited ; i.e, 10001,10002,10003 using vba i am trying to...

Thank you

Hi arnelgp, Thanks a lot :), I have used your code its working fine now

it is not getting executed debug issue

Hi , if i am doing comment on On Error Resume Next i am getting error on below code: wb.Sheets.Add(After:=Sheets("PODetails")).Name= ''Order" Kindly help me

I can't upload but here is my sample code: Code Tags Added by UG Please use Code Tags when posting VBA Code Please feel free to Remove this Comment https://www.access-programmers.co.uk/forums/threads/please-use-code-tags-when-posting-vba-code.240420/ Dim wb As object Dim xlWS As object Dim...

Hi arnelgp, i have done code in access form for commandbutton. In first click i am getting correct result but in second click i am not getting second sheet data. is there i need to set some time or something else?

okay sure

is there i need to start loop again to clean data?