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]

Re: Win XP an Excel SP3

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

"Romolo" <Romolo@discussions.microsoft.com> wrote in message
news:E7FD5D0C-DB3E-486B-BF82-098476777ADD@microsoft.com...
> 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

 

[NoConsequence]

Re: Win XP an Excel SP3

On Sun, 27 Jan 2008 09:32:04 -0800, Romolo
<Romolo@discussions.microsoft.com> wrote:

>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