Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Jan 2003
    Location
    Omaha, Nebraska, USA
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formatting (Office 97 - Excel)

    The job cost program where I just started working (small manufacturer) generates reports that are Excel spreadsheets. The information contained in the reports is good, but if the reports could be reformated to add better headings, additonal subtotals, eliminate unnecessary decimal places, etc., the reports would be even more useful. Can someone suggest the best way to apply the customized format I am looking for after I generate the standard report from the job cost program?

  2. #2
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Calgary, Alberta, Canada
    Posts
    818
    Thanks
    6
    Thanked 1 Time in 1 Post

    Re: Formatting (Office 97 - Excel)

    Is it possible to use preformatted Excel templates (.xlt files) as the basis for your standard reports? They would already have the customized formats. etc. that you are looking for. <img src=/S/compute.gif border=0 alt=compute width=40 height=20>

    Ron M <img src=/S/smile.gif border=0 alt=smile width=15 height=15> <img src=/S/smile.gif border=0 alt=smile width=15 height=15> <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  3. #3
    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: Formatting (Office 97 - Excel)

    In addition to Ron's suggestion is to format it after the fact with a macro.

    If the report is formatted essentially the same, You could start with turning on the macro recorder (Tools - macro - record new macro..) and "record the steps you do to reformat the output. That should give you the brunt of the code. You might have to generalize it and and clean it up.

    Here is a good "primer" on using the recorder and here is a primer on VB. You can also post back here with more specifc questions.

    Steve

  4. #4
    Lounger
    Join Date
    Jan 2003
    Location
    Omaha, Nebraska, USA
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formatting (Office 97 - Excel)

    Sorry I didn't get back to this sooner. As you suggest, the best solution is to modify the output from the Job Cost Program, but right now that's not possible. So, following your suggestion, I created a properly formatted template and just do a "paste special - format" from the template to the output from the Job Cost Program. Thanks for the support.

  5. #5
    Lounger
    Join Date
    Jan 2003
    Location
    Omaha, Nebraska, USA
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formatting (Office 97 - Excel)

    Sorry I didn't get back to you sooner. I have used a few macros in the past, but decided that pasting the format from a template onto the output from the Job Cost Program was a simpler solution this time. Thanks for taking the time to help.

Posting Permissions

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