Answer Questions

• KasperDk Independent. Sure, but at any price?

  I just posted some thoughts on technology independence in ISV solutions on my blog that I would love to hear the community view on... Hello Michel, I guess we have to identify the term 'platform' before to talk about the independence. Is the platform the SO Database Application server Web Server Framework Business Communication channel My experience says that the 'real' independence doesn't exists at all. We can try to have more ...Show All

• Octurus passing a xml document from Excel to Oracle *urgent help please*

  Hi, the big picture: I have an Excel application that creates a xml document and i have a oracle pl/sql stored procedure that receives that xml document as a parameter (in a form of a CLOB) and inserts it's data into tables. The creation of the Excel is done, as also the pl/sql oracle stored procedure, the thing is i'm not able to pass the xml document into the oracle procedure. I tried creating an ODBC connection and with a ADODB command callin ...Show All

• Bryan Cooper New to VB

  I have to do a project in VB Excel. I don't write code and it has been over 10 years since I took any programming classes. I have books on VB but I don't know where to start. I need to have our main invoice spredsheet update automatically when we get new invoices at the end of the month from our printing service. I know what I want to do but not how to code it. I would appreciate any advice. Thanks, Melissa ...Show All

• g0nzo working with 2 workbooks

  hello, i have a master excel file with a command button which when pressed opens a SLAVE excel file, reads one of the cell entries, closes the excel file, comes back to the master file and writes the data into one of the cells in that. now the reading of the slave file should be done in the background and should not be visible to the user of the master file who clicks the command button. this is what i wrote ... have already done quite a lo ...Show All

• Kiavash Summing on varying number of rows in Excel using VBA

  Hi there, I'm trying to do a sum on a varying number of rows in a column. I have to do this for a number of worksheets but I'm focusing on getting the code right for just one of the worksheets right now (the active one). At the moment the starting row for all data in these worksheets is Row 7. Example: Sheet1 row 7 - 2 row 8 - 10 row 9 - 5 Sheet2 row 7 - 8 row 8 - 12 row 9 - 14 row 10 - 20 row 11 - 4 row 12 - 6 The module is ...Show All

• InKi Park 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

• Seclymer VBA tapi caller ID

  hi wizards, I search for days now, but cannot find any working sample code to do the following I just want to get the telephonnumber of an incoming call (initiate outgoing calls with tapiRequestMakeCall works with a telephone connected to the USB port). I found a lot of code for C or VB, but not a single working one for VBA. Can anyone point my nose to a working sample I just want to recognize the incoming call in my access applica ...Show All

• Nick Ericson - MSFT Need VBA Code Help

  Does anyone know the VBA code to allow formatting within a table inside a protected template in Word 2003. Specifically, being able to allow BOLD type would suffice. Hi Spotty I thought this forum was called "Visual Basic for Applications (VBA)". Peter Mo. These forums are design for VB.NET and not older versions of VB(6/5/4/3/2/1) or VBA which are very di ...Show All

• AllaP Programatically Add Pages to MultiPage Control

  Can someone please provide assistance in adding pages to a MultiPage control programatically. I wish to add pages based on a user's input. Thanks for any assistance. Sometimes the easy ones elude the most. Thank you very much! Hi, this will do it... use the MutiPage control's Pages collection to Add a new page, the first parameter is the name of the new page, the seco ...Show All

• Michael Herman -Parallelspace- Open an excel file

  Hope you will help a beginner .. Here's what I want to do:  In a VBA subroutine, try to open an excel file with a particular name say, P01GAB.xls.  It may not be in the diretory, if not, wait for 10 seconds and try again.  If so, open it and go on to the next thing.  (Eventually, it will be in the directory...)  So, I take it, I need some sort of error trap on the Workbooks.Open command... Thanks much.   ...Show All

• Lisa Slater Nicholls 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. I understand tha ...Show All

• Flip How to preserve the date format while reading Excel cell (Date) in to combobox?

  Hi, How can i display a range of date values from a sheet (A1:A200) in a combobox and preserve the format. When i set the RowSource property to A1:A200 in the combobox, and click on the dropdown arrow it displays the the date values in the correct format, but after i pick a certain value, it chnages it into a number. - Srini. Thanks for your reply. Could you please guide me on how to get th ...Show All

• _Damir_ Custom file description keywords: read/write in VBA via API

  In Windows Explorer, I can select a file, go to properties, and under 'summary', I can input keywords into the description, for use later when searching for the file. I would like to be able to read/write these file keywords via VBA. I assume I need to access the Windows API, but more than that, not sure what library etc. I would need to use. Can anyone advise me how do to this            & ...Show All

• mothballd "unable to get the pivotfields property of the pivot table class"

  this macro works properly: With ActiveSheet.PivotTables("" & tblName & "").PivotFields(" Freq ") .Orientation = xlColumnField .Position = 1 End With Because the ColumnFields can change based on user selection (the selected value is on Worksheets("Hidden").Cells(1, "e") ), so i replace the PivotField value. The code become: With ActiveSheet.PivotTables("" &am ...Show All

• lenaserg Code to call MS SQL Server 2000 SP

  Hi Champs I am .net developer and working on pivot tables/excel right now. I am in position right now that i need to write code to call MS SQL 2000 SP in VBA code. Can u please send me code for this and also any good site for getting VBA code help. Thanks, Hi, You need to use ADO to access stored procedures in SQL Server from VBA. If your used to working with ADO.NET then you should have no prob ...Show All