Search results for query: *

Finally the only combination I found that worked is oExcel.Quit RELEASE oExcel After browsing around here it appears what works for one, won't work for another. Go figure?

I almost forgot! One last thing in my code" oExcel.Workbooks.CLOSE oExcel.Quit() release oExcel release all like o* I've tried all three but I can never seem to release this workbook from processes. Any futher attempt to access reports file in use. Is there a 5th command I don't know about?

Good points. What looked simple on the outset was not as much. Thanks again.

Yep, it appears the $ AND the trim both are the problem. Mike, the dollar sign appears nowhere except in the table seedname. I think you are right about the driver. All I have to do is remove that and trim it and I think it will work. Thanks Olaf and Mike.

No, these are the sheet name. lcXLS = GetFile('XLS') lcConn = "Driver={Microsoft Excel Driver (*.xls)};"+; "DriverId=790;Dbq="+m.lcXLS+; ";DefaultDir="+JustPath(m.lcXLS)+";" lnHandle = SQLStringConnect(m.lcConn) SQLTables(m.lnHandle,"", "SheetNames") Scan lcTableName =...

Since the workbook can change frequently what I did was import all the sheet names into a table. A browse window pops up showing the sheets available, 'this company$' 'that company$' 'any company$' After user selects the sheet I tried to throw the that exact data into a variable which should...

I have a program that theoretically should select a chosen excel sheet from a workbook to import into a table. I have no problem creating a table from which to choose the tab. The data looks exactly like this including the quotes; 'ABC Homes$' After selected it is passed to a varible with...

My one question left right now is why I can't set default or change directory to: set default c:\DOCUMENTS AND SETTINGS\WILYNCH\VISUAL PROJECTS\ The simple things sometimes lose focus.

Thanks so much! That's great and works just as I wanted. Learn something new everyday.... Will

I have searched the forum diligently and am having problems location a code that will perform a simple task. I have a table already set up. The structure never changes. I want to navigate to a folder, select a csv file and import it into the zapped table. The .csv file structure is always the...