Embedded Objects and ControlTips

Printable View

06-27-2004, 10:22 AM
Ian Mac

Embedded Objects and ControlTips

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
07-02-2004, 01:45 PM
Anne Troy

No replies?? Wow. I'm surprised. Bump!
07-02-2004, 04:34 PM
mark007

Quote:

I can't get an embedded ReadMe notepad file to open, I need this to open for certain people

How do you mean can't get it to work. What are you trying? Are you getting an error message? I can't say I've used shared workbooks much as they are unreliable but if you let me know the above I'll do my best to help! :)
07-03-2004, 09:40 AM
Ivan F Moala

Quote:

Originally Posted by Ian Mac

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

1) Hi Ian......what error if any are you getting ? for embeded Text
2) Tooltips with linefeeds ...... not sure but a couple of options
a) API's
b) create your own