Search results for query: *

yes! that's it! thanks!

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?

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

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

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 :/

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?

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!

I mean an excel file (worksheet).

is it possible to print a certain file without opening it?

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

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!

Yes! That's it! Thanks a lot!!!

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 ;-(