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!

  • Congratulations gkittelson 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: *

  • Users: smitho2005
  • Order by date
  1. smitho2005

    Environ Function

    Hi all I have looked at the code above as i am trying to find the OS. I want for find what operating system users are on , I have made a test app and when i run on my XP machine using Environ("OS") i get Windows_NT and the 2000 is the same. Can you use this to find the os ? Thanks C
  2. smitho2005

    How do you open a non-excel file using a VBA marco

    ok that is great , just a side question in access you can using macros , setwarnings to yay or nay. can you do this in vb6 so when you open docs you dont get asked with q's like this could be unsafe ?
  3. smitho2005

    How do you open a non-excel file using a VBA marco

    HLink = "t:\EAD\ead.mdb /x Memberprint" CreateObject("WScript.Shell").Run Chr(34) & HLink & Chr(34) when using the code above i get a error of Method 'Run' of object 'Iwshshell3' failed
  4. smitho2005

    How do you open a non-excel file using a VBA marco

    Hi every one trying to use the aforementioned code. [code] HLink = "t:\EAD\ead.mdb" CreateObject("WScript.Shell").Run Chr(34) & HLink & Chr(34) [code] this works fine but i want to run a marco called "memberprint" using this can i do this using this code ?
  5. smitho2005

    Batch file & Shell

    found the answer on the shell command just add a forward slash and then a x and the macro name. e.g retval = Shell("c:\program files\microsoft office\office\msaccess.exe t:\EAD\ead.mdb /x runtables")
  6. smitho2005

    Batch file & Shell

    Hi wondering if you could help on the shell command I currently use this command to open the database [code] retval = Shell("c:\program files\microsoft office\office\msaccess.exe t:\EAD\ead.mdb") [\code] I would like to run a macro on the shell line if possible. I do not want to use the...

Part and Inventory Search

Back
Top