Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Excel Templates

Nov 1, 2005 4:33PM PST

Not sure if Im pointing in the correct direction or not, but Ill try.

We have an online appointment system at work that allows truckers to make appointments to bring loads to us.

This is a new appointment system. We have to option of printing it out the way they want it printed, which isnt very useful to us. OR we have a chance to send it to Excel.

My question is, can I use a prebuilt template to send this information to.
The way we are viewing it now, theres no grid lines or anything and we have to fill in quite a bit of information, so we have to sit down and draw gridlines every day.

Im faurly comfortable with Excel but havent used the template function at all.

Would building a template retain cell formatting etc?

Thanks

Nick

Discussion is locked

- Collapse -
Re: Excel templates
Nov 2, 2005 3:08AM PST

Nick,

Sorry, but I never heard of Excel templates, and I don't have time at the moment to google it. So some general remarks.

1. If this workbook is made by an third-party application program, read the manual of that application to see what it can and what it can't do with respect to formatting the spreadsheet it produces. That doesn't seem to be an Excel problem.

2. If you're doing the same everyday record (or write if necessary) a macro, put it in your personal (or workgroup) macro spreadsheet and use it to format the unformatted spreadsheet from the application program exactly as you like/need it.

Hope this helps.


Kees

- Collapse -
macros
Nov 2, 2005 5:25AM PST

I know what macros do. Now just to learn how to build them

- Collapse -
Re: macro's
Nov 2, 2005 6:45AM PST

The easiest way is just to record them. Then you only have to activate the macro to do exactly the same.

It's definitely more difficult if you want to do not exactly the same, but a little bit different depending on the contents of the current version of the spreadsheet. Then you will have to program in Visual Basic.

To try without programming:
- copy the contents of the unformatted spreadsheet to the clipboard (Edit>Copy)
- open a empty formatted spreadsheet
- Edit>Paste Special>Values
- File>Save As
That leaves the formatting intact.

Kees

Kees