Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically generate a unique file name via macro...
You're on the right track, but I think the problem is in the use of the
Format function. You *may* have to encapsulate the call to Format in a Str() function in your concatenation. But why use Format at all? I just use something like Trim(Date) in similar circumstances and it works fine. I'd also include the userID in that string, or create individual user folders for the output. Your customers will probably prefer the latter, based on my own experience along these lines. Randall Arnold "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? I tried something like this: Thisworkbook.SaveAs "X:\SpecialFolder\ & "ABC" & _ format(now,"yyyymmdd_hhmm") & ".xls" but I get syntax errors or expected end of statement errors. Thanks in advance. Ian. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically generate a unique file name via macro...
Thanks Randall... I'm pretty new to this, I was given the
idea from a previous post. I'm grateful for your reply, but what you said didn't mean a great deal to me, could you break it down into something a novice like me could understand please? Thanks Ian -----Original Message----- You're on the right track, but I think the problem is in the use of the Format function. You *may* have to encapsulate the call to Format in a Str() function in your concatenation. But why use Format at all? I just use something like Trim(Date) in similar circumstances and it works fine. I'd also include the userID in that string, or create individual user folders for the output. Your customers will probably prefer the latter, based on my own experience along these lines. Randall Arnold "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? I tried something like this: Thisworkbook.SaveAs "X:\SpecialFolder\ & "ABC" & _ format(now,"yyyymmdd_hhmm") & ".xls" but I get syntax errors or expected end of statement errors. Thanks in advance. Ian. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatically generate unique serial numbers for invoices | Excel Worksheet Functions | |||
How to generate a text file from Excel using a macro or script? | Excel Discussion (Misc queries) | |||
How to generate a text file from Excel using a macro or script? | Excel Discussion (Misc queries) | |||
Macro to generate a file from another | Excel Worksheet Functions | |||
Automatically Generate a unique file name... | Excel Programming |