Answer Questions

• CoDeR X Important MS Partner Question

  I'm giving serious thought to joining the Microsoft Empower ISV program, but I want to know for sure what version of MSDN and other software I'll get once MSDN Universal goes away.  The Empower ISV website has been recently revamped, but it STILL lists MSDN Universal as the version partners receive.  Since MSDN Universal is no more in about a month, what does that mean for active/new partners My com ...Show All

• WienerSchnitzel Compiling a VBA project is increasing its size

  I have an existing XLA whose size was 970 KB initially, I copied that XLA into MS Office XP\Office10\Library and it correctly showed up as an Add In in MS Excel, now I opened the XLA in VBA and recompiled the project *without* making any changes to it and then saved it; strangely the size of the XLA increased from 970 KB to 1.5 MB, what could be the reason for this , Does the XLA installs itself in the Library directory therby increasing its ...Show All

• mortyqwerty Excel, Forms, and Charts

  I am pretty much a beginner when it comes to VB. I need help with a project I am working on that has me ready to rip my hair out. Here is the what I need to do: When I open a workbook (excel) I want it to display a form where I can enter in the date and various data. I need that form to add that data that I entered to the worksheet in the coloumn that corrisponds with that particular information. It also needs to copy that row's for ...Show All

• Meghraj Shah Someone mind helping me with Error 426

  I am hoping that someone wouldn't mind helping me out here. I have a macro in Excel 2003 which I use to modify some data and then put it into MapPoint 2004. I noticed the memory usage for MapPoint jumps up to 175-180 MB when I initialize territories so I decided I would create a subroutine to close the program and then reopen it. Unfortunately MapPoint 2004 does not let you close a file, only the entire program (unless you are using "Map ...Show All

• Ahmad Shawky EULA for sdk tools

  Hi, I need information about license for sdk and .Net tools. I need two tools from Microsoft to be distributed with my application : resgen.exe from visual studio 2005 and al.exe from the .Net framework. Both aren't installed with the framework 2.0 runtime.   Is there agreement for those kinds of tools Thanks -joel Hi Joel, Since licensing has many variations, I'd sugg ...Show All

• Art102 Getting Excel Formulas to work in VBA

  I have formulas that need to be copied and pasted to the next row down from the original. The problem I ran into was when a formula that refrences some data on a hidden sheet tried to run it will bring up a dialog box wanting to know what file to use to Update the values. I need this formula to work without asking for updates. Here is the formula and the values it wants: Current Excel Formula = IF(M12 > 0, IF(M12 > 7630, ('Conductivity ...Show All

• Boheme Using Excel from Access

  Hi, I am hoping that someone can help me improve the way I am using Excel from Access. I am a poor simple Accountant, and my only training is reading the help filies, and the excellent posts to this forum. I have a number of Access databases which have code to write data into Excel spreadsheets for distribution. Currently, I use the example code from Office 97 which checks to see if Excel is running; if so the code prompts the user to close e ...Show All

• bart165945 RTM - Q3 or late Q4 ?

  Are there any indications of whether VS2005 will ship in Q3 2005 or late Q4 Whilst probable dates used to be "late summer" (september-ish ), recent MS announcements seem to be more vague, suggesting only some time in 2005. This could be as late as 31st December! I have a sizeable project starting soon, which I would prefer to be in VS2005. If however, the RTM date is end of 2005, I may be forced to use VS2003 (would you take the risk& ...Show All

• qbnsoftware Business Scorecard Manager Test Server

  Hi all, (Firstly i hope this is the correct forum) I really hope someone can help mne with this as i'm at my wits end trying to figure out whats wrong. I have just set up a test server with Windows 2003 Server, SQL server 2005 and Business scorecard manager 2005 (All evaluation versions). Having read and followed the installation documentation everything seemed to install with no problem. The problem i am having now is that when i try t ...Show All

• Kari Serial Port Communication Using MS Access VBA

  Need help using MSComm.ocx in MS Access 2000. I have successfully registered the file and have gotten passed licensing issue. However, I am not sure how to use the control to read the data. My code reads: mscomm1.comport = 2 mscomm1.settings = "9600,N,8,1" mscomm1.portopen = true mscomm1.inputlen = 0 buffer = buffer & mscomm1.input (this line of code returns nothing) Any help is greatly appreciated. ...Show All

• Eddie P Help! Math problem

  I am using vb in excel and have run into an issue I can't figure out. Just for testing, I have a form with a button that calls a function: function test() dim a a = 1.09 - 1 msgbox a end function I am looking for the answer to be .09 but I get 9.00000000000001E-02 I have played with it a bit. If I make the equation a = 1.9 - 1 ,I get 0.9 and if I make it a = 1.099 - 1 , I get 0.099. Does anyone know what the cause of this is Thank ...Show All

• Long Tan Problems with Project Server

  Hi, I’m having a problem with my Project Server. Whenever I assign a task to someone and some time later I remove the assignment, the task is no longer asigned to anyone and I cannot delete it. It works like if it’s still assigned to someone. Because of that I have a couple of tasks that are marked for deletion, but i’m not being able to. Does any knows how can I solve this Thanks, Thanks for the tip. Regards, ...Show All

• N.I.C. VBA and VB

  Hello I am not not whether VBA can be used to build stand-alone programs, or the programs built using VBA have to be attached to Office product Thx Yuelin You can not write a standalone app without having the related developed Office application. You can create a Add-In or depending on which app, a xla, dot, etc. but you cant do anything without having the Office application unless you just wa ...Show All

• Marc Rush Trouble signing up for the Microsoft Empower for ISVs

  Knowledge Mgmt. Solutions, Inc. wants to be a Small Business Specialist Partner, so we went to our Microsoft partner page and enrolled and paid the $398.64 on September 6, 2005. We then started looking for a place where our techs could go and take the courses which we were told was either Dallas or Redmond but they were not sure of the courses or course numbers being available. On October 14, 2005, they sent our money back to our bank - no expl ...Show All

• StepUP Help to do macro more dynamic

  Hi, I’ve been trying to help a buddy of mine at work with some macros. But I’m having a lot of trouble figuring out how to do this. 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 is some code: Dim selNum As Long Dim tri ...Show All