By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,646 Members | 2,098 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,646 IT Pros & Developers. It's quick & easy.

Using another XL spread sheet

P: 7
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
Share this Question
Share on Google+
5 Replies


100+
P: 267
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

P: 7
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+
P: 267
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

P: 7
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+
P: 267
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.