35 posts tagged with visualbasic.
Displaying 1 through 35 of 35. Subscribe:

Excel Filter: IF Statements and Concatenate

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]
posted by trogdole on Aug 7, 2014 - 10 answers

Help me use Excel to save my job

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]
posted by cacofonie on Jun 19, 2014 - 17 answers

Microsoft Outlook 2010: calendar reminders via email

Does this Visual Basic script do what it says? [more inside]
posted by paleyellowwithorange on Jun 26, 2013 - 3 answers

What's the easiest way to program an application?

What is the easiest way to make a simple Windows application? Visual Basic? [more inside]
posted by dkleinst on Aug 9, 2011 - 11 answers

I have too many conditions for Excel

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]
posted by jeather on Jul 22, 2011 - 23 answers

Automatically generating an email from a query in Access

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]
posted by desjardins on Dec 10, 2010 - 8 answers

How do I automate the conversion of a HTML page to PDF?

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]
posted by daHIFI on Sep 10, 2010 - 7 answers

Is there a free/cheap execution/debugging environment for Visual Basic?

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.
posted by clarknova on Jun 3, 2010 - 3 answers

Visual Basic 2008 resources.

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]
posted by jsturgill on Feb 8, 2010 - 9 answers

MacgyverFilter: link sharing using MS Office

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]
posted by Monday, stony Monday on Nov 19, 2009 - 7 answers

Creating video from a program help

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.
posted by JohnGL on Jul 9, 2009 - 7 answers

Visual Basic hates me: [x]yes []no

Homeworkfilter: I'm using VB 2008 Express and I need some help with checkboxes. [more inside]
posted by icarus on Jun 24, 2009 - 2 answers

Help me make sense of excel and VB

I want to take a small worksheet I created in excel and turn it into a standalone application. How? [more inside]
posted by icarus on Jun 5, 2009 - 5 answers

Double Click Me All The Way To Heaven

Visual Basic 6 Filter: Double click on file, my program opens that file. How do I do it? [more inside]
posted by Brettus on May 18, 2009 - 6 answers

How do I replace a Visual Basic 6 runtime file killed by a Windows security update?

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]
posted by bcwinters on Mar 9, 2009 - 8 answers

Stupid Outlook! No cookie!

VBA programmers: is there any way to control the formatting of Outlook Contacts Body text? [more inside]
posted by IAmBroom on Feb 2, 2009 - 0 answers

How to automatically clear Outlook secure temp folder?

Does any know how to create a script to automatically empty the Outlook secure temp folder when exiting Outlook? [more inside]
posted by paulyballs on Dec 9, 2008 - 1 answer

Decimal seconds, please.

Microsoft Excel VBA question: Converting decimal degrees to degrees-minutes-seconds (DMS), with rounding customization. [more inside]
posted by dondiego87 on Jun 10, 2008 - 5 answers

Can't calculate paired T-value in Visual Basic

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]
posted by JeNeSaisQuoi on May 16, 2008 - 8 answers

Visual Basic Communities

Visual Basic communities. Where can I find a supportive community that will help me become a better VB .NET programmer? [more inside]
posted by grahamwell on Dec 29, 2007 - 4 answers

Fed up with Microsoft (.NET)

Best programming language for internal automation? [more inside]
posted by jjsonp on Dec 9, 2007 - 21 answers

VB in the tree

vbFilter: Outputting results to a treeview object in Excel. [more inside]
posted by dnthomps on Oct 21, 2007 - 1 answer

Stupid database! Be more connecty!

Can I connect a flash program to a local offline Access database without having to run my computer as a webserver? [more inside]
posted by Brainy on Mar 20, 2007 - 5 answers

How do I get the names of an ActiveX control's members?

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]
posted by matthewr on Jul 20, 2006 - 2 answers

Loops, Loops, Loops

Alright Visual Basic Gurus: Do your worst! Why Can't I Loop? (VB6) [more inside]
posted by fvox13 on Jul 6, 2006 - 9 answers

VB? WTF? :(

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]
posted by (lambda (x) x) on May 17, 2006 - 10 answers

How do I make my application work on all computers?

How can I bundle OCXs, DLLs, and other required files with my Visual Basic application? [more inside]
posted by fvox13 on May 9, 2006 - 4 answers

Visual Basic 6 Date Comparison by Month

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]
posted by fvox13 on Apr 5, 2006 - 4 answers

How do I import from one database into another?

How can I import selected fields from one database into another database? [more inside]
posted by fvox13 on Mar 16, 2006 - 6 answers

Carriage Returns in Excel

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]
posted by godawful on Feb 10, 2006 - 9 answers

What are good free programming language environments?

What are good free programming language learning environments? [more inside]
posted by pracowity on Dec 30, 2005 - 41 answers

Visual Basic 6.0 and Access 2003 question.

Visual Basic 6.0 and Access 2003 question.....(more inside) [more inside]
posted by ttrendel on Jan 26, 2005 - 3 answers

Is there any way to make Excel macros less stupid?

Is there any way to make Excel macros less stupid? [MI] [more inside]
posted by squidlarkin on Jan 5, 2005 - 15 answers

p2p programming languages

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]
posted by reklaw on Jun 2, 2004 - 36 answers

How to get computer to play my songs written in Visual Basic 6.0?

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]
posted by alex_reno on Mar 20, 2004 - 12 answers

Page: 1