Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
j j is offline
external usenet poster
 
Posts: 128
Default Exporting to a "specific workbook"

I am exporting records from an existing dbase in CSV format into a Excel
File. There will be 2 completely different exports from this dbase into
excel and I need each export to come into 2 different workbooks within the
Excel file.

Can anyone tell me how I do this?

Thanks, J.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,355
Default Exporting to a "specific workbook"

A question and then maybe someone can help you.

Excel "files" are called Workbooks. Within each workbook, there can be one
to many worksheets. What exactly do you want to do again?
Thanks,
Barb Reinhardt



"J" wrote:

I am exporting records from an existing dbase in CSV format into a Excel
File. There will be 2 completely different exports from this dbase into
excel and I need each export to come into 2 different workbooks within the
Excel file.

Can anyone tell me how I do this?

Thanks, J.

  #3   Report Post  
Posted to microsoft.public.excel.programming
j j is offline
external usenet poster
 
Posts: 128
Default Exporting to a "specific workbook"

Correction,.

I have a workbook called:

"Trust CSV Imports file.xls"

and within this workbook I have 2 worksheets called:

TrustDepositCSVfile
TrustDisbmntCSVfile

Now, the 2 separate record CSV files that I have exported have to go into
the corresponding worksheet within the workbook.

ie: the "Trust Deposit CSV file.csv" must go into the "TrustDepositCSVfile"
worksheet. And the "Trust Disbursement CSV File.csv" must go into the
"TrustDisbmntCSVfile" worksheet.

Does that help?


"Barb Reinhardt" wrote:

A question and then maybe someone can help you.

Excel "files" are called Workbooks. Within each workbook, there can be one
to many worksheets. What exactly do you want to do again?
Thanks,
Barb Reinhardt



"J" wrote:

I am exporting records from an existing dbase in CSV format into a Excel
File. There will be 2 completely different exports from this dbase into
excel and I need each export to come into 2 different workbooks within the
Excel file.

Can anyone tell me how I do this?

Thanks, J.

Reply
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
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
Validation ?:Accepting both Numbers AND specific letters("N","n"," Antonio Excel Discussion (Misc queries) 2 April 22nd 08 05:07 PM
Excel 2003 VBA - "Maximizing" Window & "Calculating" Workbook JingleRock Excel Programming 0 April 25th 06 05:04 AM
Backup to specific folder if workbook names begins with "NSR" or "MAC" GregR Excel Programming 3 May 6th 05 12:24 AM
Adding "New" "Insert" "Delete" into a workbook to change from data 1 to data 2 etc Bob Reynolds[_2_] Excel Programming 0 March 4th 04 08:52 PM


All times are GMT +1. The time now is 05:41 PM.

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"