C
ColinNOVO
Folks,
Thanks for reading this post and helping out a newbie.
Here is my situation.
I have a MSSQL 2000 database that I would like to pass a query through
and display/manipulate the results in Excel on two seperate worksheets.
I have already tested the queries and they work fine and I have quite a
bit of programming experience in PG and MySQL in the past, so the MSSQL
is not my shaky part, it's the VB/Excel.
Here's my concept.
I want to create a simple user form that will prompt my users to enter
a job number and click on a button that will auto-create a
pre-calculated "Cost to Complete" worksheet and "Itemized Job Cost"
worksheet on entirely new Excel spreadtsheets. As stated, I have all
the necessary SQL statements laid out and know that they are accurate,
the only thing left to do is pass the JobNumber variable that is input
by the user in the aforementioned form through the query to give them
the Excel sheet.
Here's my problem.
As mentioned above, I'm a VB.net newbie and haven't done much
programming other than some command-line scripting and your run of the
mill CSS/HTML. The last time I used VB was 5 or 6 years ago and frankly
none of this stuff looks the same as when I took a class on it. Is my
concept possible? Feel free to offer up any other suggestions/ideas
that might make this a bit easier. The biggest thing is that once this
file is generated, it needs to have no saved macros/code in the as it
needs to be opened/manipulated once it's in place, so just making a VB
macro won't accomplish what I need, hence the reason I was looking at
the EXE/form route.
Thanks in advance,
Colin
Thanks for reading this post and helping out a newbie.
Here is my situation.
I have a MSSQL 2000 database that I would like to pass a query through
and display/manipulate the results in Excel on two seperate worksheets.
I have already tested the queries and they work fine and I have quite a
bit of programming experience in PG and MySQL in the past, so the MSSQL
is not my shaky part, it's the VB/Excel.
Here's my concept.
I want to create a simple user form that will prompt my users to enter
a job number and click on a button that will auto-create a
pre-calculated "Cost to Complete" worksheet and "Itemized Job Cost"
worksheet on entirely new Excel spreadtsheets. As stated, I have all
the necessary SQL statements laid out and know that they are accurate,
the only thing left to do is pass the JobNumber variable that is input
by the user in the aforementioned form through the query to give them
the Excel sheet.
Here's my problem.
As mentioned above, I'm a VB.net newbie and haven't done much
programming other than some command-line scripting and your run of the
mill CSS/HTML. The last time I used VB was 5 or 6 years ago and frankly
none of this stuff looks the same as when I took a class on it. Is my
concept possible? Feel free to offer up any other suggestions/ideas
that might make this a bit easier. The biggest thing is that once this
file is generated, it needs to have no saved macros/code in the as it
needs to be opened/manipulated once it's in place, so just making a VB
macro won't accomplish what I need, hence the reason I was looking at
the EXE/form route.
Thanks in advance,
Colin