Search results

hello freinds, i have 2 sheets in one workbook i am applying the autofilter for sheet1 through the value in the cells of sheet2 i am able to reterive the value of 3 fields and my problem lies from here .. here is my my code: Public Sub Tester02A() Dim DataSh As Worksheet Dim CritSh As...

hello freinds !! i ran into a trouble with excel automation , i would appreciate if you can render any thoughts on these: i am trying to highlight colors in excel cells. i have a access table with 4 fields and wanted to pass those values onto excelsheet and if found that match then do the...

hello freinds !! i ran into a trouble with excel automation , i would appreciate if you can render any thoughts on these: i am trying to highlight colors in excel cells. i am opening excel sheet from acess vba and trying to do but unable to here is my code. Dim db As DAO.Database Dim rs As...

hello freinds !!! i am trying to automate excel from access !! i am generating excel sheets from access and i want to format the excel sheets after they are exported from the table in access i tried using the excel automation like get object as well as createobject but none worked for me ...

hello freinds !!! i am trying to automate excel from access !! i am generating excel sheets from access and i want to format the excel sheets after they are exported from the table in access i tried using the excel automation like get object as well as createobject but none worked for me ...