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!

Search results for query: *

  1. rtd3776

    Deleting all tables

    Thanks, I'll give it a try. I tell later how it worked.
  2. rtd3776

    Deleting all tables

    I'm working with Access97.
  3. rtd3776

    Delete/Overwrite Excel Spreadsheet

    Ok, now it is working =D All I had to change was this delete and one letter. earlier: wb.worksheets.delete "Results" now: wb.worksheets("Results").Delete Thank you very very much oharab, I really appreciate this.
  4. rtd3776

    Delete/Overwrite Excel Spreadsheet

    Yes, that's correct. Thanks anyway.
  5. rtd3776

    Delete/Overwrite Excel Spreadsheet

    Sorry, maybe I was not clear enough. I tried this earlier: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, "Results", "C:\windows\desktop\project\fiberdb.xls", False, "Results" This adds new sheet to this FiberDB file named as "Results1". I...
  6. rtd3776

    Delete/Overwrite Excel Spreadsheet

    Is it possible to delete/overwrite Excel spreadsheet from Access with vba? And how could that be done? Now when I export table from Access to Excel, it just renames it like this: Results -> Results1.

Part and Inventory Search

Back
Top