Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Export data to new workbook, maintaining formating and page setup
Not very familiar with VBA, more of a functions and formula girl.
Have a template set up for my invoicing needs, but once filled out - i would like to hit a button and have the main invoice form exported to a new workbook saved with a file name that was created on the form. It would also need to keep page setup settings as well as the format the data is in (like i sent it to pdf, but really a new xls). I would also like to be able to import previous invoice information from exsisting invoice worksheets, (info like address and previous invoiced amounts). Am I making any sense? I know Access would be a lot better for this, but I know nothing there. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
page setup and print area throughout workbook | Excel Discussion (Misc queries) | |||
Exel 2007: Export to pdf ignores page setup with SP2 installed | Excel Discussion (Misc queries) | |||
FORMAT EXCEL WORKBOOK (PAGE SETUP) ALL AT ONCE INSTEAD OF BY PAGE | Excel Discussion (Misc queries) | |||
copy page setup from worksheet to another within workbook | Excel Worksheet Functions | |||
Define Page Setup for whole workbook | Excel Programming |