ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Import from another excel workbook on open (https://www.excelbanter.com/excel-programming/344778-import-another-excel-workbook-open.html)

[email protected]

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


dok112[_69_]

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


[email protected]

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



All times are GMT +1. The time now is 12:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com