I'm trying to test if a a series of cells exist, and then concatenate the values that do exist with a paragraph I have. [more inside]
So, I just got promoted to a new position at my company (Yay!). Unfortunately, the new requirements involve scheduling a ridiculous number of people. It turns out my predecessor has just been doing dozens of iterations manually until one kind of worked, but every slight change puts a bunch of other things out of wack.
I feel like Excel could probably be capable of doing it, but I have no idea how I would go about designing such a spread sheet. [more inside]
Does this Visual Basic script do what it says? [more inside]
What is the easiest way to make a simple Windows application? Visual Basic? [more inside]
Using Excel 2000, I need to do conditional formatting with 5 options. This isn't possible with actual conditional formatting, but it is possible using Visual Basic. Unfortunately, I know nothing about Visual Basic. Specifics inside. [more inside]
I have a database in Access that is essentially a list of projects and associated tasks. I have a query that lists all projects due in the next 30 days. How can I automatically generate an email from this query? Ideally this would just magically send an email whenever the query is populated with a new project. [more inside]
I'm trying to help out my brother in law automate one of his daily work tasks. It involves going to several authenticated intranet sites, saving the data and then converting it to PDF and saving it to a directory.
I'm wondering what the best way to go about this is. [more inside]
I've been doing COM scripting for about two years, using a Sax-basic scripting application. It was a great app. It allowed line-by-line code execution, error reporting, and debug messages.
I want to start using real VBS so I can port my widgets to a wider platform. I know I can write a script app in notepad and just run it with windows script host, but there's no real debugging there.
Is there any free (or cheap) application that allows you to run VB script in a controlled way? I'd rather not plunk down a month's rent for Visual Studio if I can help it.
I want to teach myself Visual Basic 2008 to help me get ahead at work. I have some questions about how to do it well. [more inside]
Macgyver IT: I want my team to use something like del.icio.us to share links. But since this is ask.metafilter, I can't use the obvious right answer. I need to make something like it myself, using
bubblegum and string
the MS Office 2000 suite and my knowledge of VB. What would be my best approach? [more inside]
I'm looking for a library, package, product or some sample code in either JAVA or Visual Basic that would allow me to create a video from my program. I have some software tools I've developed and I'd like some functionality to my program that could take existing video clips and pictures and then assemble them into a video. I would like the final video format to be FLV however any popular format would do. Any help would be greatly appreciated. Have a great one.
Homeworkfilter: I'm using VB 2008 Express and I need some help with checkboxes. [more inside]
I want to take a small worksheet I created in excel and turn it into a standalone application. How? [more inside]
Visual Basic 6 Filter: Double click on file, my program opens that file. How do I do it? [more inside]
A Visual Basic 6 (ugh) runtime file distributed with our internal Access database has been killed by a recent Windows security update. It's hard to gather support information (especially since VB6 is about 8.7 million years old) and so I was wondering if anyone out there can help me track down a more recent copy of the runtime file in question—msflxgrd.ocx—or otherwise fix the problem? [more inside]
VBA programmers: is there any way to control the formatting of Outlook Contacts Body text? [more inside]
Does any know how to create a script to automatically empty the Outlook secure temp folder when exiting Outlook? [more inside]
Microsoft Excel VBA question: Converting decimal degrees to degrees-minutes-seconds (DMS), with rounding customization. [more inside]
Visual Basic and Excel: How do I replicate the results of excel’s internal function for paired dual tailed t-test in Visual Basic. I tried and failed, where did I go wrong? [more inside]
Visual Basic communities
. Where can I find a supportive community that will help me become a better VB .NET programmer? [more inside]
Best programming language for internal automation? [more inside]
vbFilter: Outputting results to a treeview object in Excel. [more inside]
Can I connect a flash program to a local offline Access database without having to run my computer as a webserver? [more inside]
I have to write a Visual Basic 6 program that checks that an ActiveX control's properties and methods are correctly documented in a Word document. How do I get a list of a control's properties and methods, given its filename? [more inside]
Alright Visual Basic Gurus: Do your worst! Why Can't I Loop? (VB6) [more inside]
After spending so many years in *nix environments, I need to get up to speed with Microsoft products (specifically vb.net) without losing my sanity. [more inside]
How can I bundle OCXs, DLLs, and other required files with my Visual Basic application? [more inside]
Last Minute Visual Basic 6 Help!!! How do I compare a given date to today's date, based on a number of months? [more inside]
How can I import selected fields from one database into another database? [more inside]
It's not how I'd choose to spend my Friday evening, but for the last few hours, I've been trying to replace carriage returns that have turned up in an Access and Excel file, and drawing a blank. [more inside]
What are good free programming language learning environments? [more inside]
Visual Basic 6.0 and Access 2003 question.....(more inside) [more inside]
Is there any way to make Excel macros less stupid? [MI] [more inside]
If you were writing a new p2p application -- leaving ethical and legal issues aside for a moment -- which programming language would you use? I know Visual Basic and PHP, but neither is really any good for this purpose. I dislike things that require the user to install a big VM (.NET, Java) and find C++ a complete nightmare. [more inside]
Musical notes in Visual Basic 6.0: I wrote a program that writes random songs, and I'd like it to be able to play them, so I don't have to plunk them out on my bass to know what they sound like. [more inside]