By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,404 Members | 2,145 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,404 IT Pros & Developers. It's quick & easy.

Transferspreadsheet function help

P: 25
Hello!

I have a shared database that will be used by about 50 different people or so. one of the functionalities that i have to have is to produce an output into excel file. if i use the same excel file to produce output to, the file gets locked by one user and of course the other users are not going to be able to export the data. is there a way to produce output into a "new excel file" without specifying the file name. Besides, i have to have predifined pivot table in that output file.
If anyone has any suggestions how to accomplish that please advise, it'll be greatly appreciated.
Thanks.
Jul 23 '07 #1
Share this Question
Share on Google+
1 Reply


JConsulting
Expert 100+
P: 603
Hello!

I have a shared database that will be used by about 50 different people or so. one of the functionalities that i have to have is to produce an output into excel file. if i use the same excel file to produce output to, the file gets locked by one user and of course the other users are not going to be able to export the data. is there a way to produce output into a "new excel file" without specifying the file name. Besides, i have to have predifined pivot table in that output file.
If anyone has any suggestions how to accomplish that please advise, it'll be greatly appreciated.
Thanks.
create a macro inside your predefined spreadsheet that, when opened, creates a copy using the user's LoginID in the name of the file, or something similar. Then the user is not ever holding the "Template" workbook open.
J
Aug 1 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.