Answer Questions

• January Hding your vba code

  I have also asked this question at http://www.ozgrid.com/forum/showthread.php t=52001 I have created an addin and it will be sent to other people (number unknown). WIll the people who have the addin be able to view my vba code behind it [the addin] Is there any security measures I should take to be on the safe side Thank You Hi, You can password protect your code very easily. In the Project Ex ...Show All

• IvanLieb Extract code from .dot

  For some reason, (really not sure why, but it happens every now and then on my company's PC) my normal.dot file containing a few years' worth of customisations and home-grown macros was reset to the default a few days ago. My backup normal.dot has the toolbar customisations and lists the macros in the Tools>Macro>Macros window, but they do not run. ("Could not load Macro storage" error.) I can see snippets of the macros when I lo ...Show All

• Matt_chrs Using of APC.IDE.PreventShow property

  I have integrated VBA 6.2 into my application. All works normal, but I have a little problem. To prevent VBA IDE to be shown when VBA runtime error rises, I set APC.IDE.PreventShow property to True, so this successfully overrides error displaying (and stops vba code execution), but doesn't give me any sign of this (in other words I can't catch any event reporting me about the error generated by VBA). Can someone help me to handle to problem Tha ...Show All

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

• fums64 Macros - Excel

  Hi, I have made a macro for a project which i am working on. I have to run this macro every week on different files. These files have names which include the date of the data. Now without overwriting this file i want to run the macro but want the date of this file to be included in the final file which i have made. Is there anyway to do this for eg: Data file : Name : ABC 10-3-06 i want the final output files name to be : XYZ 10-3-0 ...Show All

• Ian Gitlin Display a drawing on an MS Access Form

  Hi there i would like to display a drawing (test.dwg) on my form in a vb code. The form has an Bound Object Frame - OLE1 area. So when the i press an button it should display the diagram itself (not the link) inside the Bound Object Frame and be able to zoom in and out and edit. Thank you AT the moment i'm getting only the icon and file name displayed in the OLE1. When i click on the icon then it opens up the ...Show All

• Lornita_Kong Protecting the Source Code

  I have a couple of spreadsheets that have VBA code in them. I wish to share these projects with other employees but I am leary of doing so because I don't want them to claim the work I did as their own or screw it up somehow. Is there a way I can protect my code Is there a way to insert a digital signature that others can't edit Thanks Tiger Hey Derek, Thanks for the info. Once again you have the ...Show All

• Worachart VBA Shell Function / Windows API Createprocess

  I am trying to use the Windows API CreateProcess() to start a program within a VBA application. I have hit problems. Now going back to basics and trying to launch program, with parameters, from the VBA shell function. The appication starts sucessfully without the parameters ie Retval = Shell("C:\Program Files\FastCut\FastCut",6) Including parameters Retval = Shell("C:\Program Files\FastCut\FastCut 12345.txt,1,5& ...Show All

• PeterBrown So Software as a Service is the next big thing – again?

  I want to get a discussion on Software as a Service (SaaS) going among the ISV architecs. I just posted some initial thoughts on SaaS on my blog that I would love to hear your view on... Do you already do SaaS or have plans to do so next 12 month What are your main architectural concerns/issues/questions around SaaS What are the most important architectural topics that you would like to see guidance on first What are the most imp ...Show All

• Ken Schlobohm Help required.....

  Can someone help me please I am trying to create a VBA User form to open up individual Spreadsheets rather than having to have all the sheets open (as with a workspace). I have designed the user form and now need to code the command_buttons. However I am stuck with what code I need to use. If it helps, I need to program 7 buttons, 6 will open spreadsheets and one will open a MS Project file. This is fairly urgent as I have to have ready ...Show All

• Mike Wachal 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

• ciboys how to change the picture when i change the combobox selection?

    I designed a OUTLOOK form . There is a combobox control which list cities . I want to add a image control and text control that can show the picture of the city and a breif description of it. when people change the combobox selection, I want the picture changed to the the responsible city pictures and the breif description. How to do that     ...Show All

• BillDude Execute String as code VBA

  Hi all, I am working on an Excel project with huge amount of VBA classes and modules. My question is how can I execute a line like: Dim tmp as Variant Call ExecuteLine("Set tmp = New " + ClassName) ' Where ClassName is a string of a certain class name Since the number of classes are large and there are new classes being inserted constantly, it would be very nice to have this two lines of code rather than many lines of Switch ...Show All

• R2B2 What about Sourcesafe now too?

  So Empower and Certified partners will not get Team System.  That also screws us up for Sourcesafe doesn't it I quote from the MSDN site ( http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnvs05/html/VSTmSysvsVSS.asp ):   The desktop-based nature of Visual SourceSafe 2005 lends itself well to scenarios where team members may need occasional remote access to files. However, it is not intended for day-to-day usage by a ...Show All

• MohamedHanif Run-time error 3706:

  We have front end application which is developed in PB and resides on Citrix server. One of the module in PB application opens a screen which is developed in VBA. When we upgraded the citrix server and Ms Office on the server to higher version, the module which is developed in VBA is not working and gives the following error.   Run time error – 3706: Provider cannot be found it may not be properly installed.   Here is ...Show All