467,874 Members | 1,761 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,874 developers. It's quick & easy.

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?????
Nov 17 '06 #1
  • viewed: 2966
Share:
5 Replies
100+
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
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
100+
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
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
100+
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

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Gonzosez | last post: by
reply views Thread by jack112 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.