Search results for query: *

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

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...

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).

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...

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.

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...

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...

what are the steps of writing user-defined formula in excel? i tried to insert publice functions in workbook module, class module, macros workbook - it didn't work. is there some special syntax? thanks.

is it possible to distribute ms forms controls with plain vb exe file? i know they can be used from visual studio but how can i "embed" this fm20.dll(which contains those controls) so the program will run on the computer that doesn't have office installed? simple copying and...

anybody knows a stand alone vbscript editor (not microsoft development environment, not ms-office ide) with object browser and autocomplete ? i need it for some program which has some really lousy vb ide. thanks.

until now i never used DDE to retrieve information from word. please, explain where can i find all the topics and commands can be used to communicate with word 2000 through DDE. i couldn't find any reference of it in msdn. thanks.

is there a way to change the template vb uses to create new subs and functions so when i close Add Procedure dialog instead of Public Sub Main() End Sub i'll get, for instance: Public Sub Main() On Error GoTo error_handler error_handler: MsgBox "Error!" End Sub thanks.

How can i detect when user actualy types something? I could not find any event that would give me an indication that user have changed the document by typing a letter. Can't I monitor changes in ActiveDocument in real time?

i have an old win 3.1 application which refuses to run under w2000 saing it is win nt. i tried to use file monitor and registry monitor to see how it does "os detecting", but i guess these apps can't monitor 16-bit. is there any way to prevent from this app seeing real os version? ( it...