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 strongm 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. excelhelp

    Macro to list all Printers on a network

    Hi Someone wrote the macro below to show all printers that a user is connected to. I modified it so that it shows the info in an excel sheet. IT shows the printer name. What would I need to change in the Macro to list all Printers on a particular Windows network, whether I am connected to...
  2. excelhelp

    Import all 'bas' files to a new excel spreadsheet using VBA

    Combo I do have the following: You need VBIDE (Microsoft Visual Basic for Applications Extensibility 5.3) referenced with programmatic 'access to VBProject (xp+) to import found files to excel file. I checked in Tools, references. If possible, please could you amend my code so that I can...
  3. excelhelp

    Import all 'bas' files to a new excel spreadsheet using VBA

    Hi Following on from this thread, is there a way you can Import all 'bas' files in a network folder to a new excel spreadsheet. If you have say 30 modules in one spreadsheet and you want to export them all to another spreadsheet, I have the code below, and I get an error in the line...
  4. excelhelp

    Closing Excel without promt to save (VBA?)

    that did it, thanks!
  5. excelhelp

    Closing Excel without promt to save (VBA?)

    I'm trying to close Excel without having the prompt come up to save changes...the spreadsheet will be used as a template.

Part and Inventory Search

Back
Top