Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. General Programming
  3. C / C++ / MFC
  4. Excel Open

Excel Open

Scheduled Pinned Locked Moved C / C++ / MFC
testingtoolstutorialquestion
7 Posts 3 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • R Offline
    R Offline
    rdop
    wrote on last edited by
    #1

    Hi Forums I am try to open Excel Protected workbook.I know how to open excel through microsoft office automation.

    Excel::_ApplicationPtr pApplication;
    Excel::_WorkbookPtr pBook;
    HRESULT hr;
    _variant_t varOption( (long) DISP_E_PARAMNOTFOUND, VT_ERROR);
    CoInitializeEx(NULL,COINIT_MULTITHREADED);
    hr = pApplication.CreateInstance(__uuidof(Excel::Application));
    if (FAILED(hr) )
    {
    return 0;
    }
    pBook = pApplication->Workbooks->Open( (_bstr_t)fileNameopen,varOption, varOption, varOption, varOption, varOption, varOption, varOption, varOption, varOption, varOption, varOption, varOption );

    Through this code i am eable to open ecxel Unprotected.But i have protected excel file then excel file ask password.So Can i remove password or get password? I cann't use third party tool.Please advice me what i do? if any dll available then please give me link.

    C G 2 Replies Last reply
    0
    • R rdop

      Hi Forums I am try to open Excel Protected workbook.I know how to open excel through microsoft office automation.

      Excel::_ApplicationPtr pApplication;
      Excel::_WorkbookPtr pBook;
      HRESULT hr;
      _variant_t varOption( (long) DISP_E_PARAMNOTFOUND, VT_ERROR);
      CoInitializeEx(NULL,COINIT_MULTITHREADED);
      hr = pApplication.CreateInstance(__uuidof(Excel::Application));
      if (FAILED(hr) )
      {
      return 0;
      }
      pBook = pApplication->Workbooks->Open( (_bstr_t)fileNameopen,varOption, varOption, varOption, varOption, varOption, varOption, varOption, varOption, varOption, varOption, varOption, varOption );

      Through this code i am eable to open ecxel Unprotected.But i have protected excel file then excel file ask password.So Can i remove password or get password? I cann't use third party tool.Please advice me what i do? if any dll available then please give me link.

      C Offline
      C Offline
      CPallini
      wrote on last edited by
      #2

      Why should we help you cracking Excel? :)

      If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.
      This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. -- Iain Clarke
      [My articles]

      R 1 Reply Last reply
      0
      • C CPallini

        Why should we help you cracking Excel? :)

        If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.
        This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. -- Iain Clarke
        [My articles]

        R Offline
        R Offline
        rdop
        wrote on last edited by
        #3

        ok i am not going to force to help me.Just i ask a question.If you think to help me then most welcome or if not then also most welcome. I need this type of scenario.So I ask here. Thanks

        C 1 Reply Last reply
        0
        • R rdop

          ok i am not going to force to help me.Just i ask a question.If you think to help me then most welcome or if not then also most welcome. I need this type of scenario.So I ask here. Thanks

          C Offline
          C Offline
          CPallini
          wrote on last edited by
          #4

          If you have lost the password, I guess you may search for a password recovery tool. :)

          If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.
          This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. -- Iain Clarke
          [My articles]

          R 1 Reply Last reply
          0
          • C CPallini

            If you have lost the password, I guess you may search for a password recovery tool. :)

            If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.
            This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. -- Iain Clarke
            [My articles]

            R Offline
            R Offline
            rdop
            wrote on last edited by
            #5

            No i am not trying to use third party tool.Any way Can you give a one basic idia there is any more way to open excel file accept(office automation). Regard's Rdop

            1 Reply Last reply
            0
            • R rdop

              Hi Forums I am try to open Excel Protected workbook.I know how to open excel through microsoft office automation.

              Excel::_ApplicationPtr pApplication;
              Excel::_WorkbookPtr pBook;
              HRESULT hr;
              _variant_t varOption( (long) DISP_E_PARAMNOTFOUND, VT_ERROR);
              CoInitializeEx(NULL,COINIT_MULTITHREADED);
              hr = pApplication.CreateInstance(__uuidof(Excel::Application));
              if (FAILED(hr) )
              {
              return 0;
              }
              pBook = pApplication->Workbooks->Open( (_bstr_t)fileNameopen,varOption, varOption, varOption, varOption, varOption, varOption, varOption, varOption, varOption, varOption, varOption, varOption );

              Through this code i am eable to open ecxel Unprotected.But i have protected excel file then excel file ask password.So Can i remove password or get password? I cann't use third party tool.Please advice me what i do? if any dll available then please give me link.

              G Offline
              G Offline
              Game point
              wrote on last edited by
              #6

              try using odbc ..

              :~ Failure is Success If we learn from it!!:~

              R 1 Reply Last reply
              0
              • G Game point

                try using odbc ..

                :~ Failure is Success If we learn from it!!:~

                R Offline
                R Offline
                rdop
                wrote on last edited by
                #7

                odbc not support .xlxs.

                1 Reply Last reply
                0
                Reply
                • Reply as topic
                Log in to reply
                • Oldest to Newest
                • Newest to Oldest
                • Most Votes


                • Login

                • Don't have an account? Register

                • Login or register to search.
                • First post
                  Last post
                0
                • Categories
                • Recent
                • Tags
                • Popular
                • World
                • Users
                • Groups