Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically Generate a unique file name...
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically Generate a unique file name...
some ideas
GetTempName Method of the FileSystemObject (Reference Microsoft Scripting Runtime - scrrun.dll) http://msdn.microsoft.com/library/en...temobject.asp? http://support.microsoft.com/?id=kb;en-us;Q195763 http://www.mvps.org/vbnet/code/filea...mpfilename.htm I sometimes use Format() to create file names that change by the second. It has the advantage, if it matters, that the file names are numbered sequentially by date and time: fn = "MyFile_" & Format(Now(),"yyyymmddhhmmss") & ".ext" You could also make creative use of Rnd(). Bob Kilmer "Ian L" wrote in 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically Generate a unique file name...
Thisworkbook.SaveAs "X:\SpecialFolder\ & "ABC" & _
format(now,"yyyymmdd_hhmm") & ".xls" Regards, Tom Ogilvy Ian L wrote in 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 |
#4
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 |