Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 20
Default Import from another excel workbook on open

Can someone tell me how I can make an excel workbook get data into a
specific worksheet from another exisiting workbook, when it is opened?
I really need help with this. I am trying to make some reports easier
to create...Please help with the code!

Regards

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Import from another excel workbook on open


are you importing data from a database or from another excel file? Mor
info will help to write the correct code..

--
dok11
-----------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...fo&userid=1058
View this thread: http://www.excelforum.com/showthread.php?threadid=48232

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 20
Default Import from another excel workbook on open

I am trying to import from another excel file.

Example

I have an existing "Workbook.xls" with SheetA, Sheetb, SheetC....I want
to write a autoexec macro/code, which, when onclick of button, will
import all data from "AnotherWorkbook.xls" SheetC! and paste it into
the SheetC of the first workbook.

Could you please help with this?

Regards

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
Open/Import MS Money OFX file into Excel? Joe User[_2_] Excel Discussion (Misc queries) 3 January 29th 10 11:38 PM
Opening Excel, Book1 opens, remains open with other workbook open DanieB Excel Discussion (Misc queries) 0 September 3rd 09 08:23 AM
Open/Import RTF documents in Excel 2003? soccerkatie Excel Discussion (Misc queries) 1 May 8th 07 06:02 PM
excel 2003 saved file will not open without a blank workbook open Bob Excel Discussion (Misc queries) 4 November 11th 06 04:24 PM
How to Open txt File and Import it to excel Deepak Excel Programming 1 July 7th 05 08:29 AM


All times are GMT +1. The time now is 12:31 PM.

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

About Us

"It's about Microsoft Excel"