Answer Questions

• random0000 Disable "Unprotect Document" in Tools Menu Item

  Is it possible to disable "Unprotect Document" in Tools Menu Item in MS Word using VBA We are accessing and modifying documents in Java using JACOB. If the document is protected we are unprotecting the document and doing modifications. But if the document is protected using a password there is no way we can provide the password programatically as each document could have different passwords. So if it is possible to disable the "U ...Show All

• Ikram Shaikh After_Save Event???

  Hi to all. I have a problem. For some sheets, I set to invisible before save. Now, I need set to visible the sheets after save, but there aren`t a After_Save Event... How can I solve my problem Any idea Thanks & Regards. I dont understand how can I capture the details of SaveAs after do user save, because the save never do... I put the code. saveSwitch is a global variable defined into a module. ------------- ...Show All

• nou2006 VBA for Powerpoint

  Hi, I have been asked to modify a powerpoint presentation so that from a series of jpg files, one appears on the screen and then after a specific time period disappears and is replaced by another; this being a continuous loop on one slide only - like a photo tour. I have the following code, but need to get it up and running. Any suggestions: Sub ImportABunch() Dim strTemp As String Dim strFileSpec As String Dim oSld As Slide Dim oPic As S ...Show All

• santosh42 Problem with VBA script

  Dear all, Can you please help me with the following problem I wrote a script to get the data out from the SQL Server and then format the cells. However, it seems it doesn't run the part B to format the cells. Any idea Thanks. 'Part A : Get the data from the SQL Server sqlstring ="select custid, custname from customer" connstring = "ODBC;UID=uid;PWD=p123;DATABASE=prod;DSN=HK0001" With ActiveSheet.QueryTables.Add( ...Show All

• dragon88 Automaticly updating charts in excel

  You guys (well mostly Derek) have been so helpful. I have everything but one thing working in my Excel file. I still can't get the charts to update when new information is put into the spreadsheet (I am using a form to fill in the cells with the data inputted). Now I have been basing all of this on a spreadsheet that already does this function. There is one major diffrence in that spreadsheet's charts and the one I am doing. Th ...Show All

• Deskman Disabling enter and mouse click PPT navigation

  If you've created a command button on a PPT slide that takes care of navigating to another slide, is there a way on this particular slide to disable the mouse click, Enter, etc. methods of moving to the next slide so that the only way to move off the slide is by clicking the command button Thanks! Per our support engineer: We can disable the mouse click to navigate the next slide. But we can not disa ...Show All

• Mohan Gupta Issue with MS 3.0 Outlook version

  When I enter CRM via the outlook version, It will open all the list views but will not let me drill down into specific acounts, contacts etc. The link will simply not do anything. They will work if I have the web version open. Thanks Hi, Please send a screen shot of your Outlook client showing this issue so that the engineer can investigate this for you. You can send it to budsup@microsoft.com ...Show All

• Hamboo Simple question on FrontPage / Internet Explorer

  I have just learning FrontPage 2003 using the Step by Step book. When I look at pages with ActiveX items in design view I see the item, if I switch to preview I dont see the item just the area it occupies. I suspect that I need to change a security setting in Explorer, but I don't know where to start looking. Can anyone tell me which setting needs to be changed and the likely consequences If the Web site is ...Show All

• Shanti Johnson how long does it take to get the MSDN subscription? with Empower .. and does it include Sourcesafe

  Hi All, We have signed up to Empower and received our DVD pack but I can not see any information regarding MSDN subscription , this is critical to us, we must have signed up nearly 3 weeks ago now. I also phoned and was told it was going to take about a week.   Dos anyone know how long we are going to have to wait for the MSDN subscription I have emailed LatamISV@microsoft.com  and am waiting for a response but wondere ...Show All

• MrKnudsen need help for VBA code(MS Access)

  Hi all, I need your kindly help. My MS Access Form needs a function like this: I have three text box and one button. When I click button first time, the 1st text box will display the current time . When I click button second time,  the 2nd text box will display the current time. the same with 3rd text box . Does VBA code can do this It would be greatly appreciated for any help reagrds, Nancy assuming your text ...Show All

• Simon253 Access to CryptEncrypt (CryptoAPI/WinAPI) functions in VBA

  Is it possible to access the CryptoAPI/WinAPI crypto functions to encrypt a string Assuming it is possible canyou point me to an example I can find C++ examples but I am looking for a VBA example. Hi, you'll need to use Windows API to use the CSP from VBA. This is an example taken from the API-Guide.... paste it into a class module and you have yourself a nice little encryption class. I haven't use ...Show All

• Old Mortality Help with: hiding main menu in Visio 2002 with VBA

  I don't know a thing about VBA but see myself in need to try to make this work. My goal here is to hide the menu bar when this particular document (let's call it "test.vsd") is opened in visio. After looking at the references and help files I put this together: Sub HideMenuBar() Dim fileName As String Dim uiObj As Visio.UIObject Dim menuSets As Visio.menuSets Dim OneMenuSet As Visio.menuSet ' get all built in menus into ui o ...Show All

• Paul Woodgate VBA and Excel Deleting Worksheets without user interaction

  Hi I have a VBA application in Excel where I want to delete quite a large number of worksheets in a workbook, and I want to do this without user interaction. Unfortunately the modal dialog pops up each time and waits until I click OK. I have looked but can't find a way of preventing the modal dialog from appearing. Does anybody have any ideas on how to solve this Many thanks in advance Works pre ...Show All

• RoMo FTP in Excel Macro

  I'm running on an isolated network and have a need to FTP a file from a UNIX server. For security reasons, I can't share a directory on the server so FTP is the only way to get the files I need. How can I do a simple FTP from within an existing Macro Thanks...Doug Hi Doug, Someone else asked this a while ago. If you look at my blog you'll find one way of doing it using an application called ftp.exe . ...Show All

• JackStri code in visual basic to convert decimal to hexadecimal and vise versa

  i need help to write code for visual basic to convert convert decimal to hexadecimal and vise versa can anyone help This is from methods in VBA but they should be in VB. The Hex(number) method returns a string representing the hexadecimal of the number. It only works with whole numbers in VBA, it should be the same in VB. There is no hexadecimal value for 10.45. See what the help file says about the method. To convert hex to n ...Show All