Search results for query: *

COM addins are dll's whose functions can be called from office applications

Hi, I want to create COM addins on Vb6 for Microsoft word application. Can anybody tell how can I do that or post some link where I can find how it should be done. Actuallay I have some functions and I want to make them centralized so that word application can call them. Regards, Furqan

I have already tried it, not working but if I directly use function 'Increment1' that is inside Mathlib3.dll then it is working fine. The problem arises when one dll is calling other dll

Here are the code Mathlib2.dll Option Explicit Public Declare Function Increment1 Lib "D:\VBA\VB Library Files\MathLib3\MathLib3.dll" (var1 As Integer) As Integer Public Const DLL_PROCESS_DETACH = 0 Public Const DLL_PROCESS_ATTACH = 1 Public Const DLL_THREAD_ATTACH = 2 Public Const...

The dll is referenced in the project and registered on my pc

I have two standard dll developed in VB and I am calling one of them in vba for word. This dll has a function which calls the other dll and returns an integer which should be passed to vba, code is bellow ///// Public Declare Function Increment Lib "D:\VBA\VB Library Files\MathLib2.dll" (var2 As...

Is there any way to view the the "formatting in use" in word document through vba. its not same as styles Regards, Furqan

Hi, In my VBA program I am doing some copy and paste operations and if user have copied something before running the program then it wouldn't accessible through normal paste operation (ctrl+v) one has to view office clipboard to look for his desired copy. I want to avoid this by restoring the...

I want to go through with all the formatting in use in a word document and collect some description i am using the following code but it is not working sub test() dim sty as style for each sty in activedocument.styles if sty.inuse = true the msgbox(sty.font.name) end if next end sub this...

Hi, I would like to know that is there any other way to look into page setup properties using vba without opening the word document. Actually I have lorge no of files and I need to gather seetings in pagesetup for all the files I am using following code set doc = documents.open(FilePath) if...

Is it possible to specify complete file name with location of dll which is not registerd, will it work?

Can you throw some light on the process of registring dll

It is not there in system folder. Actually this file is used in a nwetwork comprising of more than 50 Pcs I have many copies of this file in different locations and I am not sure which file is active one. Is there any method to find out this? I have two dll files with same name and different...

when we are using declare statment like bellow Private Declare Function GetTempPath Lib "abc.dll" _ Alias "GetTempPathA" (ByVal nBufferLength As Long, ByVal lpBuffer As String) As Long What would be location where vba will look for this dll file? This file is not there in...

it worked for me, Thanks Gerry for your help Regards, Furqan

test = Module1.main the above statement means, main is a function inside module named Module1 and it returns a value which is stored in test your code is working fine,thanks, but what if I want to pass some value to function and function is returning a value. What we usually do when fucntion...

I have loaded the the template and installed it but I cant find any code to run the macro, I mean if I reference the file I just need to write the name of macro to run it. Also if I have some function which returns some value then how to use this addins to have that value. for instance im...

Which help you are talking about? thnaks, Furqan

Thanks for your reply now this is the code ActiveDocument.VBProject.References.AddFromFile "complete file name as string" 1. how do you know that is looking in the Temp folder? In tools->References menu you can see the location of referenced files, so there I can see that it is pointing...

I have a strange problem with file reference. I am trying to reference a word template which has some macros that I want to use. The problem is that whenever I try to reference this file the link got broken even though the file is present in the specified location but vba start to look for the...