| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exporting and Importing Data into a preexisting Workbook
Hey all, Big fan of this forum. I've been trying to figure out what th simplest way to export data from 2 specific sheets and manage to sav the formulas and comments to like a .xls file then be able to reimpor them. the worksheets are called "Data" and "Loss Analysis Data" I' like to be able to save those 2 sheets to a file (we work with man different accounts) then import those files. So far everything I'v tried has screwed up the dates or formulas. Anyone have any ideas -- rtheisse ----------------------------------------------------------------------- rtheissen's Profile: http://www.excelforum.com/member.php...fo&userid=3616 View this thread: http://www.excelforum.com/showthread.php?threadid=55947 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Exporting and Importing Data into a preexisting Workbook
If you are using xl2003, what about saving as XML?
You could then open it and copy the information over to your new workbook. -- Regards, Tom Ogilvy "rtheissen" wrote: Hey all, Big fan of this forum. I've been trying to figure out what the simplest way to export data from 2 specific sheets and manage to save the formulas and comments to like a .xls file then be able to reimport them. the worksheets are called "Data" and "Loss Analysis Data" I'd like to be able to save those 2 sheets to a file (we work with many different accounts) then import those files. So far everything I've tried has screwed up the dates or formulas. Anyone have any ideas? -- rtheissen ------------------------------------------------------------------------ rtheissen's Profile: http://www.excelforum.com/member.php...o&userid=36164 View this thread: http://www.excelforum.com/showthread...hreadid=559475 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Exporting and Importing Data into a preexisting Workbook
Actually I'm being forced to use '97 (work related) would it still be possible to save to xml and open - copy and paste? and can I copy and paste cells with defined names / formulas, thanks for your help -Ryan -- rtheissen ------------------------------------------------------------------------ rtheissen's Profile: http://www.excelforum.com/member.php...o&userid=36164 View this thread: http://www.excelforum.com/showthread...hreadid=559475 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing and Exporting Data | Excel Discussion (Misc queries) | |||
| Exporting/Importing Data | Excel Discussion (Misc queries) | |||
| Importing/Exporting Blocks of Data | Excel Programming | |||
| Importing and Exporting Data to Web | Excel Discussion (Misc queries) | |||
| Data Importing and Exporting | Excel Programming | |||
Linear Mode
