Visual Basic is a programming language and accompanying IDE (integrated development environment) from Microsoft. A successor to the BASIC family of programming languages, it focused on ease of use and rapid application development. Support for it ended in 2008 and it has since been succeeded by ...

learn more… | top users | synonyms

-1
votes
0answers
7 views

Display an image instead of a URL to an image in Excel

I have a document that contains a long list of URLs that I would like to display as the images instead. I've tried the VBA code in the thread here: How can I display a URL as an image in an excel cell?...
0
votes
0answers
9 views

Outlook 2013 Appointment through Visual Basic Excell; I want to have an appointment that my calendar says busy and others say free

I'm creating an excel document with a number of different required settings to make the process of logging vacations and business trips in my companies division easier than the current system. ...
0
votes
0answers
37 views

Visual Studio newbie need help making a VB front end to a PS script

I'm a system admin at work and part of the day to day is creating new mailboxes for users in Office 365 and we are forced to use powershell to do this. The only variable in the PS commands is the user'...
-1
votes
1answer
53 views

Excel 2013 VBA script needed for [closed]

I have several cells that have a string of text that are partially Bold and partially NotBold. I need to delete the Bold portion of the Text in the Cells Example: lname1, fname1email1@email.com ...
1
vote
0answers
48 views

Excel 2010 - Combine specific sheet in >200 separate files into single worksheet?

I have tried solutions in other posts like this and so far nothing has worked :/ I have >200 separate excel files, and essentially I would like a specific sheet from each of these files combined into ...
0
votes
1answer
26 views

How do I add one value to a variable every time a date field is null?

In Access 2013, I am working on a report. Using the On print event, I have a problem trying to add one value to a variable every time a date field is null. It works fine somaValores =Somavalores + 1 ...
0
votes
0answers
21 views

Removing “Network Device” which was manually added via script

I have a site on GoDaddy which uses the cpanel software as part of the hosting service. I downloaded their visual basic script to connect to a "Web disk" but now I want it removed. Anyone know how I ...
0
votes
1answer
20 views

View code in Excel - Import_Journals

I'm trying to look at some VB code in an Excel macro. This code is executed on a button click: Private Sub ImportSelected_Click() Call Import_Journals("SELECTED", "IMPORT") End Sub I want to ...
0
votes
1answer
1k views

Install MDAC on Windows 10

I'm trying to install VB6 on Windows 10, I've successfully installed based on a tutorial site in portuguese [http://www.michaelrigo.com/2015/08/guia-definitivo-instalacao-operacao-vb6.html], and now ...
0
votes
0answers
16 views

How to display URL's as Thumbnails into Excel [duplicate]

I am quite new with Macro's in Excel so hope you can support me. I do have many URL's shown in Horizontal lines (B2-E2 and B5-E5) in Excel 2013. What I would like to do is to show the image ...
1
vote
1answer
44 views

Is programming in Visual Basic using Visual studio same as Visual studio enterprise?

Visual Basic is the language, is there a software with the same name? Also, in Visual Studio, you can create Visual Basic projects, but they look different than those created using Visual studio ...
0
votes
0answers
27 views

EXCEL: How can I use a custom function created in VB as formula for conditional formatting?

I created a VB script to validate a personal document from my country (just like the Social Security number in USA). It is BOOLEAN, receives the number as param and returns only TRUE or FALSE if it's ...
0
votes
0answers
126 views

ms access filter subform based on query

Currently I am developing an Access application for reporting in a small office, however, I am having issues filtering a subform with a combo box in the main form. The subform does respond by removing ...
0
votes
1answer
63 views

VB6 application failed to run in another computer

I have created an application on my computer (Windows 7) using Visual basic 6 and it works well. Now when I copied the application to another computer running Windows 8.1, the application was unable ...
0
votes
1answer
53 views

Creating a database in Visual Basic 2010 Express

I'm studying computing and I need to make a program for my project. My project is a fast food ordering system which needs a database. While trying to add a SQL Service Database I get an error message ...
-3
votes
1answer
71 views

Is it better to download and work on Visual Studio than Visual Basic 6 , to work on visual basic? [closed]

is it possible to work in Visual Studio software on Visual Basic language?? and is it even better to work on Visaul Studio than on Visaul Basic 6(VB6) software...?? or is it that Visual Basic ...
-1
votes
1answer
89 views

How to create a macro for microsoft word to concatenate first and last name to generate username

I am trying to create a document in MS word that I can use to auto-generate logins and passwords for my users by just entering in a few details. The form looks like this (sample): First Name: John ...
-1
votes
1answer
358 views

Visual Basic and Excel data streaming in real time [closed]

I'm currently working on a program that runs in visual basic (not VBA). The program collects data from sensors and produces a data file (*.csv) of the information it collected after a certain stretch ...
2
votes
1answer
836 views

Is it possible to sort a table by entry modification date? Specifically, how to access from VBA the last modification time of an object?

I have a MS Word document where I accumulate and frequently modify certain data in a very long table. So I would like to sort the data by latest modification time in the rows. Of course if I add a ...
1
vote
0answers
17 views

content control in Microsoft Word 7

What I require seems simple to me but I'm really struggling to sort it. I need a drop down box (combo box) that has a list containing two values. I want the first value to be displayed so the user ...
1
vote
1answer
78 views

Excel Visual Basic Issue

I've been using VBA quite a bit recently, and, so far, I haven't run into any issues. For some reason, and, I cannot for the life of me figure it out, visual basic wont include "+" or "-" signs in ...
0
votes
2answers
123 views

How do I make a button to add new fields in Excel?

I have a formula which uses a constant. Every time I copy and paste the cells for a new day, I want the constant to update to the new one. I was thinking I could create a button to copy the fields ...
0
votes
1answer
2k views

Excel: Remove only alphabetic characters (retain special characters)

Two datasets to compare. 6701.2345_5432 and on the second the system inserted letters. 6701E.2345_5432 I have about 8000 rows I need to compare and I can't seem to modify the VBA code to ...
0
votes
0answers
209 views

how to transfer file without replacing old files using pscp by vb6

I have an app. when on click it will transfer all text files to server but it replaces the old files. I want to transfer the new files without replacing the old files. here is my code that when you ...
0
votes
0answers
145 views

Microsoft Visual Basic and Adobe Photoshop trouble

I have recently learnt to use Microsoft Visual Basic. However, I closed (by clicking the "X") on the box where the forms could be edited, by mistake. I cannot bring it back. How do I bring it back? ...
2
votes
2answers
3k views

Error Loading VB 6 Project In Windows 7 - MSComCtl2

I can't open my VB6 project on any Windows 7 machine. I did a clean OS install on a machine. The OS is Windows 7 Pro SP1 32 bit. All I have installed on this machine is VB6 Enterprise and Office 2007 ...
1
vote
1answer
8k views

Auto replies for certain days

I have a lazy colleague who always forgets to put her out of office on two days during the week when she is absent. My question is, is there a way via VB or a rule to have the auto replies activate on ...
0
votes
1answer
187 views

Visual Basic has insufficient disk space

I'm trying to download visual basic 2010 Express But every time I click on install button this shows up to me: When I try to select a different destination folder, I get the same error. When I ...
0
votes
0answers
773 views

Ms Access : “Unrecognized Database format”

I have an VB6 project which use the database MS Access 2000. With some electricity problem i lost the database file from project, but with the help of some recovery based tools , i recover the data , ...
2
votes
1answer
170 views

Excel visual basic function across workbooks?

This seems like it should be a common issue, but I couldn't find anything on it, maybe I'm just searching for the wrong thing. Basically I get sent a lot of workbooks that need specific modifications ...
2
votes
1answer
1k views

Macro to insert Comment Bubbles in Microsoft Word?

I have a problem, and I want to know if a macro can solve it: I'd like a macro that can go through a Microsoft Word document, find every occurrence of a text string, and then highlight the string and ...
0
votes
1answer
199 views

Publish XLS document that has visual basic code to a web site

I have a requirement that was asked of me. We have an Excel document that has visual basic code attached to it and it does some computing. The user wants to publish this document onto an intranet site....
2
votes
1answer
162 views

How to register a macro programmatically?

I have like 700 machines in which I need to deploy a new macro we have created. Is there any way to do this via cmd?
9
votes
1answer
68k views

Getting “Msstdfmt.dll missing” when starting Visual Basic 6 application

I need to run an old application written in Visual Basic 6 under Windows 7 x64. When I open it I obtain a message complaining that the library msstdfmt.dllcannot be found. I've tried to install the ...
1
vote
1answer
120 views

Formula for Formatting Date in Excel

I need to make a formula that will reformat a date in excel. My content is as below: Cell E4: 2/15/2012 I would like column E5 to be like this: Cell E5: 15 February 2012 Is there an easy way ...
1
vote
0answers
50 views

Can a C# Client run through a VB Server? [closed]

I was wanting to see if it is possible to make a C# application connect to a Visual Basic Server as I already have a complete engine in VB, I was just wanting to convert the Client to C# so I can make ...
2
votes
3answers
1k views

How can I change default VB script editor

How can I change the default VB script editor in Windows? Is this possible?
0
votes
1answer
2k views

Printing to PDFCreator from Crystal Reports embedded in a Visual Basic Program

I've got a legacy app, written in VB6, using Crystal Reports 8 (not 8.5 - just 8). What I need to do is to figure out how, programmatically, to generate or export a PDF version of a report. ...
0
votes
2answers
53 views

I need more advice on this data addition issue [closed]

I have a test program consisting of a textbox (textbox1), a button (save), and a connection to a database and a table called TestDatabase.mdf and TestTable (respectively). I am trying to save the text ...
1
vote
1answer
720 views

Excel VB Convert sheet text to unicode chars

I need to enter a function in an excel sheet that converts all cells values, that are texts, to it Unicode values. For example I want ü to be ü and so on. How can I achieve this, is it ...
0
votes
1answer
838 views

Errors Received - Should I Install Visual C++ 2005 or 2010?

I wanted to install Rightload and setup required me to install Visual C++ 2005 runtime which i did, but after installation as tried to execute program, i got several error messages (or was it runtime ...
11
votes
2answers
10k views

Minimize all windows on the active monitor

I'm looking for a way to use a keyboard shortcut to minimize all the windows on the monitor that currently has my mouse on it. I found this page: http://vbcity.com/forums/t/163339.aspx but that ...
0
votes
2answers
1k views

Edit strings of exe file with no resources

I am trying to edit some hardcoded textstrings of a simple application called mininotify, because I want to do some translation. The program has been abandoned by its developer some years ago, and he ...
1
vote
2answers
7k views

Opening a file for output/input in Microsoft Visual Basic on Mac OS X

I am working in Excel for Mac 2011 and my goal is to create a simple macro that writes particular cells to a file. This is generally a simple task, but VB chooses not to accept a file path. For ...
5
votes
2answers
17k views

Transform linked images to embedded images

I have imported a HTML report into word by opening it (open index.html in Word) and copy / paste the result as an annex into my Doc. It worked fine, except that all the images (200 of them) are ...
0
votes
1answer
627 views

Tortoise SVN and Visual Basic

I'm about to start using Tortoise SVN with a group of VB6 projects. Some of the class modules in the projects are common to several of them, and I'm not quite sure how to save these in the repository. ...
2
votes
1answer
2k views

What does “32bit apps running in WOW only” means?

I'm trying to run an application made with Visual Basic 6.0 on a Windows 7 64 bit edition. The application is asking me for the DLL vb6es.dll. I have copied this file from a Windows XP into the C:\...
0
votes
1answer
1k views

DTaskManager Runtime '5' error?

I really enjoy using DTaskManager as an alternative to Windows TaskManager, but recently I've been getting Runtime Error '5' messages. It looks like DTaskManager was programmed in Visual Basic 6, but ...
2
votes
1answer
208 views

Returning Shapes to Default in Excel

I have around 70 shapes in a planning document i use for work, everything is fine but i am trying to add a new feature. These shapes are changed using edit points each week to show up on a map, but ...
1
vote
0answers
1k views

Open vbp files with Visual Studio 2010 professional

I want to open a vbp file with Visual Studio 2010. I know that previous versions of Visual Studio have the Visual Basic Upgrade Wizard. Does 2010 have this, and if so, how do I use it.