Print

Print
Michael - couple of questions:
1) Are you looking to actually make your python script an executable for users who will "NOT" have python installed on their machine?
2) Do you want some sort of GUI that goes with the program?
3) I would assume Windows, but figured I should at least ask?

Knowing that, we might be able to give you some better advice.  As a shot in the dark, you might read up on this link (it's Windows specific and I'm on a Mac, so I haven't tried it):

Technically speaking, you can do GUI stuff with Python, so you don't necessarily need something like VBA.

David


On Friday, November 7, 2014 8:42 AM, "Lachance, Michael - APHIS" <[log in to unmask]> wrote:


Good morning everyone,
 
With guidance from this listserv I have successfully created a Python script that reads through a delimited text file and outputs a summary of the data stored in this file. I would like the non-technical folks in my office to be able to use this script to get the summary of the data. What is the best way to make this happen? We are going to be running multiple files through the script one at a time and recording the outputs in a spreadsheet.
 
I would like them to be able to run the script by selecting the relevant text file with an “Open” or “Browse” option and then be able to click a button to execute the script with the selected file as the input. The output would then come back as text in a window. I was thinking this could easily be done via VBA but upon researching this it appears it may be more complicated than I thought.
 
Any suggestions or feedback?
 
Kind regards,
 
Michael Lachance
Plant Protection Technician
ALB Eradication Program USDA APHIS
151 West Boylston Drive
Worcester, MA 01606
508.852.8050 (o)
508.414.5673 (c)
The USDA is an equal opportunity provider and employer.
Federal Relay Service (Voice/TTY/ASCII/Spanish) 1-800-877-8339
 
This electronic message contains information generated by the USDA solely for the intended recipients. Any unauthorized interception of this message or the use or disclosure of the information it contains may violate the law and subject the violator to civil or criminal penalties. If you believe you have received this message in error, please notify the sender and delete the email immediately.
 
------------------------------------------------------------------------- This list (NEARC-L) is an unmoderated discussion list for all NEARC Users.
If you no longer wish to receive e-mail from this list, you can remove yourself by going to http://listserv.uconn.edu/nearc-l.html.


------------------------------------------------------------------------- This list (NEARC-L) is an unmoderated discussion list for all NEARC Users.

If you no longer wish to receive e-mail from this list, you can remove yourself by going to http://listserv.uconn.edu/nearc-l.html.