Win XP an Excel SP3

[Romolo]

In a VB6 Form CommandButton Control through which I intend to activate an
EXCEL instance and open a given Workbook to give the user the capability to
read AND
MODIFY data according to his needs, I've put the simple code reported below.

Private Sub Command2_Click()
Unload Me
Dim WbName As String

WbName = "C:\WBOOK1.xls"
Set objexcel = CreateObject("Excel.Application")
objexcel.Visible = True
objexcel.Workbooks.Open FileName:= WbName, _
UpdateLinks:=True, ReadOnly:=False
End Sub

Despite of the "ReadOnly:=False" specification, I can only have access to
the xl file in ReadOnly mode!
There are no restrictions related to that file. How can I solve this problem?

My sys. environment is:
Window XP Home SP2
EXCEL 2003 SP3

Thanks a lot
Romolo

 

[Colin Barnhorst]

This is a newsgroup for general questions about XP. I respectfully suggest
you try a visual basic or Office newsgroup.

 

[NoConsequence]

In a VB6 Form CommandButton Control through which I intend to activate an
EXCEL instance and open a given Workbook to give the user the capability to
read AND
MODIFY data according to his needs, I've put the simple code reported below.

Private Sub Command2_Click()
Unload Me
Dim WbName As String

WbName = "C:\WBOOK1.xls"
Set objexcel = CreateObject("Excel.Application")
objexcel.Visible = True
objexcel.Workbooks.Open FileName:= WbName, _
UpdateLinks:=True, ReadOnly:=False
End Sub

Despite of the "ReadOnly:=False" specification, I can only have access to
the xl file in ReadOnly mode!
There are no restrictions related to that file. How can I solve this problem?

My sys. environment is:
Window XP Home SP2
EXCEL 2003 SP3

Thanks a lot
Romolo

You are asking a question about a form in VB6, accessing a file in
Excel format. What on earth does any of that have to do with XP?
IOW, wtf are you doing asking that question HERE?

Ask elsewhere