Answer Questions

• k_rao Opening Ports

  Im sorry if i posted in the wrong place, but i didnt know where to post. Ok well this may sound like a stupid question but, well i have a server on my computer, and i would like to be able to make it online [DNS or whatever its called] so other people could view it, but the problem is that i have a router and such, so there are some ports i need to open to be able to get my server online. If anyone could help me, please do so, it will be much ap ...Show All

• Tim Ward 123 Run-time error 13, "Type Mismatch" in Excel application

  Hi, The following macro functions correctly in an Excel 2003 workbook. However, when I create a copy of the workbook, the macro generates a run-time error 13, "Type Mismatch" when it is run from the copied workbook. Sub print_schedule() ' ' print_schedule Macro ' Application.ScreenUpdating = False Application.DisplayAlerts = False Sheets("Schedule 1").Select ActiveWorkbook.Names.Add Name:= _ "'Schedule 1' ...Show All

• hozzze How do I do to work with two XML files in VBA

  Hi, I'm doing a simple use of XML and trying to display the results in MS Excel. in the moment I have one XSLT that compares datas between two XML files and I'd like to know how to do to view the final datas from this comparation, in Ms-EXCEL, to be worked by other sheets. By now I don't have any idea how to do it (work with 2 xmls + 1 xslt), I already  do transform using an XML and a XSL file and it works nice, but now Coul ...Show All

• Marcus2828 Installing Business Scorecard Manager 2005 on a SQL Server 2005 instance.

  I'm trying to install BSM 2005 into a Win/2003 Server running SQL Server 2005 (everything) and the Web Service won't install because it reports the following: Failed Microsoft OLE DB Provider for OLAP Service (MSOLAP) 2000 SP4 (8.00.2039) as well, the Alerts won't install because of the message: Failed Microsoft SQL Server 200 Notification Services 2.0 SP1 Engine Components I understood that this version was compatible with SQL 2005. Any idea ho ...Show All

• Leslie Gordon VBA WORKSHEET

  COMPILE ERROR END IF WITHOUT BLOCK IF Sub EnterDates() Columns().Clear Dim EilDownloadSheet As Worksheet Set EilDownloadSheet = Workbook.Worksheets("Name of worksheet") Dim startDate As String, stopDate As String, startCel As Integer, stopcel As Integer, dateRange As Range On Error Resume Next Do startDate = InputBox("Please enter start Date: format (dd/mm/yy)", "Start Date") If startDate = &q ...Show All

• RS_Trans how long does it take to get the MSDN subscription? with Empower .. and does it include Sourcesafe

  Hi All, We have signed up to Empower and received our DVD pack but I can not see any information regarding MSDN subscription , this is critical to us, we must have signed up nearly 3 weeks ago now. I also phoned and was told it was going to take about a week.   Dos anyone know how long we are going to have to wait for the MSDN subscription I have emailed LatamISV@microsoft.com  and am waiting for a response but wondere ...Show All

• Kjell Cederfeldt ned help with excel

  i'm trying to insert an image on the top of the excel the code im using is Sub ClearAndClose() Excel.Application.Quit End Sub Sub PrintPriceListF() ' ' PrintPriceListF Macro ' Comments ' ' Keyboard Shortcut: Ctrl+f ' 'Move the header to right Range("A1").Select Selection.Cut Range("e1").Select ActiveSheet.Paste Range("A2").Select Selection.Cut 'Delete the ol ...Show All

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

• Zach Salzbank VBA How to cope with unicode strings

  Hi, I've done an example of what I met when trying to pass Russian character to a string or to a message box. I expect the message box contains "abcde" in Cyrillic alphabet but the result of that are just fancy characters instead. Any help I also changed the regional and language system setting but nothing changed. Many Thanks ********************************* Sub test() Dim strRuss2 As Variant Dim strRuss3 As String ...Show All

• Shanavas VBA Excel/Oracle query and run-time error 3146

  Hello, I have a small VBA Excel app that queries an Oracle database. Certain tables I hit are quite large, and queries on these large tables (with their associated large datasets) cause the following error: "Run-time error 3146" "ODBC call failed" Googling leads me to believe that this is some sort of timeout problem. Here is the code I use (in part, all variables are appropriately dim'd): [code] s ...Show All

• Venu_nair Copy Outlook email into Excel

  I receive an email every day whose contents I have to put into Excel. I'd like to write a macro in Excel that will copy the contents of the email and paste it into Excel. The contents are always structured the same - two columns and 13 rows, and the subject is always the same. I can get the Excel part, but I'm struggling with the Outlook part. thanks! per the support engineer: Please clarify the requirem ...Show All

• Eng. Bajram Fejza Dump data into 2 databases automatically

  Is there a way to dump data into 2 databases automatically So when I enter in data through an MS Access Form, it loads the data into a Table in that database, and then also loads the data into another Table in another database (or Excel file) Essentially, single entry to dual tables. Thanks, Mark JYMark, If your using SQL with Excel you need to use $ to specify that a sheet should be used as a tab ...Show All

• Urip 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)   pgloor wrote: The same will be tru ...Show All

• Waseem Basheer Access 2003 - programming arrow keys with combo box

  On an Access form, I'd like the up/down arrow keys to be used to navigate the values in a combobox, similar to how a listbox behaves. So, for example, if there are five values starting with "M", the user could enter "M" and then press the down arrow key to get to the other entries. Since it's a combo box, the user could also just continue to enter text. I assume I need to program the keypress event to do this, but I'm not ...Show All

• macv3x Run Time Error 216 at <Memory Address> in Excel XP

  This error occurs when a testing is being done on a Win 2000 Advanced Server with Office XP. At the time on closing of all operations, this Error occurs. Sorry the version of Excel is 2002 (i.e) Excel XP The service pack is updated. Theres a VB application that is doing some other job and at the end, its opening a workbook and exiting. This is working fine on other machines except that. Per our support engineer: De ...Show All