Recent content by ColleenLee

I changed my code to: Sub Workbook_Open() Workbooks.Open "C:\myreportfile.xls" Application.Run "macro.xls!Report_1" End Sub Then it's work!!!! hahaha so happy with that but anyone knows the reason? Now i have to work on how to tell the macro to pick the correct sub to...

I changed my code into: Sub Workbook_Open() Dim XL As Object Set XL = CreateObject("Excel.Application") XL.Workbooks.Open "C:\myreportfile.xls" Application.Run "macro.xls!Report_1" It works if i open the macro.xls directly. It will automatically generate all the report...

First of all, thx for your help. I read the website and i tried. But i still cannot solve the problem. This is my code: Sub Workbook_Open() Dim XL As Object Set XL = CreateObject("Excel.Application") XL.Workbooks.Open "C:\myreportfile.xls" Windows("macro.xls").Activate...

Hi everyone, currently i am modifying a access program. My program is to store some data (of course :P ) and to export the table into excel file for report generation. There are lots of them and now i want to automate this procedure by just clicking one button. This is what i have to do before...