I tried using the same idea. The problem with what you are trying to do is that temporary tables are only linked to one mysql link. And just by pconnecting you don't guarantee that you get the same link when you call pconnect in the second page.
So far, I haven't found any way around this...
once you have the excel object
just add this line of code to remove the "Save" messages
fixing xlbo's code:
Function myExcel() as Excel.Application
Dim x as object
On error goto New
Set x = GetObject(,"Excel.Application")
goto AlreadyOpen
New:
Set x =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.