Search results for query: *

I need to upgrade 2003 Standard, to Enterprise. Are the existing CALs transferable, or do we need to purchase new ones? Thanks, Chris Chris IT would be the perfect job......if it didn't have users!!!

I'm running Outlook 2002, and downloading my email from my ISP (Optusnet). Lately, I've been getting some spam mail come through, addressed from my own email address. ie username@optusnet.com.au. I don't have any corresponding emails in my sent mail folder, on either my pc or on my webmail. I...

Hi all, I have Exchange 5.5 running on a Windows NT 4 Terminal Server Box. I am trying to export all mailboxes to PST files. I have downloaded exmerge into the exchsrvr\bin folder, and have added mapi32.dll and mfc32.dll (ver 6.nn). When I try to run Exmerge, I get an error message:- 'One or...

Welcome back Anne Troy, a lot of us missed your presence in the forums. I also would like to wish you the very best in your recovery. [2thumbsup] Chris Chris IT would be the perfect job......if it didn't have users!!!

How do I Delete (destroy) an Excel command button programmatically? Chris It worked yesterday. It doesn't work today. That's Windows!

Hi All, I am currently writing a progress query that generates a .csv file, and then opens it with Excel. So far so good, it's working What I now need to do is open another Excel workbook (first one still open), and run a macro from the just opened workbook. Can someone advise how to get the...

I have just managed to be able to connect to my Progress database, and return data to VB6, by hardcoding the 'WHERE' part of the query into the select statement. Can someone give some guidance as to how set this up so that it is a variable. ie. so I can pull it from a textbox. In my code below...

Excel 97. I have a funtion that takes 1 argument (integer), and works fine. I am trying to expand it, and need to pass the sheet name to it. I have added the extra arg to the function okay, but when I add it to the sub to pass I get a compiler error telling me that the compiler was...

I have a workbook where I have removed all the standard commandbars via code, and then add my own menu. All is working okay, except that my new menu appears as a floating bar. How can I get this to 'park' at the top of the screen? Thanks for any help. Chris It worked yesterday...

From Word 97 I need to be able to open a specific Excel 97 workbook, and trigger an Excel sub/macro with a string passed from the Word vba code. Is this possible? If not, then I guess that I could use the on open event of the workbook to trigger my code. However, I would still need to do the...

Excel 97 I'm trying to set the control souce for a textbox (on a userform), using named ranges and R1C1 convention. eg. A2 as a ControlSouce works okay, but I'm trying to set it using R1C1 convention, which would be (2,1) and then use named ranges for R & C, so that I end up with something...

I am automating a serires of Excel files. So far I have been able to programatically generate the filename, and set the saveas path to a sub-directory of the current directory, but need to be able to pickup up the directory path higher up. eg. using ActiveWorkbook.path might give me...

I'm trying to generate a .gif imaage from a named range. Looking at method Range.CopyPicture it only appears to generate a .bmp output. To generate a .gif from a chart I'm using:- ActiveChart.ChartArea.Select ActiveChart.Export FileName:="ChartX.Gif", FilterName:="Gif&quot...

I have a single sheet workbook, which is protected. When a button is clicked, I unprotect the sheet, do some work, then protect the sheet again. This code works properly when I step it through in the VBA editor. However, when I run it from the button I get the following error: Error 1004...

Hi All, Can anyone point me at any usable reference material for Excel Databases. Thanks, Chris Chris It worked yesterday. It doesn't work today. That's Windows!

I've got a mixed bag of operating systems connecting to an NT4 network. In my excel workbook, I'm grabbing the network username and using it for security. This is fine for my NT, Win 2000, and Citrix clients, but fails for my Win 98 clients. Is there anyway to access the network username that...

On my Workbook_BeforeClose I have the following code. This works as anticipated, except that I don't get the formulaBar or statusBar back. If I put this code in a module and run it, it works fine. But if I call that same sub from the Workbook_beforeClose, I get the same problem with the 2 bars...

Excel 97. Is there a way to disable the application close button (X in top right corner), via vba. I'm trying to force my users to close via a macro button, which resets to standard menus. I've already disabled the close button on the window, but can't find how to kill the application one...

I'm pulling data into an Excel (97) worksheet via MS Query. Is there any way to refresh the data on a timed basis, and without opening the workbook. What I'm trying to achieve, is a workbook that is used as a central data repository for other workbooks that will use VLOOKUP. But I would like to...

Hi All, I need to prevent my Citrix users from changing the MS Word dictionary to a different language. I know that there is a registry key that does this, but can't find it (did it once before, but have lost the document/faq). Can anyone point me to it? tia Chris. winnt4 tse and citrix 1.8...