My user form still sits ontop and i cannot access the workbook sitting in the back ground
Sorry to be a pain...
stuart79
Last Activity: Nov 21 '06, 02:05 PM
Joined: Nov 8 '06
Location:
-
Hi
Workbooks.Open Filename:="I:\M NP Atlas Templates.xls"
ActiveWindow.Ac tivateNext
This still does not allow me to access the needed worksheet my user form still sits at the front.. any ideas???????...Leave a comment:
-
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... -
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...Leave a comment:
-
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 -
Hi
The outboxes in question are from Outlook
I would like to have a set up where by each mail that comes into one of the inboxes is then counted in Excel so if i have 25 emails, 5 in each in each inbox i can look at excel and it will tell me that i have 5 e mails in each of the inboxes....Leave a comment:
-
Monitoring incoming e mail
I have created a form in excel using VB, the form is to monitor workload and how long taks take to complete.
My department currently works from 6 inboxes and monitoring work that is coming in is a bit of a nightmare, what i would like is if an e mail comes into any one of the inboxes i then have a counter within excel sheet counting each mail that is coming into the inbox i do not want the counter deducting each time an e mail is looked at...
No activity results to display
Leave a comment: