DBConnect> (Excel -Quirk)

edauthier · Post by **edauthier** » Wed Jun 04, 2008 2:05 pm

I have this issue.. When I run this macro:

vbstart

 Dim mytest
    Set my = CreateObject("excel.application")
    mytest.workbooks.Open "c:\1\1\test.csv"
    mytest.displayalerts = false
    mytest.activeworkbook.SaveAs "c:\1\1\test.xls", -4143
    mytest.displayalerts = true

    mytest.activeworkbook.Close False
Set mytest = Nothing



vbend
vbrun>mytest

I cannot connect using a connection string to the Excel result spreadsheet using DBCONNECT>

I tried a myriad of connection strings and combinations, but continue to fail.

However, if I take the result Excel spreadsheet, open it myself and resave as Excel again. I can connect xls, xlsx, etc.

Any assistance would be appreciated.

Ed

Background:
Vista OS
Office 2007
Macro Scheduler Pro 10.1.15
Macro is intended to run (non-visible)

Post by **Marcus Tettmar** » Wed Jun 04, 2008 4:53 pm

Perhaps you need to quit the Excel instance first:

my.quit
Set my = Nothing

edauthier · Post by **edauthier** » Wed Jun 04, 2008 7:45 pm

Thanks. But it still will not resolve.

I'm stumped and I need to resolve. I may need to try from another PC and Office version.