Get Object in EXCEL

Results 1 to 2 of 2

Thread: Get Object in EXCEL

  1. #1
    Join Date
    Dec 1969

    Default Get Object in EXCEL

    Hi,<BR><BR>I am having an excel file stored. It is password protected. I want to open the file and read the contents and store it in the database. <BR><BR>I am using app.GetObject("myfile.xls") but my file is password protected and its asking for the password. is there any way to give the password without prompting me. because i am planning to read multiple files as a batch job.<BR><BR>please give me any idea.<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Get Object in EXCEL

    surely this isn&#039;t an ASP question? this is VBA, right?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts