Answer Questions

• Ronaldlee Ejalu ISV application supported by vista

  Hi i want to know the list of LOB's, ISV applications or third party applications which runs on VISTA with out any compatible issues. I haven't seen the final RTM list, but here's a good list to start with: http://forums.microsoft.com/TechNet/ShowPost.aspx PostID=801350&SiteID=17 You might also find some helpful info on http://msdn2.microsoft.com/en-us/windowsvista/aa904987.aspx . -brenda (ISV Buddy Team) Thanks for the post, It is really helpful ...Show All

• dragoncells Excel, fullscreen, taskbar

  I use Windows 2000 Pro and Office XP When I open Excel, all the elements of the application appear above the Windows task bar. (I see the sheet tabs, status bar and task bar) When I select fullscreen (with Application.DisplayFullScreen = True), the status bar and sheet tabs are hidden behind the task bar. Hint: I've found that, when I put the task bar on the left side of the screen and after put it on the bottom, the status bar and sheet tabs reappear above the task bar. But this is not an option for my users, nor is hidding the task bar. First question: Is it possible to keep the status bar and sheet tabs automatically above the task bar, when I select fullscreen option. (with a setup or a macro) When Excel is in fullsc ...Show All

• Pooja Katiyar Application.File Search.

  Hi, If any one has a work around for Application.File Search in Excel 2007 please let me know. This is currently not working in Office 2007. Regards, Digambar. Here is a procedure I originally copied from a forum post by Bill Manville. It starts in the directory D:\TEMP, but you can change that, the procedure uses Dir recursively to put the files into an array for further manipulation. Dim aFiles() As String, iFile As Integer Sub DoIt() iFile = 0 ListFilesInDirectory "D:\TEMP\" ' change the top level as you wish MsgBox iFile & " files found" End Sub Sub ListFilesInDirectory(Directory As String) Dim aDirs() As String, iDir As Integer, stFile As String ' use Dir f ...Show All

• svxtc Once copied, can we export as a GIF file?

  How to convert MS Excel to jpg or gif and paste/insert to MS Word thank you very much     Sorry, my english es basic XL97: Como crear un archivo GIF de un Grafico de Microsoft Excel http://support.microsoft.com/kb/163103/es Esto es cuando ya esta creada imagen dentro de la hoja. Sub creargif() Dim mychart As Chart Set mychart = ActiveSheet.ChartObjects(1).Chart mychart.Export Filename:="c:\Mychart.gif", FilterName:="GIF" End Sub Yes, i need to do this programatically. thanks Jon Peltier wrote: I don't know why everyone thinks it's so hard to copy an image of a region and ...Show All

• R0B Creating MROUND function

  Hello, MROUND is a built-in function in Excel that round a number to a specific multiple. eg. =MROUND(21,5) rounds 21 to the nearest multiple of 5, which gives 20. For some reason this function is not available in my Excel (2003) and so i thought it may be useful to write the function myself using VBA. However i'm not very familiar with VBA so can someone please help me to kick start my first VBA function. Thanks! ps. i've found out after that to add the function all i have to do is go Tools --> Add-ins and tick Analysis ToolPak in the dialog box. magicalclick wrote: About the explicit feature. It may be annoying at time because you have to declare everything. You even have to decalare the variable for the F ...Show All

• JohnBeagan Control Break Trap will not work whilst Userform is displayed

  Hello All, In Excel I have statement Application.OnKey "^{BREAK}", "Sub_Trap_Break" This is okay at all times when there is no Userform being displayed but when there is a form this does not work. Any ideas how to overcome this I am trying to stop users get to the spreadsheet. To stop this I have: 1) Form event Query Close 2) The sheet only becomes visible when macros are enabled otherwise it is xlVeryHidden 3) The cells font and background colours are the same so nothing can be seen ! and it is protected at the appropriate times 4) Menus are disabled But that fact that on control Break (when a form is displayed) the VBE window appears is irritatting, any ideas (No code is displayed as t ...Show All

• Sachi_SG ActiveX 429 error

  Hello, I am trying to export spreadsheets through VBA. I get an ActiveX error. This is the code I have, below. There are no ActiveX references in VBA and Monarch.tlb is referenced. I commented out the previous way of getting and creating the Monarch object to directly find the object with the path but that does not work. What is strange is that 2 users can use the app fine but others cannot. They have the same versions and same desktop. Any help will be appreciated! Option Compare Database Option Explicit Sub MonarchExp() 'On Error GoTo Error_Handler Dim MonarchObj As Object 'original...Dim openfile, openmod, t As Boolean Dim openfile As Variant Dim openmod As Variant Dim t As Boolean 'If Monarch is currently active GetObject will use Mon ...Show All

• snakeoooooo Changes to the forum (a little long, sorry)

  Greetings All, I’ve been hanging out on these forums for a little over a year now and it’s been really fun to see the number of interactions grow along the way. So many of you have stepped up to help fellow coders and ISVs on both technical and business-related questions and it’s great to see happen. That said, I need to share some changes with all of you… including a little background on why they came about. While VBA is not going away in the foreseeable future, the VBA team is now focused on new technologies: VSTO and VSTA . [NOTE: Microsoft has partnered with Summit Software to provide businesses with VBA support going forward.] Up to this point, we were able to tap into an underutilized sup ...Show All

• JillN Automation Error During Execution of Stored Procedure Using ADO

  When the execute statement below runs an automation error occurs. I have tried it with both stSQL strings defined below. Dim cnt As ADODB.Connection Dim rst As ADODB.Recordset Set cnt = New ADODB.Connection stSQL = "Proc1" ' stSQL = "exec Proc1" With cnt .CursorLocation = adUseClient .Open stADO Set rst = .Execute(stSQL, , adCmdStoredProc) End With Any ideas kedst1 Hi, It looks like your missing your connection string in you ADODB.Connection object. Also I'd use a ADODB.Command object to Execute the stored procedure rather than the Connection object. I tried to find an example for you in my books but had no luck so have a search online and your su ...Show All

• hallscreations Can you use VBA to access a spread sheet embedded in a word doc?

  I am trying to use VBA code written in MSWord to access an embedded spread sheet. I can't find any documentation on how this is suppose to work. Does word access the sheet through an instance of excel Is the sheet part of the document so I can find it in the "ThisDocument " I have tried everything I can think of, so any help would be appreciated. Hi Jon, When I test that it leaves the object active and selected. Unless I step through the code in the VBE in which case it does indeed quit it and select the range in the active document. All in all using automation on OLE objects within word is not a fun experience! I can't find any documentation on an msoEmbeddedOLEObject, and wdOLEVerbH ...Show All

• Law Ninja Reading PDF files from VBA

  Hi Does anyone know if it is possible to access the text in a PDF file from VBA, and if so what references etc are required I have a number of multi page price lists from suppliers that I want to work with in Excel, I have tried using the PDF tool to copy text, but when I paste to Excel there are a number of transpostions in the text which make unusable Hi, How we can deploy Acorbat professional on the client side. Are they providing any redistributables   Harish No, they're not. You can deploy Acrobat Pro to your client machines by purchasing the appropriate license. I seem to recall that Adobe offers an API SDK for doing just this. For old ...Show All

• MikePHall sorting in ListView

  Can I do sorting in all columns of ListView Does anybody know Hi, Yes you can sort on columns when using the listview control. Add the listview control to a user form, with this code in the userform code module. You can now click column headers to sort data. Private Sub ListView1_ColumnClick(ByVal ColumnHeader As MSComctlLib.ColumnHeader) With ListView1 .Sorted = True .SortKey = ColumnHeader.Index - 1 .SortOrder = lvwAscending End With End Sub Private Sub UserForm_Initialize() Dim lngIndex As Long Dim vntColumn0 As Variant Dim vntColumn1 As Variant Dim vntColumn2 As Variant Dim lvwItem As ListItem With ListView1 .ListItems.Clear .View = lvw ...Show All

• SoccerDude How do I call for all installed printers....

  Hey, How do I, with vba code, call for all installed printers in my computer and then display them in a ListBox Best Regards Cathrine This is a link PSHK gives me awhile back. It works like a charm. http://word.mvps.org/FAQs/MacrosVBA/AvailablePrinters.htm Have a look here. http://vbnet.mvps.org/index.html code/forms/setlayeredwindowattributes.htm Hey, Thanks for your replies. Excel 2003. If VBA only have the ActivePrinter solution, is there a API call I can use Cath I don't think it is possible to find out all installed printers:(. You can get only the active pr ...Show All

• Kutlu Araslı vba runtime error 59

  I am writing a VBA object in Microsoft Word 2003 which displays a form prompting the user to key in a number. A file is then opened and a GET is used to get the record. The OPEN and GET subroutine are in a module. When I delete the module and re-import the module the object runs perfectly. However if I save and close Word and reload word I get an error "runtime error 59 bad record length" on the line "Get FMKEYS,THREEONE,MKEYSREC". If I then delete the module which and reimport the module it will work fine. Please Help............... Thanks Codes.................... Type MKEYSRECTYPE AKEYNAME As String * 10 ' Alpha key AKEY As Double ' Relative record MKSTATUS As String * ...Show All

• CaRNaGe_46038 command line parameters to VBA in PPT?

  Hi A;;: Is ther any way to pass a command line parameter to VBA within a Powerpoint presentation We'd like to pass a filename into our program from the command line. Is this possible Thanks! amb Hi, I've had a look and I don't think powerpoint allows command parameters. With word you can specify a macro name and all sorts but the same doesn't look possible with powerpoint. The only thing I would suggest is feed the information in through a file. ...Show All