Total newbie, need to manipulate and view information in excel 2007, from VBA6.0
Total newbie, need to manipulate and view information in excel 2007, from VBA6.0
Total newbie, need to manipulate and view information in excel 2007, from VBA6.0
Total newbie, need to manipulate and view information in excel 2007, from VBA6.0
Total newbie, need to manipulate and view information in excel 2007, from VBA6.0
Total newbie, need to manipulate and view information in excel 2007, from VBA6.0 Total newbie, need to manipulate and view information in excel 2007, from VBA6.0 Total newbie, need to manipulate and view information in excel 2007, from VBA6.0 Total newbie, need to manipulate and view information in excel 2007, from VBA6.0 Total newbie, need to manipulate and view information in excel 2007, from VBA6.0 Total newbie, need to manipulate and view information in excel 2007, from VBA6.0 Total newbie, need to manipulate and view information in excel 2007, from VBA6.0 Total newbie, need to manipulate and view information in excel 2007, from VBA6.0
Total newbie, need to manipulate and view information in excel 2007, from VBA6.0 Total newbie, need to manipulate and view information in excel 2007, from VBA6.0
Total newbie, need to manipulate and view information in excel 2007, from VBA6.0
Go Back  Xtreme Visual Basic Talk > > > Total newbie, need to manipulate and view information in excel 2007, from VBA6.0


Reply
 
Thread Tools Display Modes
  #1  
Old 12-09-2008, 04:07 AM
serenit-y serenit-y is offline
Newcomer
 
Join Date: Dec 2008
Posts: 15
Default Total newbie, need to manipulate and view information in excel 2007, from VBA6.0


alright, i have a project where i have to essentially, view the value of an Excel cell, lets say
"B,3", from a textbox in VBA.
I use VBA6.0, and have excell 2007.
How on earth do i complete this task,

Please speak in layman terms, i dont know how to connect the 2 programmes, all i know how to do is use Excel 2009's formulaic features, and do simple macros, Create textboxes and command buttons in VBA with simple codes in them.

Please help, thank you.
Reply With Quote
  #2  
Old 12-09-2008, 09:44 AM
Timbo's Avatar
TimboTotal newbie, need to manipulate and view information in excel 2007, from VBA6.0 Timbo is offline
Green-Eyed

Super Moderator
* Guru *
 
Join Date: May 2001
Location: Bangkok, Thailand
Posts: 10,261
Default

Are you working all within 1 Excel file? It's not clear if you are using Excel & a VB6 appliction, or if you are just using VBA within Excel...

Here's some discussions to get you started:
Automating Excel from VB 6.0
Excel/VBA userforms 101 and FAQ
__________________
"He's not the Messiah. He's a very naughty boy!" - Brian's mum

Can't find the answer? >> Try something new!
Become a Professional
Reply With Quote
  #3  
Old 01-21-2009, 12:03 PM
serenit-y serenit-y is offline
Newcomer
 
Join Date: Dec 2008
Posts: 15
Default

Quote:
Originally Posted by Timbo View Post
Are you working all within 1 Excel file? It's not clear if you are using Excel & a VB6 appliction, or if you are just using VBA within Excel...

Here's some discussions to get you started:
Automating Excel from VB 6.0
Excel/VBA userforms 101 and FAQ
Sorry it took me a while to answer,
I'm using Excel 2008, and then Visual Basics 2008, Two different files,
Reply With Quote
  #4  
Old 01-21-2009, 12:28 PM
Colin Legg's Avatar
Colin Legg Colin Legg is offline
Out Of Office

Retired Moderator
* Expert *
 
Join Date: Mar 2005
Location: London, UK
Posts: 3,402
Default

Hi,
Quote:
Originally Posted by serenit-y View Post
Sorry it took me a while to answer,
I'm using Excel 2008, and then Visual Basics 2008, Two different files,
Quote:
Originally Posted by serenit-y View Post
I use VBA6.0, and have excell 2007.
Quote:
Originally Posted by serenit-y View Post
i know how to do is use Excel 2009's formulaic features
Please can you clarify which version of Visual Basic:
  • VBA
  • VB6
  • VB. Net [2008]
and which version of Excel
  • Excel 2007
  • Excel 2008
you are using? It makes a big difference....
Reply With Quote
  #5  
Old 01-21-2009, 01:12 PM
serenit-y serenit-y is offline
Newcomer
 
Join Date: Dec 2008
Posts: 15
Default

Quote:
Originally Posted by Colin_L View Post
Hi,





Please can you clarify which version of Visual Basic:
  • VBA
  • VB6
  • VB. Net [2008]
and which version of Excel
  • Excel 2007
  • Excel 2008
you are using? It makes a big difference....
The Visual Basic version says,

Visual Basic 2008 Express Edition,
Sorry, the Excel version is Excel 2007 not 2008, i mixed the date up with the VB one.
Reply With Quote
  #6  
Old 01-21-2009, 03:14 PM
Colin Legg's Avatar
Colin Legg Colin Legg is offline
Out Of Office

Retired Moderator
* Expert *
 
Join Date: Mar 2005
Location: London, UK
Posts: 3,402
Default

Thanks for clarifying - I have moved this thread to the .Net forum since you are automating Excel using VB .Net, which is quite a different animal to VB6 or VBA.

One of our resident gurus, Mike_R, has written an introductory tutorial on automating MS Excel from VB .Net. I think it would be a great place for you to start with your project.

HTH,
Colin

Last edited by Colin Legg; 01-21-2009 at 03:21 PM.
Reply With Quote
  #7  
Old 01-21-2009, 03:30 PM
serenit-y serenit-y is offline
Newcomer
 
Join Date: Dec 2008
Posts: 15
Default

Quote:
Originally Posted by Colin_L View Post
Thanks for clarifying - I have moved this thread to the .Net forum since you are automating Excel using VB .Net, which is quite a different animal to VB6 or VBA.

One of our resident gurus, Mike_R, has written an introductory tutorial on automating MS Excel from VB .Net. I think it would be a great place for you to start with your project.

HTH,
Colin
Thanks man,
but i've always been confused with the term "VB.Net" or .Net, what is it,
Reply With Quote
  #8  
Old 01-22-2009, 11:16 AM
Mike Rosenblum's Avatar
Mike Rosenblum Mike Rosenblum is offline
Microsoft Excel MVP

Forum Leader
* Guru *
 
Join Date: Jul 2003
Location: New York, NY, USA
Posts: 7,848
Default

Hey serenit-y,

As Colin suggested, I would give the Automating Office Programs with VB.NET tutorial a read, in order to learn the basics. Then give it a try yourself and come back here for help when you get stuck...

Sound good?

Mike
__________________
My Articles:
| Excel from .NET | Excel RibbonX using VBA | Excel from VB6 | CVErr in .NET | MVP |
Avatar by Lebb
Reply With Quote
  #9  
Old 01-22-2009, 12:00 PM
serenit-y serenit-y is offline
Newcomer
 
Join Date: Dec 2008
Posts: 15
Default

Quote:
Originally Posted by Mike_R View Post
Hey serenit-y,

As Colin suggested, I would give the Automating Office Programs with VB.NET tutorial a read, in order to learn the basics. Then give it a try yourself and come back here for help when you get stuck...

Sound good?

Mike
Ah thanks a lot, now i know how to manipulate a cell in excel,
but isntead of;
"Dim oRng1, oRng2 As Excel.Range

oRng1 = oWS.Range("A1")
oRng1.Value = "Hello World"

oRng2 = oWS.Range("B2:E5")
oRng1.Copy(Destination:=oRng2)

oWB.SaveAs("C:\My Documents\MyWorkbook.xls")

oRng1 = Nothing ' <-- Don't forget!
oRng2 = Nothing ' <-- Or Excel will hang..."

to write hello world, in B2, of the myworkbook excel sheet,

How do i get the textbox i named "txtbox1" to display the information "Hello world" written in cell B2, of the excel file "Myworkbook.xls"?
Reply With Quote
  #10  
Old 01-22-2009, 05:06 PM
Mike Rosenblum's Avatar
Mike Rosenblum Mike Rosenblum is offline
Microsoft Excel MVP

Forum Leader
* Guru *
 
Join Date: Jul 2003
Location: New York, NY, USA
Posts: 7,848
Default

Something like this, maybe:

Code:
Dim xlApp As New Excel.Application
Dim wb As Excel.Workbook = xlApp.Workbooks.Open("C:\My Documents\Myworkbook.xls")
Dim ws As Excel.Worksheet = wb.Worksheets("Sheet1")
Dim rng As Excel.Range = ws.Range("B2")
rng.Value = "Hello World"
This should do it for you, I think? Give it a try...
__________________
My Articles:
| Excel from .NET | Excel RibbonX using VBA | Excel from VB6 | CVErr in .NET | MVP |
Avatar by Lebb
Reply With Quote
  #11  
Old 01-22-2009, 06:10 PM
Roger_Wgnr's Avatar
Roger_Wgnr Roger_Wgnr is offline
CodeASaurus Hex

Forum Leader
* Expert *
 
Join Date: Jul 2006
Location: San Antonio TX
Posts: 2,427
Default

Pardon Mike but I think he want the value from B2 to be placed in his textbox so it would be
Code:
Dim xlApp As New Excel.Application Dim wb As Excel.Workbook = xlApp.Workbooks.Open("C:\My Documents\Myworkbook.xls") Dim ws As Excel.Worksheet = wb.Worksheets("Sheet1") Dim rng As Excel.Range = ws.Range("B2") txtbox1.Text = rng.Value
and to answer the question in a nutshell
Quote:
but i've always been confused with the term "VB.Net" or .Net, what is it,
.NET refers to the .NET Framework and VB.Net refers to the versions of VB that use the .NET Framework (2002/2003/2005/2008)
__________________
Code as if the guy who ends up maintaining your code will be a violent psychopath who knows where you live. ~Martin Golding
The user is a peripheral that types when you issue a read request. ~Peter Williams
MSDN Visual Basic .NET General FAQ
Reply With Quote
  #12  
Old 01-22-2009, 07:14 PM
serenit-y serenit-y is offline
Newcomer
 
Join Date: Dec 2008
Posts: 15
Default

Quote:
Originally Posted by Mike_R View Post
Something like this, maybe:

Code:
Dim xlApp As New Excel.Application
Dim wb As Excel.Workbook = xlApp.Workbooks.Open("C:\My Documents\Myworkbook.xls")
Dim ws As Excel.Worksheet = wb.Worksheets("Sheet1")
Dim rng As Excel.Range = ws.Range("B2")
rng.Value = "Hello World"
This should do it for you, I think? Give it a try...
hm, but If i placed that code in a textbox on the VB form, and changed the range "B2" to "B3" will the textbox display the value in the range B3?,
Reply With Quote
  #13  
Old 01-23-2009, 03:10 AM
serenit-y serenit-y is offline
Newcomer
 
Join Date: Dec 2008
Posts: 15
Default

Quote:
Originally Posted by Roger_Wgnr View Post
Pardon Mike but I think he want the value from B2 to be placed in his textbox so it would be
Code:
Dim xlApp As New Excel.Application Dim wb As Excel.Workbook = xlApp.Workbooks.Open("C:\My Documents\Myworkbook.xls") Dim ws As Excel.Worksheet = wb.Worksheets("Sheet1") Dim rng As Excel.Range = ws.Range("B2") txtbox1.Text = rng.Value
and to answer the question in a nutshell

.NET refers to the .NET Framework and VB.Net refers to the versions of VB that use the .NET Framework (2002/2003/2005/2008)
Ah i'll try that, thank you both very much,
ill get back to you,
Reply With Quote
  #14  
Old 01-23-2009, 03:36 AM
serenit-y serenit-y is offline
Newcomer
 
Join Date: Dec 2008
Posts: 15
Default

I tried it, but when the programme runs, the textbox is empty, here is all the code i have on my VB form;

----------------------------------------------------
Imports Excel = Microsoft.Office.Interop.Excel
----------------------------------------------------
Public Class Form1

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

End Sub

---------------------------------------------
Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TxtBox1.TextChanged

Dim xlApp As New Excel.Application
Dim wb As Excel.Workbook = xlApp.Workbooks.Open("C:\Users\olufe\Documents\sam")
Dim ws As Excel.Worksheet = wb.Worksheets("Sheet1")
Dim rng As Excel.Range = ws.Range("B2")
TxtBox1.Text = rng.Value
End Sub
End Class
"
Reply With Quote
  #15  
Old 01-23-2009, 06:40 AM
Mike Rosenblum's Avatar
Mike Rosenblum Mike Rosenblum is offline
Microsoft Excel MVP

Forum Leader
* Guru *
 
Join Date: Jul 2003
Location: New York, NY, USA
Posts: 7,848
Default

Quote:
Originally Posted by Roger_Wgnr View Post
Pardon Mike but I think he want the value from B2 to be placed in his textbox so it would be
Code:
Dim xlApp As New Excel.Application Dim wb As Excel.Workbook = xlApp.Workbooks.Open("C:\My Documents\Myworkbook.xls") Dim ws As Excel.Worksheet = wb.Worksheets("Sheet1") Dim rng As Excel.Range = ws.Range("B2") txtbox1.Text = rng.Value
Sorry, my bad, I totally mis-understood. Yes, this sounds like the right direction! Thanks Roger for setting me straight...

Quote:
Originally Posted by serenit-y View Post
I tried it, but when the programme runs, the textbox is empty, here is all the code i have on my VB form;

----------------------------------------------------
Imports Excel = Microsoft.Office.Interop.Excel
----------------------------------------------------
Public Class Form1

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

End Sub

---------------------------------------------
Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TxtBox1.TextChanged

Dim xlApp As New Excel.Application
Dim wb As Excel.Workbook = xlApp.Workbooks.Open("C:\Users\olufe\Documents\sam")
Dim ws As Excel.Worksheet = wb.Worksheets("Sheet1")
Dim rng As Excel.Range = ws.Range("B2")
TxtBox1.Text = rng.Value
End Sub
End Class
I think the problem is that we are forgetting to make the Excel.Application visible to the user. I also don't think it makes sense for the text box to be creating the Excel.Application itself -- we should do that at startup:

Code:
Imports System.Runtime.InteropServices
Imports Excel = Microsoft.Office.Interop.Excel

Public Class Form1

    Dim xlApp As Excel.Application
    Dim wb As Excel.Workbook
    Dim ws As Excel.Worksheet

    Private Sub Form1_Load(ByVal sender As System.Object, _
                           ByVal e As System.EventArgs) Handles MyBase.Load
        xlApp = New Excel.Application
        xlApp.Visible = True ' <-- *** Key Improvement!!! ***

        wb = xlApp.Workbooks.Open("C:\Users\olufe\Documents\sam")
        ws = wb.Worksheets("Sheet1")
    End Sub

    Private Sub Form1_FormClosed(ByVal sender As Object, _
            ByVal e As System.Windows.Forms.FormClosedEventArgs) _
            Handles Me.FormClosed
        ' Cleanup:

        GC.Collect
        GC.WaitForPendingFinalizers

        Marshal.FinalReleaseComObject(ws)

        wb.Close(SaveChanges:=True)  ' <-- *** Change to True if want to save changes ***
        Marshal.FinalReleaseComObject(wb)
    
        xlApp.Quit
        Marshal.FinalReleaseComObject(xlApp)
    End Sub

    Private Sub TextBox1_TextChanged(ByVal sender As System.Object, _
                ByVal e As System.EventArgs) Handles TxtBox1.TextChanged
        Dim rng As Excel.Range = ws.Range("B2")
        TxtBox1.Text = rng.Value
    End Sub
End Class
Give it a try!
__________________
My Articles:
| Excel from .NET | Excel RibbonX using VBA | Excel from VB6 | CVErr in .NET | MVP |
Avatar by Lebb
Reply With Quote
  #16  
Old 01-25-2009, 07:26 AM
serenit-y serenit-y is offline
Newcomer
 
Join Date: Dec 2008
Posts: 15
Default

Quote:
Originally Posted by Mike_R View Post
Sorry, my bad, I totally mis-understood. Yes, this sounds like the right direction! Thanks Roger for setting me straight...

I think the problem is that we are forgetting to make the Excel.Application visible to the user. I also don't think it makes sense for the text box to be creating the Excel.Application itself -- we should do that at startup:

Code:
Imports System.Runtime.InteropServices
Imports Excel = Microsoft.Office.Interop.Excel

Public Class Form1

    Dim xlApp As Excel.Application
    Dim wb As Excel.Workbook
    Dim ws As Excel.Worksheet

    Private Sub Form1_Load(ByVal sender As System.Object, _
                           ByVal e As System.EventArgs) Handles MyBase.Load
        xlApp = New Excel.Application
        xlApp.Visible = True ' <-- *** Key Improvement!!! ***

        wb = xlApp.Workbooks.Open("C:\Users\olufe\Documents\sam")
        ws = wb.Worksheets("Sheet1")
    End Sub

    Private Sub Form1_FormClosed(ByVal sender As Object, _
            ByVal e As System.Windows.Forms.FormClosedEventArgs) _
            Handles Me.FormClosed
        ' Cleanup:

        GC.Collect
        GC.WaitForPendingFinalizers

        Marshal.FinalReleaseComObject(ws)

        wb.Close(SaveChanges:=True)  ' <-- *** Change to True if want to save changes ***
        Marshal.FinalReleaseComObject(wb)
    
        xlApp.Quit
        Marshal.FinalReleaseComObject(xlApp)
    End Sub

    Private Sub TextBox1_TextChanged(ByVal sender As System.Object, _
                ByVal e As System.EventArgs) Handles TxtBox1.TextChanged
        Dim rng As Excel.Range = ws.Range("B2")
        TxtBox1.Text = rng.Value
    End Sub
End Class
Give it a try!
It works ^ ^
But only when i click in the textbox after the form runs, when it runs to begin with, the textbox is blank, how do i make it so, once the textbox runs the value in cell B2 automatically appears,

just to to say you guys have been a great help, i would never have figured this stuff out, thanks a lot,
Reply With Quote
  #17  
Old 01-25-2009, 07:31 AM
serenit-y serenit-y is offline
Newcomer
 
Join Date: Dec 2008
Posts: 15
Default

Actually this works as well, but i still had to click in the extbox and type something, or simply tap the spacebar key, for the code to run and the value in the spreadsheet to appear,
"
Imports Excel = Microsoft.Office.Interop.Excel

Public Class Form1

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

End Sub


Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TxtBox1.TextChanged

Dim xlApp As New Excel.Application
Dim wb As Excel.Workbook = xlApp.Workbooks.Open("C:\Users\olufe\Desktop\sample")
Dim ws As Excel.Worksheet = wb.Worksheets("Sheet1")
Dim rng As Excel.Range = ws.Range("B2")
TxtBox1.Text = rng.Value
End Sub
End Class"
Reply With Quote
  #18  
Old 01-25-2009, 07:50 AM
Mike Rosenblum's Avatar
Mike Rosenblum Mike Rosenblum is offline
Microsoft Excel MVP

Forum Leader
* Guru *
 
Join Date: Jul 2003
Location: New York, NY, USA
Posts: 7,848
Default

This is happening because your code to update the TextBox's text is within your TextBox1_TextChanged event handler, which is called when the user types within the TextBox.

I think what you want is to put this code within the Form's Load event handler instead. Something like this:

Code:
Imports System.Runtime.InteropServices
Imports Excel = Microsoft.Office.Interop.Excel

Public Class Form1

    Dim xlApp As Excel.Application
    Dim wb As Excel.Workbook
    Dim ws As Excel.Worksheet

    Private Sub Form1_Load(ByVal sender As System.Object, _
                           ByVal e As System.EventArgs) Handles MyBase.Load
        xlApp = New Excel.Application
        xlApp.Visible = True

        wb = xlApp.Workbooks.Open("C:\Users\olufe\Documents\sam")
        ws = wb.Worksheets("Sheet1")

        TxtBox1.Text = ws.Range("B2").Value '<-- *** Now in Form1_Load! ***
    End Sub

    Private Sub Form1_FormClosed(ByVal sender As Object, _
            ByVal e As System.Windows.Forms.FormClosedEventArgs) _
            Handles Me.FormClosed
        ' Cleanup:

        GC.Collect
        GC.WaitForPendingFinalizers

        Marshal.FinalReleaseComObject(ws)

        wb.Close(SaveChanges:=True)
        Marshal.FinalReleaseComObject(wb)
    
        xlApp.Quit
        Marshal.FinalReleaseComObject(xlApp)
    End Sub

    Private Sub TextBox1_TextChanged(ByVal sender As System.Object, _
                ByVal e As System.EventArgs) Handles TxtBox1.TextChanged
        ' Do what you want in here when the user types within the TextBox1.
    End Sub
End Class
Make sense? Give it a try...
__________________
My Articles:
| Excel from .NET | Excel RibbonX using VBA | Excel from VB6 | CVErr in .NET | MVP |
Avatar by Lebb
Reply With Quote
  #19  
Old 01-25-2009, 03:29 PM
serenit-y serenit-y is offline
Newcomer
 
Join Date: Dec 2008
Posts: 15
Default

You guys are brilliant, thank you ^ ^, i'll study the code to alter it for my project,
Now i know how to connect to excel, and extract information from cells,
But can you guys tell me the code to display an excel Chart, in VB?
Reply With Quote
  #20  
Old 01-25-2009, 05:19 PM
Mike Rosenblum's Avatar
Mike Rosenblum Mike Rosenblum is offline
Microsoft Excel MVP

Forum Leader
* Guru *
 
Join Date: Jul 2003
Location: New York, NY, USA
Posts: 7,848
Default

Glad we can help.

To programmatically control an Excel chart, I would begin with the Macro recorder in VBA and see what commands it spits out. Then clean up the code according to your needs (and convert to VB.NET, of course).

That said, I always prefer to set up my charts manually -- there are just too many settings to get this right programmatically. So create your chart, get it looking perfect, and save it on a workbook. Then simply have your program open the workbook that has the chart on it.

I usually have the chart reference cells on the worksheet (or on another hidden worksheet), which the program can then change in order to get the chart to react. That is, I programmatically change the data that the chart is showing, but the chart itself is created manually and saved to a workbook.

Make sense?
__________________
My Articles:
| Excel from .NET | Excel RibbonX using VBA | Excel from VB6 | CVErr in .NET | MVP |
Avatar by Lebb
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
Total newbie, need to manipulate and view information in excel 2007, from VBA6.0
Total newbie, need to manipulate and view information in excel 2007, from VBA6.0
Total newbie, need to manipulate and view information in excel 2007, from VBA6.0 Total newbie, need to manipulate and view information in excel 2007, from VBA6.0
Total newbie, need to manipulate and view information in excel 2007, from VBA6.0
Total newbie, need to manipulate and view information in excel 2007, from VBA6.0
Total newbie, need to manipulate and view information in excel 2007, from VBA6.0 Total newbie, need to manipulate and view information in excel 2007, from VBA6.0 Total newbie, need to manipulate and view information in excel 2007, from VBA6.0 Total newbie, need to manipulate and view information in excel 2007, from VBA6.0 Total newbie, need to manipulate and view information in excel 2007, from VBA6.0 Total newbie, need to manipulate and view information in excel 2007, from VBA6.0 Total newbie, need to manipulate and view information in excel 2007, from VBA6.0
Total newbie, need to manipulate and view information in excel 2007, from VBA6.0
Total newbie, need to manipulate and view information in excel 2007, from VBA6.0
 
Total newbie, need to manipulate and view information in excel 2007, from VBA6.0
Total newbie, need to manipulate and view information in excel 2007, from VBA6.0
 
-->