Recent content by mikeprof99

Hi Namliam, Thank you for your response. I know that what you are referring it to but I am stuck just this portion of the code. With objSht ' .Range(.Cells(1, 1), .Cells(conMAX_ROWS, _ ' intLastCol)).ClearContents .Range(.Cells(1, 1), _...

Ok...I have been able to call the file and worksheet I need to use but I am not able to figure out via code the cell location and its associated values to populate the report. Any help you can provide will be truly appreciated. Sub sPopulateReport() Dim strFilter As String Dim...

Hi Thanks for your reply. My apologies about the code, I copied from Notepad and it did not indent here. Still learning the tricks here. How do I reference it to the table the cell location and tell the code to take the corresponding values and copy it to the destination cell in Excel?

Ok guys this is what I need to do. I have an Access application that does lot of processing and enhrichment of some data. At the end of my process it will derive some values that I will need to transfer it to Excel Template I have designed. Below is the layout of Excel File UniqueID...