| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically Generate a unique file name...
Thanks Tom & Bob. That helps a lot.
Ian ;o) -----Original Message----- I have an excel (XP version) application in use on a network. The app is being run by 50+ different users, and currently they output the final result sheet to a printer on completion. I would like to save some trees and instead of printing the output, I would like to save it to a folder on the network. The problem is, each user prints between 5 & 10 of these sheets per shift. Not all of the users are computer savvy, so in order to avoid everyone saving their files over everyone elses, I would need to write a macro that would save the file automatically to a specific folder. At the same time it would also need to generate a unique file name for each individual user! Does anyone know if this is possible, and can you give me any pointers please? Thanks in advance. Ian . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I generate a unique reference number??? | Excel Discussion (Misc queries) | |||
| automatically generate unique serial numbers for invoices | Excel Worksheet Functions | |||
| How can excel generate every unique pair from a set of numbers? | Excel Worksheet Functions | |||
| How can I generate a unique number each time a form is printed? | Excel Worksheet Functions | |||
| generate unique random numbers | New Users to Excel | |||
Hybrid Mode
