By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,646 Members | 2,105 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.

Accessing other excel spreat sheets

P: 7
I have created a Form for a group of 30 - 40 users.
My users also need to access other excel spread sheets while the form is running. Currently when we try to do this we cannot open other excel document without first closing the form

can anyone please help
Nov 15 '06 #1
Share this Question
Share on Google+
3 Replies


100+
P: 1,646
I have created a Form for a group of 30 - 40 users.
My users also need to access other excel spread sheets while the form is running. Currently when we try to do this we cannot open other excel document without first closing the form

can anyone please help
Hi. I need some more info in order to get the full picture.
Is this a form in Excel?
Can you post some code?
Thanks
Nov 15 '06 #2

100+
P: 267
Hi. I need some more info in order to get the full picture.
Is this a form in Excel?
Can you post some code?
Thanks
hi

create a button on your xl-form, with code ...

Workbooks.Open Filename:= "OtherFilename.xls"

and let it run
no worries, your present form is only send to the background.
Nov 15 '06 #3

P: 7
hi

create a button on your xl-form, with code ...

Workbooks.Open Filename:= "OtherFilename.xls"

and let it run
no worries, your present form is only send to the background.

Hi
The above code brings up the other spreadsheet which is fantastic. i need it however so i can then use the spread sheet the above code brings up the spread sheet but the form sits on top
Nov 16 '06 #4

Post your reply

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