Questions tagged [visual-basic]

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 Visual Basic .NET, a fully object-oriented programming language based on the .NET framework.

Filter by
Sorted by
Tagged with
0
votes
0answers
38 views

Is there a way to load a live video with this code

So I have this code that I run and it plays the vlc file. Set WshShell = WScript.CreateObject("WScript.Shell") WshShell.AppActivate "VLC Media Player" WScript.sleep(200) WshShell.SendKeys " " How ...
0
votes
1answer
89 views

Outlook VBA - A startup macro that moves incoming undeliverable (NDR class) messages for multiple shared inboxes

I have a little experience in Java but barely any in Visual Basic. I need to create a macro for my work Outlook that has 4 inboxes in the profile. One is my name@abc.net, another is for marketing@abc....
0
votes
1answer
134 views

Excel Formulas for Assessing Comissions (Additions) and Omissions (Deletions) in Qualitative Data

I was hoping someone might be able to figure out some formulas (or VBA scripts) for me to help me calculate qualitative analyses. Specifically, I have two columns that look like this: Participant IDs ...
0
votes
1answer
47 views

Make an Image Full Screen

I have a bunch of TVs that are used for digital signage powered by intel nucs running windows 10. I am currently using a Visual Basic Script that works okay but was wondering if there is a better way ...
0
votes
1answer
14 views

Populating Data from a Column Multiple Times in Excel

I currently have a spreadsheet that contains a repeating set of data in specific columns with one field in each row being blank, such as the following: I also have a column of numbers I wish to have ...
1
vote
2answers
91 views

What's the VB code for auto-sorting a range of data based on a text value in Excel?

I have a few columns, important among them being: Tasks, Priority, Status. I want all rows of records where the priority says "High" to automatically update themselves and appear on the top of other ...
0
votes
0answers
4 views

Auto Syntax with Microsoft Visual Basic

I have recently found that my Microsoft Visual Basic is continually auto syntaxing (not just after I press enter, but as I type). I have turned off the Auto Syntax in Preferences, but it is still ...
0
votes
1answer
85 views

Visual Studio: how to disable smart tags in Visual Studio (or change its underline color)?

How to disable smart tags in Visual Studio (2013 Community / Basic)? If it is impossible, how can I change the underline color (for example from red to white)? I mean about 'smart tags' the feature ...
0
votes
0answers
120 views

Visual Studio 2019 Intellisense color-coding / toolbox not working

I have just downloaded Visual Studio 2019 on my Mac and I'm having problems with visual Basic. Visual Studio doesn't color the code that's always white (in my case, for Visual Basic), and also, I can'...
1
vote
2answers
90 views

Excel VBA - Scoping Const Variable to be Accessed only by Current Project

I have an Excel Add-in for storage of UDF's as well as a personal workbook for storage of subroutines. Inside of the Add-in, I have a module for constants, where I have an entry for ideal gas ...
1
vote
1answer
447 views

How to use Excel to calculate concurrent streaks

I want to use Excel to calculate the "best" and "current" streak in a range of data. Say that a shop's sales target for the day is 500. I have a column which contains the daily sales data for the ...
0
votes
1answer
92 views

What does the “Stop script after…” option in WScript's GUI settings actually do?

My understanding is that all of the various .vbs apps are running against wscript.exe I had reason to experiment with a few .vbs scripts, then wanted to manage the running scripts (e.g., list them, ...
0
votes
1answer
71 views

Hotel software opens E-Mail Window in Outlook with generated text - how to change it automaticly to html or trigger a vba script?

My situation: A hotel managment software generates a text and opens a "New E-Mail" Window in Outlook with that text preset. However, I need the E-Mail to be in HTML format, apply some formatting and ...
1
vote
1answer
113 views

How to verify information is entered in cell only if adjacent cell is not blank. Excel VBA

I have two columns, one(B) with a name and the other (A) with a number. I am trying to make it so an error message will prevent me from closing excel if cells in column A are blank but the adjacent ...
0
votes
1answer
519 views

Strange Error with ntdll.dll Windows 7 Ultimate x64 SP1

WINDOWS 7 ULTIMATE X64 SP1 I have recently been trying out a (shareware) clipboard management program called Spartan, which comes loaded with heaps of clever and useful features, but it does seem to ...
1
vote
1answer
7k views

Visual Basic 6 on Windows 10 (Yes, Really)

Is there any way to install VB6 on a Windows 10 machine? I've been asked to revive and move an old company application from an XP machine to a new PC. The code is going to be rewritten in C#, but we ...
1
vote
0answers
53 views

Is there a way to check if a formula's result has changed?

I'm trying to figure out how to sort an Excel spreadsheet after part of the row is filled out. The last cell in a row is a formula to total up some of the other rows. The condition I was thinking ...
1
vote
2answers
4k views

Visual Basic - VBA code to skip or ignore rule if cell contains certain value

I have written the following VBA code to automatically populate column "P" with "pending", "Not due","-" based on the value of column "O". The user will manually have to enter "complete" into column "...
1
vote
0answers
61 views

My requirement is to copy a content from excel, open terminal app, paste the copied content in terminal and execute

I am new to VB - So please guide me [Currently Terminal is opening up, but the focus still remains in excel. I want to paste a copied value in terminal app. guide me guys]. I am using Excel for mac ...
1
vote
1answer
40 views

Convert String to Size | Visual Basic

Using vb. I'm trying to use the text of a combobox as the value of my font size. Means, as a user, I can choose which font size I'd like to have by clicking it out of the dropdown menu. Dropdown menu:...
0
votes
2answers
1k views

Execute Powershell Script from a EXE… Executionpolicy RemoteSigend/Unrestricted, still failing

So i wrote a small VB Program, which runs a powershell script. I know that my ExecutionPolicy has to be set on RemoteSigned or Unrestricted in order to execute scripts on my Computer. So that's what ...
1
vote
1answer
304 views

Export Outlook Exchange folders to windows file system

Currently using A VB macro to pull folders of emails to the windows file system but it isn't able to pull folders stored on an exchange server, Is this even possible? Using the VB script below ' SET ...
0
votes
1answer
10k views

How to automatically import data from csv file and append to existing Excel table

I have a .csv file and a master excel file. The master file contains a table and I would like to automatically append the data in the .csv file to the existing table. The data has the same headers and ...
1
vote
2answers
389 views

How can I animate a “systems thinking” diagram like this example?

I like this javascript based version of a systems thinking diagramming tool. It takes relationships and calculates the values behind it, then animates a dot along the path. So before I get further, ...
0
votes
1answer
70 views

In Excel, how to create a VBA that returns a data range from another sheet when data validation = to a certain choice?

I'm trying to return data (from A1:D14) on sheet 4 into A2:D:15 on sheet 1 when I select "A" on my data validation list located on Sheet 1 cell A1.
0
votes
1answer
545 views

In Excel, Sum hierarchical data based on existence of subdata

I have a set of rows like this that display some hierarchical data. A | B | C | D | E | F 1 Task | | 1 | | 2 | 2 Task | | 1 | | 2 | 3 Task | | | ...
0
votes
1answer
56 views

More efficient way of creating an array of months & revenue metrics?

I am relatively new to VBA and had a question about defining arrays. I am writing a function in Microsoft Access to project five revenue metrics for the rest of year based on the most recent month's ...
0
votes
1answer
84 views

Problems with VB Script

A while back I posted a question asking for a VB script to delete a shortcut "TeamViewer 12 Host" from anyone's and everyone's desktop if it existed. Local not remote. I ran it on my Windows 10 ...
0
votes
0answers
65 views

Visual Basic C++ and Visual Studio Install Problems

my PC has some problems. When I install Visual Studio or Visual Basic, I have to kill dllhost (First problem) to bypass system restore, as I corrupted system restore and pretty much the whole ...
1
vote
1answer
714 views

MS Word VBA Error: “The item with the specified name wasn't found”

I'm trying to set up a macro to adjust the field code of cross-referenced items so that only the numbers show, e.g. 3 instead of Figure 3. I've found online that \# "0" can be added to the field ...
0
votes
0answers
178 views

Microsoft patch : KB3203859 and KB3196718 throwing run time error for Visual Basic application

We have a windows server 2003 VDM, in which VB applications are throwing this run time error: However after uninstalling KB3203859 and KB3196718 Microsoft patches, the run time error is gone. I tried ...
0
votes
1answer
25 views

Develop small shift worker schedule using If, than etc

I manage a small team of shift workers, 2 full time and 3 who fill in on shifts that can't be covered. For a small number of staff I seem to spend a lot of time figuring out schedules (there are ...
0
votes
2answers
453 views

Visual Basic highlighting for Kate text editor

kate supports syntax highlighting for so many programming languages I was surprised when I couldn't find Visual Basic on the list. How can I get Visual Basic highlighting on kate? I know some ...
0
votes
1answer
73 views

Is there a security risk when building an internet radio player in Visual Basic?

I have built a simpel internet radio player in Visual Basic. It contains a couple of buttons and a webbrowser. My firewall asks for permisson to access the internet. Is it safe to allow a homemade ...
0
votes
1answer
653 views

Visual Basic - Import selected rows and columns from Excel

Is there a way to add more than one range of data from Excel to Visual Basic? I have managed to import the cells A6 to B260 into a datagrid, but I also want the columns E6-E260 and G6-G260. (...
-2
votes
1answer
65 views

Automating a series of Microsoft Office tasks [closed]

I am currently doing a series of rather mechanistic tasks and hope to automate them so as to free up my time for other more productive purposes. The series of tasks that I have to do looks something ...
2
votes
1answer
126 views

How can I insert extra spaces to align code in the Visual Basic Editor?

I’d like to add spaces to align the “=” in this: To get something that looks like the alignment of “As” in this: When I try to add spaces to align the “=”s, the Visual Basic Editor removes them ...
1
vote
1answer
81 views

Outlook 2013 Appointment through Visual Basic Excel; 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 company's division easier than the current system. ...
0
votes
0answers
297 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
103 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
599 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
44 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
46 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 see ...
1
vote
2answers
28k 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 ...
1
vote
1answer
127 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
61 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 ...
-1
votes
1answer
244 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
290 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
139 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
232 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 ...