Opening Excel Protected workbooks from vb 
Author Message
 Opening Excel Protected workbooks from vb

 I was wondering if someone from this group could possibly help me.

I am trying to open a password protected excel application from within
my vb app.

I have tried various code samples such as

Dim my xlapp as excel.application
set myxlapp = getobject("myspreadsheet.xls") workbooks("myspreadsheet", "thepassword")

didn't work

tried workbooks("myspreadsheet", password:"thepassword")

tried workbooks("myspreadsheet", password: = "thepassword")


Can someone please help me out with this?

Thu, 22 Mar 2001 03:00:00 GMT  
 [ 2 post ] 

 Relevant Pages 

1. Opening Excel Password protected workbooks

2. Excel HRESULT: 0x800A03EC when using or Workbooks._opentext in C#

3. Excel 97/2000: making custom functions (in a hidden workbook) available to all open workbooks

4. Excel Workbook takes too long to open in Excel 2000

5. ASP using a VB DLL to open an Excel workbook

6. Opening a Excel 5.0 Workbook with VB Code

7. VB check if the Excel Workbook already open

8. How can I open Excel workbook without using Excel.Worksheet

9. Finding open Excel workbooks from Access.

10. Open Excel workbook

11. read/write without open workbooks in excel

12. Opening a Excel Workbook


Powered by phpBB® Forum Software