absolutly new and very confused

Hot Topic

Process continues to run after Application.Exit()
MSDN Express
MS Access connection problem
Saving File Format Idea... Help me
Conversion from Visual Studio (VC++) 2005 to VC++7/6
MDI - Parent/Child Forms
Packagin SQL Server 2000 databse
Treeview question #4
Print() Method in VB.NET
Displaying Data from a Access spreadsheet on a form

VS Express Editions

Problems converting VS 6 solution to Visual Studio Beta 2 C++ Express
Display RSS Feed
drawing images onto another image
Problems with Database and openfile and savefile dialogs
Porting web navigator from VB6 to VS2005 C#
Can I have all the express versions on one PC with VB.NET 2003
No ASP.NET Selector IIS
VB Express and SQL 2000
Newbie: Parse and Formatting?
A Problem with Relative Paths

absolutly new and very confused

hi everyone ,

I work in construction , and last year i developed a spreadsheet to estimate materials for different phases of my job . theres about 25 worksheets and lots of vba code . macros etc .

I was hoping to try marketing spreadsheet , but ran into issues with excel and protection , liscense control etc . Sooooooo I figured vb 2005 express ...free ....i'm on it ...this will be great ...

well .... i'm having issues ....and the worst issue is I dont even know which way i should be going with this thing ... do I try to build a program that opens excel and shows my SS ..... do i try to embed it , or link it ....do I have to make a data grid that some how exports and imports info to my SS ....... and what impact will any these have on how the program runs and the security issues

Maybe I just got to rewrite the whole dern thing .. which would suck because theres a ton formulas involved as well as macros and code

SO ..... I'm open for suggestions ...which would be best direction to go ....

thanks bob



Answer this question

absolutly new and very confused

  • bwells

    hi,

    if you have just one job to do ( to read from SS) then your way will be easy , first of all you have to discover your tool(vb)

    http://msdn.microsoft.com/vstudio/express/vb/learning/default.aspx

    second you have to look to the area that you want

    http://msdn2.microsoft.com/en-us/library/xx069ybh(VS.80).aspx

    http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnoxpta/html/vsofficedev.asp

    hope this helps



  • Kelvin Lush

    ok .... so i guess .... this aint going to be a quick easy thing ....damn !! ... i guess it was a nice thought ....

    so i"ll focus on my oop....and read as much as i can .... will i have to translate all those formulas to code .....

    is it possible to keep the spreadsheet in tact or should i just forget about that and figure on redoing it all in vbe


  • RobertC..!

    Hi Bob,

    Suggestion #1 - Read the information at the top of the forum.

    If this is your first venture into OOP, I'd recommend that you focus on OOP for at least six months before starting on a serious project because if there is pre-existng code all you're going to do is to damage it.

    Take your time and learn this. VBE is a great way to do this.



  • Steamboat

    huuuhhhh, i still have 3 months then to do something usefull

  • AliSyed

    If you're married to spreadsheets, you may want to look into Visual Studio Tools for Office at http://msdn.microsoft.com/office/understanding/vsto/default.aspx
  • absolutly new and very confused
Answer this question