Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by DeannaF829

  1. DeannaF829

    Cannot access 'file.xls'

    i need to update a record in a csv file. I was using Excel so I could update the record using SQL and then saving the updated excel file as a csv
  2. DeannaF829

    Cannot access 'file.xls'

    I've given up on the Excel thing. I'm going to have to learn how to use FileSystemObject and do the update to a CSV file without using Excel at all. There are too many issues with MDAC, DAO, ActiveX, Excel settings, Windows settings, dll files, etc... Thanks for trying though. Have a good...
  3. DeannaF829

    Cannot access 'file.xls'

    I commented out the Dim objExcel and I got a Variable not defined error. I'm also not creating a spreadsheet from scratch. It already exists which I believe is the problem. Something somewhere has it and won't let it go so I can write to it. I tried sharing the spreadsheet too.
  4. DeannaF829

    Cannot access 'file.xls'

    I am. I have the same Set objWorkbook line with both paths. I comment out the one I'm not using and uncomment the one I am using. Actually, it turns out the 'cannot access' error usually comes up here: Set objExcel = CreateObject("Excel.Application") I've also tried Set objWorksheet =...
  5. DeannaF829

    Cannot access 'file.xls'

    I'm trying to open the excel file and update it. After it updates, I save it with the same name only as a CSV file.
  6. DeannaF829

    Cannot access 'file.xls'

    I'm trying to update an excel spreadsheet with the following code: Private Sub ExportToFile(objRecord As Recordset, Optional Delimiter As String = ",") Const xlCSV = 6 Dim EXPORT_FILE_PATH1 As String Dim objExcel Dim objWorkbook Dim objWorksheet EXPORT_FILE_PATH1 = "C:\Daily_Data.csv" Set...
  7. DeannaF829

    Invalid bracketing of name but not a column heading or file name

    Thanks!
  8. DeannaF829

    Invalid bracketing of name but not a column heading or file name

    I've been looking in the forums, but not finding exactly what my problem is. I have an SQL Insert that is giving me the error [Microsoft][ODBC Excel Driver] Invalid bracketing of name '[8.28]'. Here is my query: strSQL = "Insert Into " & Chr(34) & "Verify_Not_Shipped$" & Chr(34) & " (" strSQL...
See more

Part and Inventory Search

Back
Top