Answer Questions

• callaway59 Is VBA SDK free and ...?

  Hello, Is VBA SDK freeware till v6.x I want integrate VBA 6.x SDK into VB6 software, that I created in university, so it's possible download from where for only studyes I use Visual Studio 6 Professional Edition with SDK. Thank's. P.S. Sorry for my English, it's not my first language. as far as i know - NOT You need to make a special agreement with Microsoft. Conditions of agreement may differ according to your situation. S ...Show All

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

• PauCl AppHung in SQL Server (SQLEXPRESS)

  Good morning, the below is the error I keep getting each time I try to create/connect to a database using Visual Studio 2005.  I upgraded from VS 2003 Professional to VS 2005 Professional.  My OS is XP.  Programming language is C#.  szAppName : devenv.exe szAppVer : 8.0.50727.42 szModName : hungapp szModVer : 0.0.0.0 offset : 00000000  Hi Brent, The engineer needs more detai ...Show All

• Thelockguy Opening a Word file from a macro in Excel

  I have some code that will open a Word document from a macro in Excel, but for some reason it won't recognize the Word file if the folders in the filepath have any spaces in their names. Here is the code: Sub MergeToWord() ActiveWorkbook.Names.Add Name:="MyData", RefersTo:="=Sheet1!" _ & Range(Selection, Selection.End(xlDown)).Address Shell "C:\Program Files\Microsoft office\Office11\winword.exe F: ...Show All

• Arun_Adonis How long this forum exists?

  Hi everyone, My company is trying to integrate VBA into our application. I had some contacts with Summit software ( Microsoft's partner for VBA licensing) some years (2-3) ago. Because we didn't finish our application yet and we're still in process of developing and testing we didn't purchase a license of VBA, but we're going to do it as soon as we finish. The person from Summit software who had contact with me, sent me VBA 6.2 SDK. But I know ...Show All

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

• georgem Is an Excel bug that set PivotItem.Visible to true will generate 1004 Macro Error?

  In a Excel PivotTable, I want to programically hide or show some PivotItems of a PivotField.  To hide, it works fine (just set mPivotField.PivotItems("xxx").visible = False).  However, to show, it does not work: mPivotField.PivotItems("xxx").visible = True.  Program breaks with an error 1004, macro error. When try to record a macro for setting a non-visible PivotItem to visible, macros recorded is to use ...PivotItem("xxx").visi ...Show All

• Daniel Wheeler Report single record in Access 2002

  I'm trying to figure out how to print a single record from a Form in Access 2002. Basically, I would like to be able to click a button on the Form, and it will print out/preview a formatted report for that current record only. I already know how to create the Report, but I just don't know how to link it to the Current Record. Any help would be appreciated. Thanks. I just wrote about this in another post.. ...Show All

• Mahesha Using internal IP Address (Printers) in VBA Code for Excel

  I hope that someone might be able to offer some insight to my request. Currently programming in Excel to print various items that have been developed accross various workbooks and sheets. However, our IT department has different names assigned to printers depending upon the user login profile (different departments and WAN offices). This causes a problem because I cannot hardcode the activeprinter to work regardless of who is logged in. Each pri ...Show All

• Murali Karlapudi EOF or BOF error

  Help! Why am I getting a EOF or BOF error after looping through only a couple of times Do While rst.EOF = False testNo_Rows = rst.RecordCount iPhoneNumber = CStr(Replace(rst("SUBSCRIBER #"), "-", "")) iAmountLoaded = rst("SUBSCRIBER TOTAL") iAmountBilled = iAmountLoaded + acct_Amt_allocate iStampDateTime = Now() rstMobileDevices.Open ("select Phone_Number, User_Id, first(Mobile ...Show All

• Itamarqaz how to read https://

  hi again i was asking before about reading a site, and Radu-Cristian Alexa has gave me a nice object Msxml2.XMLHTTP which is worked Set a = CreateObject("Msxml2.XMLHTTP")     a.Open "GET", " http://www.microsoft.com/ ", False     a.Send     result = a.ResponseText but when i tried it with https site it ignors the site arguments https://www.site.com/page.asp id=xx treated as ...Show All

• Poprocks83 vba in excel

  the table may have more than thirty lines of data, so i need to scroll thru the table until an empty cell is detected. I deleted those extra lines. works ok, just need to change code to name files A1, B2, C3, etc, but do not know how to do so, Hope you can help, will be very much appreciated. i have tried the for next loop but kept looping and looping even past an empty cell. Thanks again John You ...Show All

• FlashFan about listview in vba excel

  hi... can anyone help me..... How to highlight an item in a listview using a textbox or how to search an item in a listview then automatically highlight the item if found It's me again Derek, Derek the commands work well with the listbox but i am using listview. I hope you will still answer me.. Thnx again FSV... Hello again, You'll want to loop over the items in the list until you find ...Show All

• Mark Naughton Best way to promote a new product?

  Started by Bob Walsh at 03-16-2005 11:31 AM. Topic has 2 replies.  03-16-2005, 11:31 AM Bob Walsh Joined on 03-16-2005 Posts 2 Best way to promote a new product We're a micro-ISV and have just released our first product, MasterList Professional , a task and project management app. We've applied for MS Office Marketplace inclusion, but what other ways can we get in front of potential ...Show All

• Manohar K No contact from my buddy

  Started by saint168 at 03-24-2005 12:40 AM. Topic has 1 replies 03-24-2005, 12:40 AM saint168 Joined on 03-24-2005 Posts 1 No contact from my buddy What can I do if my Microsoft buddy never contact me   03-24-2005, 4:21 AM Olaf Joined on 02-14-2005 Posts 2 Re: No contact from my buddy I found this in the FAQ post: ...Show All