Answer Questions

• Sundown Kid compiler for VBA application?

  MY partner and I have a VBA application that runs as an Excel Add-in.  Is there a compiler that would allow us to distribute this (license even) without giving away the VBA source code Hi! You can write a VB6 or Office Develper project and make a DLL. The VBA password is, hmm, I will not write down the words that come to my mind... I need 15 seconds and my hex editor to completly remove any pass ...Show All

• AnneF Strange Error

  I have an Access 2002 SP3 DB and on occasion it seems to corrupt and all forms are no longer accessable any 1 else had this problem i am unsure to what causes it so cant fix it. i open it and it reports a corrupt error offten after a change to some code has been made and saved i always test before before closing so i know it works fine then on next load it corrupts and the MDB file is reduced to only half its original size. any help or adv ...Show All

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

• ScottM124 Problem: Code not in line with slide shapes

  Hi, I really need some help here. I have created an add-in that gives user’s a basic wizard to create presentations from scratch [which can also be used to modify already created presentations]. I have coded the add-in based on the Layout Text (ppLayoutText) which has two text boxes: a Title text box and a body text box. I have two text fields on my form that allow users to enter text. Those text fields are linked to the two text boxes on t ...Show All

• jvanderbeek Necessary Processes???

  I have WXPHOME SP2. I currently have 63 processes on my startup. Is there a list of necessary processes so I can delete the rest I attempted to search each process on here but most of them didn't show up. Help Hi, This forum is actually targeted at Independent Software Vendors... specifically, those companies who build software applications and solutions on Microsoft technologies. You might want to visit http://www.microsoft.com/w ...Show All

• agos transaction processing in an Access app?

  In an Access app, is there the concept of a transaction, with "start transaction", "commit", and "rollback" If so, how do I implement it in VBA My app will have a main form withfour subforms on it. It will also have a Save button and a Cancel button. I would like to start the transaction when the main form is loaded, and commit only when the user clicks the Save button. The Cancel button would trigger a rollback. ...Show All

• Jeremy Cantrell I dont know whether you have come across this..

  I wrote a vba code sometime ago and i was happy with the way it worked. But i was really surprised to find that the same code doesnt work now. Well, you might be familiar with this "subscript out of range", but what i dont understand is, the same code worked like 4 weeks back on the same pc without any change in the windows/office version. One of the solution that i was suggested was, to put all my code under modules ...Show All

• anujmathurhere Excel 2003 Macro to VB .Net v7

  All,   I've seen bits and pieces of this topic, but not enough to get me there, so here's my situation.   I've created a set of Macros in Excel 2003, that I want to turn into a .exe that can be called from a DOS window with a set of command line parameters. I would think the first thing that needs to be done is to save the Macros as a VB Project, but I don't see how that is done    I would then think the next thing that ...Show All

• Bernybon UTC Dates

  Help! I need to convert long integer UTC dates to actual formatted dates.  Is there anything in Excel that can be used to accomplish this Thank you! Shawn. Per one of our support engineers: I found that Excel does not have a built-in function for this. However, UTC date has fixed format and we can refer to the following article to see how to convert it. UTC date format Converting WMI Dates to a Stand ...Show All

• RobKor Automation to send a Microsoft Outlook message using Access 2000

  I'm trying to send an email from my Access 2003 database, using MS Outlook. The users must have the ability to attach a file that resides on the network share drive. I have a field that holds the path to the existing file. Please Help!!! Everything out there is referencing libraries that I do not have. I'm currently referencing Microsoft outlook 11.0 Object Library. Per our support engineer: Base my unders ...Show All

• ye_xiyong deleting record

  Do Until rst_local.EOF CurrentLevel = rst_local("Level") CurrentDeptId = rst_local("DeptId") LevelUp1 = "L" & CurrentLevel - 1 & "_DEPTID" LevelUp2 = "L" & CurrentLevel - 2 & "_DEPTID" Set rst_pplops = dbs.OpenRecordset("SELECT " & LevelUp1 & "," & LevelUp2 & ",Dept_Level,EFF_STATUS,DeptI ...Show All

• Jan Pickard Is an Excel bug that Excel refuse to set PivotItem to be Visible?

  In VBA, setting any PivotItems of a xlPageField orientation PivotField to be visible works fine.  However, setting any PivotItems of a xlRowField or xlColumnField orientation PivotField will refuse to run. Furthermore, if we use the UI to set any PivotItems of a xlRowField or xlColumnField orientation PivotField will work fine. My question is: Is an Excel bug that Excel VBA refuses to set PivotItem to be Visible if the PivotIt ...Show All

• Danny NG 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

• Mehul Thakkar Custom button on control bar

  I have a custom contorl bar button and it is connected to an addin. When my addin is first loaded the button is first displayed in the middle of the screen. I then need to drag it to the control bar. Is there any way I can code it so that it goes straight to the control bar and not in the middle Note: I have also asked this question at http://www.ozgrid.com/forum/showthread.php t=51966 Thank you ...Show All

• Jia_1999 Is VBA SDK free and ...?

  Hello, Is VBA SDK freeware till v6.x I want integrate VBA 6.x SDK into VB6 software, that I created in university, so it's possible download from where for only studyes I use Visual Studio 6 Professional Edition with SDK. Thank's. P.S. Sorry for my English, it's not my first language. Although the VBA SDK is available at no charge (it's part of MSDN subscriptions and available for download on MSDN), in order to redistribute ...Show All