View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
KUMPFfrog KUMPFfrog is offline
external usenet poster
 
Posts: 38
Default 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.