Recent content by sam_01

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...

helo bob, i am trying to color few cells based on the some conditions which i already mentioned in the previous post.. to be mre clear once again... i am trying to compare fields from access to excel and and i made a make table query in access for comparision of them and the result of that i...

excel automation I have tried the code which u said but its not doing anything, its reading the values from the access table but not comparing the values in the excel sheet to be mre clear on this , i am sending the excel sheet as an attachment i have described by intentions or what i exactly...

excel automation thanks for such a prompt response. i have tried no. of options and now i am able to read the value of the first fields .. i tried to debug the values and able to read the value of the particular cell but its not performing any operations and exiting the application like...

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 ...