Using another XL spread sheet

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?????

Nov 17 '06 #1

albertw

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:="yournewfile.xls"
ActiveWindow.ActivateNext

Nov 17 '06 #2

stuart79

hi

Workbooks.Open Filename:="yournewfile.xls"
ActiveWindow.ActivateNext

Hi

Workbooks.Open Filename:="I:\MNP Atlas Templates.xls"
ActiveWindow.ActivateNext

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

Nov 17 '06 #3

albertw

Hi

Workbooks.Open Filename:="I:\MNP Atlas Templates.xls"
ActiveWindow.ActivateNext

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:\MNP Atlas Templates.xls"

this will be the activeworkbook now.

Nov 17 '06 #4

stuart79

hi

msiunderstood
thought you wanted the loaded form to be on top

just use Workbooks.Open Filename:="I:\MNP 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

Nov 17 '06 #5

albertw

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=vbminimized

Nov 17 '06 #6