Results 1 to 11 of 11
  1. #1
    3 Star Lounger
    Join Date
    May 2003
    Location
    Nottinghamshire, England
    Posts
    211
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Financial Statements (Excel 2002 )

    Hello Everyone:

    Can anyone give me any advice on setting up for a Financial statements. Are there any easy ways to setup a financial statement in Excel?

    If someone could post a sample this would be greatly appreciated.
    ================================================== ====================================
    Expense File:

    Not too long ago I saved a file for a client, but when he opened the file; Excel indicated that it was a "read only," can anyone advise me on what I did wrong. The CD was a blank RW.

    Regards,

    Dillon65

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Financial Statements (Excel 2002 )

    Let the client copy the file to hard disk (or to a network drive), then right-click it in Windows Explorer, and clear the Read Only check box. Files copied from a CD are Read Only by default.

  3. #3
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Financial Statements (Excel 2002 )

    As far as the file being read only...

    Have the user open the file from the source (i.e. CD), then click File|Save As...
    The <font color=blue>Save As</font color=blue> dialog box will probably open the the My Documents folder and a " suggested filename " will be offered. You can click OK or change the name to something more meaningful. Your newly saved file should be open for editing.

    A Financial Statement template may be available on the Microsoft Excel website. If I come across anything, I'll post a link. The reality is that there are many formats for a FS and finding one that exactly meets your needs will be tough to do. Still, you can change things around to suit you.
    - Ricky

  4. #4
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Financial Statements (Excel 2002 )

    Financial Statement Templates?

    Check this out...
    - Ricky

  5. #5
    3 Star Lounger
    Join Date
    May 2003
    Location
    Nottinghamshire, England
    Posts
    211
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Financial Statements (Excel 2002 )

    Hello HansV, Ricky:

    Gentlemen, thank you so much for the instructions to for resolving the "Read only file," Ricky thank you for the template information, I greatly appreciate you directing me to the financial template area.

    I will go ahead and download the template, and create a different file name and then save it as a template on my hard drive. Would this procedure corrupt the file?

    Best regards,

    dillon

  6. #6
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Financial Statements (Excel 2002 )

    You seem very concerned about corrupting a file. May I suggest that while you are making changes (or editing) a file, that you save it each day with a different filename. In fact, when you first open a "good" file, go ahead and click Save As... immediately and give it a different name. This way, your original is still intact and all the changes are being made to your new file. Example:

    2004 04 02 Fin Stmt.xls
    2004 04 03 Fin Stmt.xls
    2004 04 04 Fin Stmt.xls

    You will build up a set of files that will easily allow you to revert back to a working copy when you encounter problems (corruption). You can begin to delete the older files once you're satisfied everythings okay.

    The template you download from Microsoft can be stored on your harddrive in it's original condition for archival or backup purposes. Just label it as such.
    - Ricky

  7. #7
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    Birmingham, West Midlands, United Kingdom
    Posts
    219
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Financial Statements (Excel 2002 )

    A problem (to me, anyway) with 'preserving' a known good copy of a file by saving as filename2 is that if it has any macros in it referring to the original file, the code doesn't automatically reflect the changed filename, so they don't work.
    My practice, for what it's worth, is to copy the original into a zip, then do whatever ambitious and foolhardy changes on the original. Then, if it works, replace the original in the zip: else, extract the original from the zip and try again.

    Concerning files copied from a cd as acquiring 'read only' attribute, is there a simple way of changing this attribute to 'archive' on a whole bunch at once? One by one is very tedious...

  8. #8
    3 Star Lounger
    Join Date
    May 2003
    Location
    Nottinghamshire, England
    Posts
    211
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Financial Statements (Excel 2002 )

    Hello Ricky, jrose:

    Ricky, your observation is correct, I don't want to have this particular file get corrupted, and thanks to your brilliant response, I am hoping that I can avoid such a problem, thank for your suggestion.

    Jrose, I don't have a zip reader, unless you are referring to Winzip; if your are referring to the latter, then I will give it a try if, I happen to run into trouble.

    cheers mate!

  9. #9
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Financial Statements (Excel 2002 )

    <hr>Concerning files copied from a cd as acquiring 'read only' attribute, is there a simple way of changing this attribute to 'archive' on a whole bunch at once?<hr>
    I'm thinking maybe... Seems like you could use the attrib command from the Dos prompt. Perhaps using wildcards ***, you would be able to set the attribs on multiple files at once. As I am uncertain of this, I'd suggest you wait for another lounger to make this more clear or suggest an alternative.

    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    - Ricky

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Financial Statements (Excel 2002 )

    You can select a number of files in Windows Explorer, then select File | Properties, and clear the Read Only check box. In Windows XP, click Advanced to tick the Archive check box, not sure about other Windows versions.

    Ricky is right, you can also use the DOS command attrib: in a command prompt window, type

    attrib -r +a c:excel*.*

    (where c:excel is the path) and press enter. You could also put this line in a batch file (i.e. a text file with extension .bat); a batch file can be executed by opening it from Windows Explorer.

  11. #11
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Financial Statements (Excel 2002 )

    <hr>A problem (to me, anyway) with 'preserving' a known good copy of a file by saving as filename2 is that if it has any macros in it referring to the original file, the code doesn't automatically reflect the changed filename, so they don't work.<hr>

    It is best not to explicitly use workbook, worksheet names or ranges in code for this reason.

    You can use:
    <pre>ActiveWorkbook</pre>

    to refer to the "activebook". You can use:
    <pre>ThisWorkbook</pre>

    to refer specifically to the workbook which contains the code

    Another way is to hold the object name (book, sheet, range) in a variable, and define it once in code. Then only refer to it via the variable. If you ever have to change the object you can use some technique at run time to "get it" (if posssible) or at worst, you have only 1 place to manually change the name.

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •