A
altitude2k
I'm working on a scheduling system that needs to produce order forms.
These order forms are created from data in the schedule, such as part
no. and quantity. Some of these orders are to be printed which would be
very simple, but some need to be emailled as an Excel file. In that case
I only want the order in that particular Excel file, not the schedule.
How would I go about copying a range of data (e.g. A1:H12) and pasting
it into a completely new Excel file? I want this to be done
automatically without having to open up the new Excel file, it should
just be there.
I would also like to be able to change the name of that file as it is
created using other data. For example, at week 40 I produce an order,
and I want it to automatically call the file Order (Week 40).xls
A lot of the data collected to put into the order would be created from
formulas, so by simply copying wouldn't copy the data required. I would
need to transfer the actual data.
I'm thinking this can only be done through VBA, but if not that would
be better. If anyone could help it would be fantastic.
These order forms are created from data in the schedule, such as part
no. and quantity. Some of these orders are to be printed which would be
very simple, but some need to be emailled as an Excel file. In that case
I only want the order in that particular Excel file, not the schedule.
How would I go about copying a range of data (e.g. A1:H12) and pasting
it into a completely new Excel file? I want this to be done
automatically without having to open up the new Excel file, it should
just be there.
I would also like to be able to change the name of that file as it is
created using other data. For example, at week 40 I produce an order,
and I want it to automatically call the file Order (Week 40).xls
A lot of the data collected to put into the order would be created from
formulas, so by simply copying wouldn't copy the data required. I would
need to transfer the actual data.
I'm thinking this can only be done through VBA, but if not that would
be better. If anyone could help it would be fantastic.