K
Kirk
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!
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!