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. 19790203

    how to open a certain directory?

    yes! that's it! thanks!
  2. 19790203

    how to open a certain directory?

    I would like to write a macro which: 1) opens (Open Windows) a specified directory (dir_spec) and then 2) remembers all of the excel files names and then 3) shows these names on the screen. I have (2) and (3) but I don't know how to do part (1). Any ideas to help?
  3. 19790203

    sql query - needs transposing a column

    I'd like to say aditionally that it works without this case statements....
  4. 19790203

    sql query - needs transposing a column

    I tried to put your idea into: StrSqlInvExt = "SELECT INVCEHED.CUSN65, INVCEHED.DTIN65, OEP845L2.TENT45, DELADDS.ONAM45, DELADDS.OAD445, TRIM(DELADDS.OAD545), OEP040L1.SVIA40, INVCEHED.INVN65, INVCEHED.CUSO65, SQP608L1.ICAT08, OEP040L1.CORD40, INVCEHED.ORDN65, min(case when INP40.TLNO40='1'...
  5. 19790203

    progress bar? how?

    But I meant a progress bar in VB for Excel.. I'm trying to find more relevant info in VB Excel help but with no result :/
  6. 19790203

    progress bar? how?

    Let's have a time consuming code: sub code() 'the first SQL query 'the second SQL query end sub How to put a progress bar with status changing after each SQL query is completed?
  7. 19790203

    a message box question

    is it possible that VB displays a message box with some description of activity while doing this activity? for instance, the program is processing huge amount of data and it is consuming huge amount of time and displays a msgbox with info like that: "I am processing the data, please wait!
  8. 19790203

    How to print a file without opening it?

    I mean an excel file (worksheet).
  9. 19790203

    How to print a file without opening it?

    is it possible to print a certain file without opening it?
  10. 19790203

    How to detect default windows printer name in VB?

    simple question: How to detect default windows printer name in VB?
  11. 19790203

    How to close all open files from the path specified?

    I need to have a code which closes all of the files open in the path specified, for example: if the path is: "C:\TEMP\" and contains 3 files, of which 2 are open, the code must check which files are open of these 3 and close them. Waiting for a hint!
  12. 19790203

    How to get the Windows actually logged in username?

    Yes! That's it! Thanks a lot!!!
  13. 19790203

    How to get the Windows actually logged in username?

    I would like to make VB get actually logged in username. For example, if the user is C:\Documents and setting\SOMEBODY\, VB must detect the name SOMEBODY. Please help ;-(

Part and Inventory Search

Back
Top