Search results for query: *

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

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.

I need to create a document with text of certain width. I use Word to wrap the lines. Then the text will be exported to another program (which doesn't recognize Word's wrapping, only CR or LF). You're saying one can refer to Range of line - how it can be done - there is no Line object in Word...

i'm trying to find a proper way to add a paragraph mark to the end of lines that was wrapped by setting right margin. i tried to save the file in text format but it looses formatting and inappropiate for text with several languages in it. is there a built-in option in Word to add paragraph (or...

well, it's seems really strange to me there's no simple script editor with intellisense. i spent a lot of time recently looking for something like this on the web. i guess i'll try primalscript - it's being referenced to in too many places.

I tried the reg hack already. The problem, I guess, is that all the variables in VBS are variant so there is no way to declare variable of Word or Excel type. Then how the IDE could know what kind of object is this? I'm quite a newbie for VBS and it seems like a dead lock to me. Unless there...

I'm trying to use MS Development Environment (mse.exe) to edit VBS files. Is there any way to declare an object variable so that it's members will be listed in the Members List drop-down box (IntelliSense)? I tryed to declare it with Dim objWord as new Word.Application Set...