Recent content by ckpeel

I'm using MOD for COM DLL development - VBA to be compiled in a DLL. The MOD projects let me set the target Application (Excel, Word etc). But I want to be able to write one application and based on the application loading it (word or excel) present a different Button or form? Can this be...

I have just installed this? I did have problems with it. I need to put on a "component" upgrade and it worked. I installed the MOD to allow for creation of Office COM DLL addin's. But as I launch the MOD enviroment I get "Element not Found" and it then open. NO project...

I ended up just using the contactitem in Outlook. I wrote a piece of code in VBA that connects to our application (via an COM object) - then opens the defualt contact folder/adds a folder an then adds the contact (with ContactItem).

If don't need to distribute your sheets to the public you can generate your own cert with program called 'selfcert.exe'. This articles tells you how do it and the ups and downs of it http://www.microsoft.com/officedev/articles/opg2k17.htm Also you will find in that article if you place your...

Glenn, I don't find any 'share' option under my file menu? Where do I turn this on from?

Thanks Glenn - This will help with keeping everyone in sync with the system. But the problem I'm dealing with is not just sync with each person but keeping in sync with the our application DB (MS SQL Server). I've seen some tools that do this - I think Intellisync from Puma also offers some...

Hi, I've been asked to sync our application 'contacts' to local outlook contacts so that we can store user info in the application (DB) and push it out to eveyone's local Outlook. I see some utilities developed to do just this a.k.a. Intellisync. Can anyone point me to an article or...

I call the code from the following sub: Sub AutoExec() 'Code that checks for the toolbar and adds ' it if required End Sub Sub AutoExit() 'delete the toolbar on unload 'routines run on unload of addin End Sub

Sorry - been away for a few days... the code for delete is as follows: Dim rc As Variant ' general Return code variable On Error GoTo Err_fDeleteAvistaToolbar 'should be err_subname where sub name is the function 'sub name we are in...

Sure.. this is the code I use to construct the Toolbars: Function fCreateAvistaToolbar() as Boolean '==================================== Dim cbrCmdBar As CommandBar Dim strCBarName As String Dim sSubName As String 'current Subname we are in On Error GoTo...

I'm not sure I know what the issue is - could be registry error or something. Have you tried removing Outlook Express and installing a clean version? That's about the only asnwer I can think of. I good Outlook Express site that may offer some real help is at: http://insideoe.tomsterdam.com...

hi This I hope is an easy answer.... but I haven't been able to figure out how to do this. I have a Word addin that I need a tool bar for ... I created code to add the toolbar and it works fine... I added it to the AutoExec routine. So when the addin is loaded I check for the tool bar and if...

VB has the ability to use the App.Eventlog to log messages in the system log. Can we do this in VBA also? I can't find a reference to being able to do this in my VBA documents. Anyone doen this yet? Chris

Is it at all possible to have a button on a web page (ASP)call and open word to launch a VBA. I'm trying to figure out if I can get a web button to take a customer number from the web page and open a Word document - launch a piece of VBA code (word vba addin) and produce a report with the data...

Excel has something called: Application.Dialogs(xlDialogOpen).Show but I can't seem to make it work like it does in Word?