i m a novice and dun't know much abt office components..i have written this code to bind my pivot chart with the sql server. but till now i m not successful at all..........pl z do help me to bind sql with the pivot chart of ms excel........th anks



Private Sub cspace_Enter(By Val sender As System.Object, ByVal e As System.EventArg s) Handles cspace.Enter

''''''''''''''' ''''''''''''''' ''''''''''''''' ''''''''''''''' ''''''''''''''' ''''''''''''''' '''''...

I have written the following code in VB6 and I want to open multiple files in a single go through the openfiledialog. Please help me as I'm a beginner in VB6.
[CODE=vb]
Application.Scr eenUpdating = False

filetoopen = Application.Get OpenFilename("x yz (*.txt, *.log; *.txt; *.*")
'application.m

If filetoopen = False Then
OpenTotemFreqPl anFile = 0
Exit Sub[/CODE]