Josh_C Posted January 15, 2012 Report Share Posted January 15, 2012 Hey all, I am running into an issue with Excel. I have a word document that auto populates based on fields in an excel spreadsheet. I have it set to check the excel spreadsheet whenever I open the word document. So that's all fine and good. But here is what I want to do: use this word document/excel sheet as a template setup. So, for every new client I have, I want to create a new folder. In that folder I will already have the same excel sheet and word document set up. But I don't want to have to go in and re-do the linking each time. So is there a way to create a dummy folder that I can use to create each new client folder, and then have the word/excel documents stay linked even when I change the name of the new folder to Client_Name?For example, right now I have Dummy_Client.xls and Dummy_Client.docx. They are in My Documents/Dummy_Folder. But when I copy all the contents of Dummy_Folder into a folder for a new client, like Joe_Smith, I would want to have the Joe_Smith.xls and Joe_Smith.docx files stay linked, so that I can just pop into the excel sheet, change the info I need to change, and have everything go smoothly with the word document.Any thoughts? Am I doing this the hard way? My goal is to just have a few documents in each new client folder auto populated with information like the client's name and a few case details. Quote Facebook | Twitter | Blog |"What we face may look insurmountable. But I learned something from all those years of training and competing. I learned something from all those sets and reps when I didn't think I could lift another ounce of weight. What I learned is that we are always stronger than we know." - Arnold SchwarzeneggerToby: It's going to be hard.Josh: Then we'll do what's hard.- The West Wing"A good lawyer sees trouble coming from around the corner."-Professor Tom Ross Link to comment
RDOwens Posted January 15, 2012 Report Share Posted January 15, 2012 If I am not mistaken, you can copy the directory/folder and everything below it will remain intact. So, copy My Documents/Dummy_Folder to My Documents/John Smith, but keep the files named Dummy_Client.xls and Dummy_Client.docx. That should work. Don't rename the files, only the directory. Quote Turned Leaf | Life List | A Nerd's Eye View Link to comment
JDCoyle Posted January 16, 2012 Report Share Posted January 16, 2012 I agree with RDO, the problem will be when you change the file names, it would be best to set them up with a generic name and let the file structure be your organization.Obviously I don't know what your document is, but is it possible to do everything in Excel and eliminate the need for the Word file? Excel it pretty robust, and with some clever cell merging and organization, you can replicate what would typically be a Word document. Just a suggestion! Quote I must not fear. Fear is the mind-killer. Fear is the little-death that brings total obliteration. I will face my fear. I will permit it to pass over me and through me. And when it has gone past I will turn the inner eye to see its path. Where the fear has gone there will be nothing. Only I will remain. Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.