Recent content by jackha18

-----------------------------------------------------

thanks that's what i was looking for.

the form is not modal, of course

Hi, how can I programmatically switch focus from a form to workbook grid. I tried ActiveWindow.Activate - not working. thanks.

Thanks, guys

Hi, Can anybody recommend a good book/reference on Access? I'm starting my first project now and I've tried MS Access 2003 Inside Out. This 1300 pages monster is overloaded with "left-click here" and "right-click there" bullshit.Seems like it's written for the people who've never used PC...

thanks byundt! I wonder is there any way to alter Excel Clipboard so that it will only contain values. As far as I know Excel COM does not provide interface to its Clipboard. Anybody here familiar with API functions to access and change Excel Clipboard? I was also thinking about tracking Paste...

I have a sheet with data validation in some cells. When users paste values into these cell validation is replaced or erased by the validation of pasted cells. Is there any way to protect cell validation when pasting data (without forcing users to always use Paste Values command).

Too simple to be true ! If you have a child and a parent window, you cannot activate the child without activating the parent. So every time I activate the child (in my case - Excel form) the parent (Excel document window) also got activated. The only solution I came upon till now is to make...

I need to use Excel user form with other application. I made the form topmost window using SetWindowPos API function. The problem is that excel document pops-up every time I activate the form. I can hide Excel using Application.Visible=False but then I can't use other Excel documents. How can...

if you parse it only to put column information accross several rows you can copy the the column range and then paste it back using transpose option which actually "rotates" columns to rows and back: With Worksheets("Sheet1") .Range("A1:A3").Copy .Range("D1:F1").PasteSpecial xlPasteAll...

Suppose I do know the Word window title. I then use FindWindow and get its handle. If I want to use automation with this window (this instance of application), how do I get a reference to that specific instance of application. hWnd only references to a window - it does not allow me to automate...

Sorry, but it seems like I din't explained the problem properly. Suppose I have two instances of Winword.exe running and I want to use automation (e.g. from Excel) to work with one of them. I call GetObject function and it gives me a pointer to one of the instances. The parameter passed to...

Micsrosoft says (in MSDN) when there is more than one instance of application is running there is no way know what instance GetObject() will return. Is there is any other way I can cycle through all instances of the application and get a pointer to one of them I choose.

Cool! I've never used bookmars before - I need to learn this feature. Thanks for the help, Gerry.