Answer Questions

• yza suklan 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

• -fej- Our Application meets Client, but no other componant.. HELP

  We are looking to attain ISV status, but the application that we are looking to get approved will only pass the Client test. The Program does not have any other componantsand so will not allows us to attain ISV status unless we modifiy the program to include on of the additional componants. e.g. Web Service/Office/SQL/Managedcode. The program is written in VB6 does a differant set of rules apply Cheers Charli ...Show All

• Sanitario vba5.0 doesn't work on dual core computer with Windows2003 system

  We have tested at Dell dual core computer(PRECISION 670 and OPTIPLEX 620). If we uses Windows XP, it works well. But it doesn't work at Windows2003, even can't work when disable one CPU and disable Hyper-threading. The VBA initialization succeed, but the application crashs at call CallMacro function. I don't know what's the matter with it. Update to VBA6.X seems not easy and also not sure if it can work. O ...Show All

• Pennan Date validation on a form

  On a form that's bound to a table, I'd like to override the standard Access date validation message ("The value you entered isn't valid for this field."). I've coded the Before Update event: Private Sub EventStartDate_BeforeUpdate(Cancel As Integer) If Not IsDate(Me.EventStartDate) Then MsgBox "Invalid date.", vbOKOnly, gstrAppTitle Me.EventStartDate.Undo Cancel = True End If End Sub However, when I t ...Show All

• Purajev Personal.xls

  I have an Access application that opens Excel with GetObject if Excel is closed. On all but one machine in the office things work OK. One of my colleagues has done some development on one machine last week. Since then Excel opens and shows Personal.xls on this machine when called from Getobject. I think this book is supposed to be hidden. Does anyone know how to stop this book loading If you record a ma ...Show All

• Michael B. Parker Left and Right Margins in special cases

  Here is a snippet from my VBA macro: ================================== With ActiveDocument.PageSetup If .RightMargin > 1000000 And .LeftMargin > 1000000 Then .LeftMargin = 0 .RightMargin = .PageWidth ================================== I have a case where leftmargin and rightmargin both are 99999999, and when the .leftmargin = 0 assignation comes up, it is considered out of range by the execut ...Show All

• Alendar how to delete all names in workbook?

  ActiveWorkbook.Names("myName").Delete code above is to detele name "myName" from the active workbook. then if i want to delete all defined names in the active workbook, what would be the code Set nms = ActiveWorkbook.Names For r = 1 To nms.Count nms(1).Delete Next i solved it already. ^_^ ActiveWorkbook.Names("myName").RefersToRange.Cl ...Show All

• renz2k7 How to #include text into a source code? (VBA)

  Hi, How do I include a text from a specified file into a VBA module source code in a project I have three classes that have several common methods and'd like to avoid pasting the same text at three different places. Thanks -- RK These forums are for VB.NET questions. VBA is a very different product from VB.NET and there are some other locations where youy will probably get a quicker and better response ...Show All

• AdamW xcacls.vbs context question

  I'm trying to do something using xcacls.vbs (running locally to a machine): Assuming the share point is d:, I want our domain users to be able to traverse/read only from c: down through to the "d:\folder\admin" folder level, and then be able to create new files and folders, etc, to their heart's content inside admin folder. But not be able to delete or rename the admin folder. For the life of me, I cannot do this with xcacls.vbs. ...Show All

• MMMMMMMMM VBA for Powerpoint

  Hi, I have been asked to modify a powerpoint presentation so that from a series of jpg files, one appears on the screen and then after a specific time period disappears and is replaced by another; this being a continuous loop on one slide only - like a photo tour. I have the following code, but need to get it up and running. Any suggestions: Sub ImportABunch() Dim strTemp As String Dim strFileSpec As String Dim oSld As Slide Dim oPic As S ...Show All

• toolman format field

  hi all how can i use the format function such that the number of dicemal points depends on value read from table any ideas thnx Per the support engineer: We can use Format function to do it. The sample shows how to format a string of a format from a variable. Dim s As String Dim y As String y = "#,##0.00" s = Format(4313413.9234, y) MsgBox s ...Show All

• Crimson_Blah 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. Yesterday, I sen ...Show All

• Zach Griswold Excel edit mode

  How can i detect "edit mode" in excel macros Thank's for idea(s) Hi Denis, Here's the engineer's response to your question: Excel does not provide an interface for outside components to detect "Edit mode" (e.g. when a cell is accepting input), though in Excel itself it can do it. In addition, when Excel is in "Edit Mode", macro will not run. Therefore, if such interface is not provided, it is not ...Show All

• hueys ScrollBars for Userforms

  hi, I want to enable scrollbars for the userforms created during design time. I am adding certain no of controls based on an input during runtime to the userform which was created during design time. I want to have the size of the userform fixed and if the controls are more then enable the scrollbars so that we can scroll and view the controls during runtime. Is there any way to do this regards, sk80. ...Show All

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