W
wmdmurphy
I have an app where I want the user to be able to click a command button and
open a selected Excel workbook read/write. So far Excel is only opening up
read only. Here's the code I'm using:
If Not ExcelRunning Then
Set objExcel = New Excel.Application
Else
Set objExcel = GetObject(, "Excel.Application")
End If
objExcel.Visible = True
objExcel.Workbooks.Open FileName:=strFullPathAndName, ReadOnly:=False
I thought the ReadOnly:=False would make the workbook writeable, but that's
not happening. I've also tried FollowHyperlink with the same result.
Any thoughts will be appreciated.
Bill
open a selected Excel workbook read/write. So far Excel is only opening up
read only. Here's the code I'm using:
If Not ExcelRunning Then
Set objExcel = New Excel.Application
Else
Set objExcel = GetObject(, "Excel.Application")
End If
objExcel.Visible = True
objExcel.Workbooks.Open FileName:=strFullPathAndName, ReadOnly:=False
I thought the ReadOnly:=False would make the workbook writeable, but that's
not happening. I've also tried FollowHyperlink with the same result.
Any thoughts will be appreciated.
Bill