Ian Mac
06-27-2004, 10:22 AM
All,
Into the deep as they say! It's about time I started this here VBA thingy proper and not just messed about.
I have a huge project underway (perhaps the poject thingies the place)
However I'm having some little problems just now, waffle over.
My project is to use a shared workbook for x staff (15 tops I hope), they each input data into a form and submit it (this gets done through GetUserName Function) to their own sheet.
This works lovely, but because it's a shared workbook I can't get an embedded ReadMe notepad file to open, I need this to open for certain people (IT Bods mainly).
So, is there a way to open it with a shared workbook or can I embed it somewhere else (Must be within the App itself, not the server!)
2nd question, can ControlTips have Carriage Return in? I need tips to be dynamic as to the forms current view per user and some of the tips are quite large.
Thank in advance, and hello to everyone.
Cheers
Ian Mac
Into the deep as they say! It's about time I started this here VBA thingy proper and not just messed about.
I have a huge project underway (perhaps the poject thingies the place)
However I'm having some little problems just now, waffle over.
My project is to use a shared workbook for x staff (15 tops I hope), they each input data into a form and submit it (this gets done through GetUserName Function) to their own sheet.
This works lovely, but because it's a shared workbook I can't get an embedded ReadMe notepad file to open, I need this to open for certain people (IT Bods mainly).
So, is there a way to open it with a shared workbook or can I embed it somewhere else (Must be within the App itself, not the server!)
2nd question, can ControlTips have Carriage Return in? I need tips to be dynamic as to the forms current view per user and some of the tips are quite large.
Thank in advance, and hello to everyone.
Cheers
Ian Mac