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...

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...

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...

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?

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...

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...

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...

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...