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 Rhinorhino 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 dskelley

  1. dskelley

    VBScript to Export Excel Worksheet to Access Table

    I should clarify that importing is currently already being done using a macro as a temporary workaround, and linking is not an option for reasons I won't get into. I specifically need an external, independent VBScript that will transfer a worksheet called Data from the Excel spreadsheet to a...
  2. dskelley

    VBScript to Export Excel Worksheet to Access Table

    Thanks for the info. I should clarify that importing is currently already being done using a macro as a temporary workaround, and linking is not an option for reasons I won't get into. I specifically need an external, independent VBScript that will transfer a worksheet called Data from the Excel...
  3. dskelley

    VBScript to Export Excel Worksheet to Access Table

    Thanks for the info. I should clarify that importing is currently already being done using a macro as a temporary workaround, and linking is not an option for reasons I won't get into. I specifically need an external, independent VBScript that will transfer a worksheet called Data from the Excel...
  4. dskelley

    VBScript to Export Excel Worksheet to Access Table

    Not familiar with it. Is that a 3rd party app? THX.
  5. dskelley

    VBScript to Export Excel Worksheet to Access Table

    Already doing that. I'm looking for a way to automate it without having to open up either application. Thanks for the input, though.
  6. dskelley

    VBScript to Export Excel Worksheet to Access Table

    I'm looking for a VBScript that exports a specified Excel worksheet, clearing and replacing a table as is in an Access database. I'm not well versed in this, and am hoping someone can provide a template that all I have to is plug file names into (the files will sit local to each other in the...
  7. dskelley

    VBScript to Export Excel Worksheet to Access Table

    I'm looking for a VBScript that exports a specified Excel worksheet, clearing and replacing a table as is in an Access database. I'm not well versed in this, and am hoping someone can provide a template that all I have to is plug file names into (the files will sit local to each other in the...
  8. dskelley

    VBScript to Export Excel Worksheet to Access Table

    I'm looking for a VBScript that exports a specified Excel worksheet, clearing and replacing a table as is (column headings will be identical) in an Access database. I'm not well versed in VBScript, and am hoping someone can provide a template that all I have to is plug file names into (the files...
  9. dskelley

    Export Excel Worksheet to Replace Access Table

    Bump. Really hoping someone has a general or template VBscript that can be run independtly from the applications so that all I have to do is plug in file names. Thanks to anyone who can help.
  10. dskelley

    Export Excel Worksheet to Replace Access Table

    I'm looking for a VBScript that takes every record in a specified Excel worksheet called Service Site Matrix.xls, replacing existing data in a table called Data in an Access database called sitematrix.mdb, essentially taking the entire worksheet and replacing the table in the database as is.
  11. dskelley

    Limit subfolder recursion?

    On a simliar note, I'm using the below script to simply do a first-level folder report to a text file. I need help to use this same report but to export it to an existing Excel spreadsheet in specifically designated cells. Any assistance would be appreciated. 'Report on number of first-level...
  12. dskelley

    Folder count to Excel script

    I'm looking for a script that counts the number of immediate first-level folders for a list of UNC paths provided in an input file, and then outputs to an Excel a designated spreadsheet somewhere on a network resource. What I need to accomplish is a scheduled report that exports the number of...
  13. dskelley

    Word 2002 Hangs When Closing

    I have a home network with a Windows 2000 DHCP/DNS/File server and 4 XP workstations running through a Netgear router. When I close Word 2002 from a file opened from the Windows 2000 server, it hangs for several minutes before closing, and leaves behind a .tmp file that cannot be deleted until I...
See more

Part and Inventory Search

Back
Top