Using another XL spread sheet

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • stuart79
    New Member
    • Nov 2006
    • 7
    #1

    Using another XL spread sheet

    I am looking for a code that enables me to open another excel spread sheet while i am in my XL form i have this code - Workbooks.Open Filename:= "OtherFilename. xls" - which opens up the XL spread sheet that i need however my form sits ontop of the xl spread sheet and i am unable to do anything to the spread sheet in the back ground.

    I need a code which will bring up the other spread sheet and allow me to use it without closing my form?????
    Tags: None
    • albertw
      Contributor
      • Oct 2006
      • 267
      #2
      Originally posted by stuart79
      I am looking for a code that enables me to open another excel spread sheet while i am in my XL form i have this code - Workbooks.Open Filename:= "OtherFilename. xls" - which opens up the XL spread sheet that i need however my form sits ontop of the xl spread sheet and i am unable to do anything to the spread sheet in the back ground.

      I need a code which will bring up the other spread sheet and allow me to use it without closing my form?????
      hi

      Workbooks.Open Filename:="your newfile.xls"
      ActiveWindow.Ac tivateNext

        Comment

        • stuart79
          New Member
          • Nov 2006
          • 7
          #3
          Originally posted by albertw
          hi

          Workbooks.Open Filename:="your newfile.xls"
          ActiveWindow.Ac tivateNext
          Hi

          Workbooks.Open Filename:="I:\M NP Atlas Templates.xls"
          ActiveWindow.Ac tivateNext

          This still does not allow me to access the needed worksheet my user form still sits at the front.. any ideas???????

            Comment

            • albertw
              Contributor
              • Oct 2006
              • 267
              #4
              Originally posted by stuart79
              Hi

              Workbooks.Open Filename:="I:\M NP Atlas Templates.xls"
              ActiveWindow.Ac tivateNext

              This still does not allow me to access the needed worksheet my user form still sits at the front.. any ideas???????
              hi

              msiunderstood
              thought you wanted the loaded form to be on top

              just use Workbooks.Open Filename:="I:\M NP Atlas Templates.xls"

              this will be the activeworkbook now.

                Comment

                • stuart79
                  New Member
                  • Nov 2006
                  • 7
                  #5
                  Originally posted by albertw
                  hi

                  msiunderstood
                  thought you wanted the loaded form to be on top

                  just use Workbooks.Open Filename:="I:\M NP Atlas Templates.xls"

                  this will be the activeworkbook now.
                  My user form still sits ontop and i cannot access the workbook sitting in the back ground

                  Sorry to be a pain

                    Comment

                    • albertw
                      Contributor
                      • Oct 2006
                      • 267
                      #6
                      Originally posted by stuart79
                      My user form still sits ontop and i cannot access the workbook sitting in the back ground

                      Sorry to be a pain
                      how abt if you opened the file manually?
                      the opened file should be on top, at least on my computer it is.

                      furhter your can minimize the userform by .windowstate=vb minimized

                        Comment

                        Previous template Next
                        Working...