LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 146
Default How to read data from a spreadshet without opening it?

Greetings!

We recieve a file once a week, full of numbers and do-dars. I need to do
things to this report then collate the totals etc and print them on the
actual open excel sheet.

So basically I want to somehow read data from various sheets in another
excel file, without "openining" it (making it load up on the screen). Would
this be accomplished with ADODB? I've only used that with Access.

Any pointers, tips, comments of fish slaps - please point them this way.

Why, thankya.


 
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
Spreadshet Help Aquagirl New Users to Excel 1 February 15th 07 04:10 AM
How do I set an excel macro to run when the spreadshet is opened MH UK Excel Programming 1 February 15th 06 04:17 PM
Why does spreadshet not print out with the actual font size? DeltaPearl Excel Discussion (Misc queries) 1 January 31st 06 05:49 PM
Protect spreadshet, but allow user edit range Souris Excel Programming 2 August 22nd 05 05:26 AM
Opening as Read Only ianripping[_69_] Excel Programming 1 June 19th 04 07:55 PM


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

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"