Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

-1
votes
0answers
29 views

VB Basic val() function error:overflow

when I use VB Basic function: max=val("100000000000") it is error:overflow. and I use CLng() that is same error happen
0
votes
0answers
8 views

How to add DLL files to visual basic project? [migrated]

I created a visual basic form project, and Im using the circularbar DLL file. I know, that I need to click on the Add references menutab to add it, but when i start the application(.exe file) it ...
0
votes
0answers
49 views

Visual Studio 2017, Visual Basic

I accidentally saved my Visual Basic project while the System date was changed. The date was changed to 02/06/2019. So now It won't make changes in the actual project after I corrected the date (back ...
0
votes
1answer
19 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
40 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
44 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
0answers
16 views

Can I prompt an 'open with' dialog using a VB script?

I'm trying to make a VB script that first prompts the user to choose a file to select, then automatically open the selected file with a pre-determined program. Here is the code I have that does this ...
0
votes
1answer
312 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 ...
0
votes
1answer
1k 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
45 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 ...
0
votes
0answers
24 views

Adding 2nd comment to a 2nd text string in a VBA macro

How would I modify this code to find a 2nd text string ("bbb") and add a 2nd comment [e.g., "my comment #2"] to that. Then a 3rd, and so on. Thanks. Sub CommentBubble() ' ' CommentBubble Macro ' ' ...
1
vote
2answers
1k 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
47 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
33 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
696 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
213 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
4k 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
258 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
67 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
306 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
36 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
77 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
61 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
483 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
151 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 ...
1
vote
0answers
56 views

Embed a batch into a fixed position on a vb program [closed]

I'm new to vb.net and I want to keep it simple, so I'm making a batch game and I want to embed it into a Visual Basic application so that it isn't movable and then add a soundtrack so the game isn't ...
0
votes
1answer
19 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
1answer
277 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
69 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
425 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. (...
-3
votes
1answer
60 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
116 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
74 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
230 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
86 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
491 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
37 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
35 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
20k 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
109 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
55 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
1answer
197 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
225 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
129 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
207 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
1k 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
4k 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
23 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
99 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
746 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 ...