Answer Questions

• Talha Ahmad Disable editing Excel cells

  Hi How to prevent users of a spreadsheet editing the content of the cells Is there anything we can do in VBA thx a lot yuelin there's two parts to protecting the contents of cells. 1. you need to set the locked property of the cells you want to protect to true (its true by default) or false if the cell can be edited. 2. you need to protect the worksheet Worksheets("Sheet1").Rang ...Show All

• crescens2k Application in the Task Bar

  Does any one explain why the application is not shown in the task bar if the form is shown modally. Is there a better way of handling the code without showing the form modally Here is the VB 6.0 code ...        Screen.MousePointer = vbNormal        frmSelection.Show 1        If clicked_OK = False Then         frmSe ...Show All

• killer10 How do you find out the Windows User Name from VBA

  We log onto our network with a three letter user name e.g. ADG. Can I return the user name of the person opening my Access Database with VBA I want to customise the options available to the user without using the security features built into Access. Many thanks Carbo, Environ$("Username") returned "adg" as expected. Thanks also Peter, but Application.CurrentUser returned "Admin&q ...Show All

• coloradovista your view on product roadmaps

  I'm curious to find out what your views are on product roadmaps... 1. Valuable or not 2. What is more important - being able to see the product integration or the estimated timelines or both 3. If you currently work with a product roadmap, what format do you find most useful - interactive/online, PDF, other Textual display or visual thanks, -brenda (ISV Buddy Team) Well until recently I thought that they were ver ...Show All

• wanyong my buddy

  I love the buddy program. I think it is a great idea. I love microsoft products, and with the help of my buddy, I am learning more about my microsoft software. I have one problem. Even though I have tryed and she has tryed, I can't get her to show up on my instant messenger list, so I can talk to her in my messenger. We are still working on that one. But, my buddie is perfect for me. When I have a question, she is very help ...Show All

• vccool cannot save file as

  I can't save any files on any of my other drives. The message comes up as save file not responding. Also szAppname:WINWORDEXE, szAppver:11.06568.0, szModname:hungapp. Why can't you ever get help from microsoft without a fee After all this is their product. I have the same problem. i have'nt had yet the solution!! golferdrums I'm having the same problem. Did you get an answer to your question ...Show All

• Litoplan Run time error 1004

  I am attempting to delete a range of cells in an Excel spreadsheet using a Macro. The range is one row by 8 columns. However, when the line of VBA code actually doing the deletion is reached I get a "Run-time error '1004': Delete method of Range class failed." The actual line causing the error is: Selection.Delete Shift:=x1Up where I have previously selected the range. All of the cells in the range do have data a ...Show All

• Rob Jones How to become an ISV

  How to become an ISV what are the advantages of being an ISV and purchasing a MSDN Subscription what are the licensing Issues Having a MSDN Subscription and being an ISV can I deploy the developed applications to my clients How much should I pay to be an ISV and have a MSDN Universal Subscription (in Indian Rupees) Can an Freelancer be a ISV Can the Freelancer be a ISV and Work for a Company who is a MS Partner Please answer these questions in ...Show All

• Jeff Hosley printing .doc, .xls, and .pdf files from a list of filenames using an excel vba macro

  Hello all! I'm Jim from Western NY. Forgive me if I have posted in the wrong forum. If I have, just let me know and I'll comply. Here's my question: I am wanting to develop a macro for excel which will read (from a worksheet) a list of hyperlinks to pdf, .doc, and .xls files and print them using the appropriate application ( acrobat, word, excel). Theoretically, I know I would have to use some kind of for-next and/or case s ...Show All

• ddas dim as new object at form level or just dim the variable

  Hi, I have been using the ADO data model in an ADP and have used two approaches (both are working) in terms of where I dim the connection and recordset object and where i actually create an instance of them. Here is an example of both approaches i have used: Option Compare Database Option Explicit Dim cn As New ADODB.Connection Dim rs As New ADODB.Recordset Dim rs2 As New ADODB.Recordset Dim intUserid As Integer Private Sub Exit_Click ...Show All

• C-J Berg MS Office document and image writer print driver

  Besides removing this feature from Office during setup, is there a process to remove this virtual printer from 300 users with roaming profiles on an active directory network We are having an issue with this printer assuming the "default printer" selection for our users. As a work around we have changed their default printer, but after they reboot or log off / on it has defaulted back to the MS Ofc doc and image writer printer. ...Show All

• YAWAR Is there a way to select..

  Lets say every 15 entries and get them to display on a chart without having to select them by hand. For example I have 30 cells of data going down a column and I want something that will select the 1st, 15th, and 30th pieces of data. Then have those points displayed on a chart. I am currently using Defined names to get information and auto update my charts but there is so much information that the chart is too squished to see any useable d ...Show All

• Ryan Haney Help with simple program

  Hi, I’m new at this whole thing. I’m trying to help a friend with a macro (VBA for Excel). Its very simple, he has all these country codes on a spreadsheet. We want the program to read the code and the write the country code next to it. We’ve created a two dimensional array with all the codes and country names. Here’s the code: Dim selNum As String Dim trim As String Dim Arr(70, 1) As String Arr(0, 0) = 809 ...Show All

• hedonist 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

• elala has anyone done the tests at all?!

  hi, just wondering has anyone done microsoft ISV software tests   i'm a one-person ISV and i'm interested to hear from others who have been through the testing process.  i've been on the ISV empower program for the last 18 months and i'll be taking my tests shortly.  i intend to apply under the "platform" tests, doing the windows client test, and web services + .net framework.  i read the instructions from the testi ...Show All