Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Excel import

Hi,
Is it possible to import an excel Sheet from a workbook into another
workbook using VBA.
ie I want to import Sheet3 from Workbook1 into Sheet2 from Workbook2
Thanks
Faby

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10,124
Default Excel import

the macro recorder is your friend. try it

--
Don Guillett
SalesAid Software

"Faby" wrote in message
oups.com...
Hi,
Is it possible to import an excel Sheet from a workbook into another
workbook using VBA.
ie I want to import Sheet3 from Workbook1 into Sheet2 from Workbook2
Thanks
Faby



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Excel import

Hi Don,
Yes indeed:-)
Thanks a lot
Faby

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
import XML data...Is there a size limit on the import? MatthewG Excel Discussion (Misc queries) 0 February 10th 09 05:57 PM
How to Start Excel in Text Import Wizard for data import rlelvis Setting up and Configuration of Excel 0 July 10th 08 08:40 PM
Data Import to Excel Issue with Excel 2007 and Excel 2003 on same Melsh Excel Discussion (Misc queries) 0 August 1st 07 09:32 PM
Import modules EXCEL caused an invalid page fault in EXCEL.EXE Janet Martin Excel Programming 6 August 1st 04 10:25 AM
Import/Export Excel spreadshee data without MS Excel install Peter[_41_] Excel Programming 2 May 28th 04 05:38 PM


All times are GMT +1. The time now is 06:15 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"