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: 3
Default Working with Excel via Visual Studio 2008

Hello, I have been programming for some time in VB & VBA, but this is
myfirst attempt to program in Visual Studio 2008 for Excel.
Basically,I am looking for a good place to start for my application.

I have a customer that uses a custom software package (not mine)
thatkicks out around 12 reports as Excel 2003 documents. The
customerthen imports data from specific cell ranges in these 12
documents to a"Master" Excel file. Within this Master file, he does
calculationsand generates graphs & charts. As a final step, he
exports the graphsgenerated to PowerPoint presentations. I realize
this is convulted,but I wanted to explain the existing scenario, as
this is what I amtrying to automate.

What would be my best method for creating a VB application that
pulleddata from specific locations (cell ranges in the 12 report
documents)and put them into the Master Excel file? I know that VS2008
has sometemplates and support for Excel, but I am having a difficult
timegetting started.

I have attempted to do some research myself, but most of the examplesI
have found relate to manipulating data in a singe Excel document(not
across multiple files). I would greatly appreciate anysuggestions or
references to sites where I could get more information.

Thank you!
 
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
Is Visual Basic the same as Visual Studio 2008? Mike Stewart Excel Worksheet Functions 5 January 11th 09 04:58 PM
Working with Excel via Visual Studio 2008 Kirk[_6_] Excel Programming 2 September 25th 08 01:30 PM
working with excel from visual studio 2005 express bigdaddy3 Excel Programming 0 November 3rd 05 03:14 PM
changing the visual basic in office 2003 to visual studio net bigdaddy3 Excel Discussion (Misc queries) 1 September 13th 05 10:57 AM
Visual Studio .Net C# and Excel Adam Excel Programming 2 March 24th 05 03:33 PM


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