LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
page setup and print area throughout workbook Jay Excel Discussion (Misc queries) 1 June 15th 09 01:37 PM
Exel 2007: Export to pdf ignores page setup with SP2 installed pa Excel Discussion (Misc queries) 2 May 27th 09 08:04 AM
FORMAT EXCEL WORKBOOK (PAGE SETUP) ALL AT ONCE INSTEAD OF BY PAGE fred Excel Discussion (Misc queries) 1 August 11th 08 04:54 PM
copy page setup from worksheet to another within workbook Fanny Excel Worksheet Functions 2 October 6th 05 02:49 AM
Define Page Setup for whole workbook AliH Excel Programming 1 August 9th 05 05:16 PM


All times are GMT +1. The time now is 03:25 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"