Selecting Specific Excel File At Print Time

Legacy Poster

• October 14, 2015 20:08

Hi-

 

I wrote an Excel VBA macro which asks the users a set of 3 questions.  Once those questions have been answered, the macro generates an .xls file to a shared drive.  I expect that this shared drive will have multiple files, all structured in the same manner.

 

 Is it possible for the user to select which particular excel file they wish to use at print time?  I have learned how to set up database connections, but it seems the idea is to hardcode a single database file and select all the records or a subset of them.  My desire is to have the user select their particular Excel file at runtime.

 

Thanks

 

Joe

 

 

0

• 

  Ian Cummings

  Moderator

  ★ BarTender Hero ★

  • October 16, 2015 10:24

  Here is an alternate suggestion.  Modify your VBS to generate a CSV file instead and make use of the Commander middleware application to monitor for the creation of these files in a nominated folder, and when detected to automatically produce a print job using the record contents of the file.  See the below white paper about Commander for more details:

   

  http://www.seagullscientific.com/label-software/whitepapers/overview-of-commander-new-201406.pdf

  0

Please sign in to leave a comment.