Answer Questions

• Ivan S Read data from excel through VB.NET

  Hi friends, I need to read symbols(like ALPHA,BETA,MEU) from excel and show it in a data grid through VB.NET.Later insert it into Oracle 8i DB. I am able to read entire data but i am getting 'a' instead of ALPHA symbol and 'b' instead of BETA symbol. I am querying excel via OLEDB provider.The following snippet is using for accessing excel. Dim MyCommand As System.Data.OleDb.OleDbDataAdapter Dim MyConnection As System.Data.OleDb.OleDbConnection ...Show All

• CentrixGuy MS Access key problem

  I'm doing a little work for a lawyer that has an Access VBA system to handle billing and printing of some legal documents. I am not an Access VBA expert; I'm a C++ expert who has picked up a few Access skills. When his secretary adds a new client, she has to pick a record key, which they call MGMT_CODE. It is a four-character text field. Most of the existing MGMT_CODEs start with 0 and consist of four numbers. Some of them start with 9, though, ...Show All

• Hok Peng 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

• Greg P. Certification of web based applications

  Hello, After attending an ISV community days seminar I didn't not get a clear answer on how to test and certify a web based application. We have created a software-as-service application where the customer only gets a username and password in order to access the application through a web server. I was wondering if we need to send both server components and frontend of the application to veritest or only a username and password so they can login ...Show All

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

• Discoman What version of Team System do EmpowerISV members get?

  Current MSDN Universal subscribers get a free upgrade to their choice of one of the Team editions of Visual Studio 2005 when its released.  What about current EmpowerISV members   And what will future members get   I'm planning on joining the program, but I want to be sure I know what my team will be  getting long-term, especially as it relates to Visual Studio Team System. The Empower prog ...Show All

• Mircea Cimpoi Setting Chart Title through VBA sometimes works sometimes doesn't.

  Hello folks, Wonder if anyone has the solution to the following problem. Got an Excel addin that the user can use to generate Charts. The users are very lazy and want the addin to set the titles for the chart as well as for the axis. When I tested the code everything works fine and the charts including it's titles are set. Everyone is happy. However in certain spreadsheets the code throws an error. Method 'HasTitle' of object '_Chart ...Show All

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

• A_Martin How to refer to an object by the tab index

  Hi, I'm trying to crease a function to disable the next 'n' fields in a form if called. The easiest way to go about this seems to be by using the tab index numbers to refer to the 'n'th control. However, I can't find any way of going about this. Or is there an easier way Please help... thanks sorry... in access Per our support engineer: I think we can enumerate the ...Show All

• Yankee "Building Custom Report Views Webpart"

  Hi, I downloaded "Building Custom Report Views Webprt" white paper from the Microsoft site and tried implementing it. I intially created a Windows Control Library project and created a usercontrol. I built this application in to a DLL,created a strongname to it and then put this asembly in GAC. I then created a pmbuilder.exe.config file in the location given below. "C:\Program Files\Microsoft Office Business Scorecard Manag ...Show All

• LeBlah Detect Excel Version in VB6 Application

  Hello Everybody I need your help, I have and application in Vb 6 and I need detect what's version and language of Excel have install in the computer. Help me.... thanks Ifgash Ifgash@yahoo.com Hello Ifgash OK for the version you can do something like that. If you have set a reference to MS-Excel in VB6 such as: Set appExcel = New Excel.Application then you can use: appExcel.Version a ...Show All

• SonaliB Welcome to the new ISV Buddy Forum!

  Started by Brenda [msdn/isv] at 03-22-2005 9:51 AM. Topic has 0 replies. 03-22-2005, 9:51 AM Brenda [msdn/isv] Joined on 03-16-2005 Posts 6 Welcome to the new ISV Buddy Forum! Welcome to the new ISV Buddy Forum! I envision this forum as an opportunity for broader communications among the ISVs in the program, and for stronger collaboration among the program members. This forum will also en ...Show All

• Adrian Russell 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

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

• Randhawa app_sheetbeforedoubleclick exists?

  Hi, I'd like to capture doubleclicks on cells in all workbooks so I assume I should use a class module. (my app_... procedures work well for other purposes) I'd use the procedure: Private Sub App_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, ByVal Cancel As Boolean) according to the help, but when I try to compile it says: 'Procedure declaration does not match description of event or procedure having the sam ...Show All