467,880 Members | 1,142 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Accessing other excel spreat sheets

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
  • viewed: 1305
Share:
3 Replies
1GB
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+
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
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.

Similar topics

1 post views Thread by sk | last post: by
8 posts views Thread by Sam | last post: by
1 post views Thread by Esmail Bonakarian | last post: by
4 posts views Thread by =?Utf-8?B?QnJpYW5ESA==?= | last post: by
reply views Thread by MrMoon | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.