Recent content by lyuzhongkun

Thanks, I found my mistake. I just doesn't know why I add a module named msgbox in the worksheet. How stupid am I and Thanks for your help!

I assure the msgbox is the only error. I change the format to msgbox "some message" but still failed. And what I found is that When I use msgbox in other modules in the same workbook, they all failed and pump up same compile error. But when I change to other workbooks, the error message is gone...

I want to wrote a vb to get data from SQL Server to Excel. But when I run this, I get an compile error msg "Expected variable or procedure, not module" and direct to the MsgBox line. I not sure why this happen. Sub SQLDatabase() Dim rs As ADODB.Recordset ' hold data Dim cnSQL As...