Recent content by tiwariprakash

DJkarl, Thanks for your prompt reply. I still couldn't get my head around it. I have tried like : 1. In ACCESS Private Sub Command18_Click() ................................ Call RunMe .......................... End sub 2. In ACCESS (couldn't call Excel Function from Access) Function...

Hi I tried to use the code but I got an error "Run-time error '1004': The macro 'Module1' cannot be found." As you suggested, I have closed the workbooks, set excel application to nothing and quit. Private Sub Command12_Click() Dim XLApp As Object Set XLApp = CreateObject("Excel.Application")...