vba

  1. mond007

    Bulk attach Album Art to MP3 Track using VBA

    Hi (Apologies if this is a repeat but I don't think so). I have 50gb worth of MP3 files that I wish to attach album art to. They are all in a very thought out directory structure as follows : 01 Religious Music 01 Album01 Religious_AlbumArt01.jpg Track01 Track02...
  2. mond007

    Excel File versus XML Data Load in simple VS Project

    Hi I am writing a Visual Studio application whereby I need to import a simple matrix of 6 columns by 200 rows of data. The scenario is that the user puts in question number and the application looks up the question and display the 5 columns of the answer details, image and hyperlink from the...
  3. P

    Outlook VBA with Communicator API Messenger

    I have a VBA (I know this .NET but I'm desperate) application that synchronizes the Calendar with SQL server. One of the columns in my DB table needs to show the current IM presence status image the same way you'll see it in Outlook or in the Messenger client. I have managed to connect and get...
  4. M

    Question Use Excel VBA variable in VB.NET

    Hello All, I have a third party Excel Application, which have a VBA code, I want to fill the Excel Application from VB.NET. I want to update a VBA Boolean Variable during the Data Filling from VB.NET, is there is any way to do it?
  5. D

    Question Creating add in buttons in Outlook 2007 using VSTO

    I have 2 VBA macro codes that runs well in Outlook 2007. 1.Search and replace text by clicking a button in Compose Mail Window 2.Search and replace text by clicking a button in Inbox Message Window As of now I have the macros working and I need to create an application file to...
  6. K

    Question Invoking a VB.net class from Excel 2007 VBA code

    Hello, We have an Excel 2007 workbook containing VBA code. We need to call a VB.net Shared Add-In project dll Class from Excel VBA code. We tried to include a reference to the dll as an Add-In using Excel->Option->Add-Ins-> Manage-> Excel Add-Ins but it gave error message saying "dll in not a...
  7. K

    Question Accessing the Excel AutoFilter method

    There seems to be some inconsistency between the Excel VBA and the Excel Dot Net object models. I implemented auto filtering via the following code in Excel VBA: Selection.AutoFilter However, when I tried to do the same thing in Dot Net, via the following code, the AutoFilter object was...
  8. R

    Question Need Help with some Advanced Programming

    I am still a beginner programmer so keep in mind that what I'm trying to do is beyond my knowledge but I have no one to teach me Visual Basic except from what little I can learn off of the internet. Currently, I am using Visual Basic 2008 Express Edition so my problem may be appear different if...
Top Bottom