Search:

Type: Posts; User: GUEdiver246

Search: Search took 1.72 seconds.

  1. Re: VBScipt to print multiple excel files with multiple tabs within a folder

    This one prints to a certain printer by setting it as default during the running of the script.

    strComputer = "."
    Set objWMIService = GetObject("winmgmts:{impersonationLevel=impersonate}!\" &...
  2. Re: VBScipt to print multiple excel files with multiple tabs within a folder

    It isn't the prettiest coding, but it works. This one prints to the default printer.

    set shApp = CreateObject("shell.application")
    currentPath =...
  3. Re: VBScript to print multiple excel files with multiple tabs within a folder

    A new twist. I just learned I also need to either set a specific network printer or give the option of printer. Some people have windows managing their default printer and some people do not. I need...
  4. Re: VBScript to print multiple excel files with multiple tabs within a folder

    Thank you jdc2000 for your suggestion. I have updated my file to this as a temporary fix. A more permanent fix will be needed based on the fact that the folder is located on a shared network drive....
  5. VBScipt to print multiple excel files with multiple tabs within a folder

    I currently have a working file to print a single excel file with multiple tabs. I need to modify it to print multiple excel files within the single folder. My folder contains 5 excel files with...
Results 1 to 5 of 5



Click Here to Expand Forum to Full Width