Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.
Visual Basic Classic
Articles & Videos
Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.
I've got some old VB6 code that's been maintained by a bunch of different people over the years (bet you've never heard that one before!). I know there are a handful of modules that are no longer used…
I need some quick help again,
bmName is a variable that loops through Bookmarks, and I need to check that when bookmark "side1" or when bookmark "side2" is bmName then it should do …
I read the dialog between your expert OMGang and the author of the procedure "Public Sub Draft_Message()" which seemed to me almost exactly what I need in order to send mails with an …
I want to copy from 1..n excel sheets, all in the same folder named: WVS_2015_02_01.xls .. WVS_2015_02_28.xls from sheet 'MyData' the content of cell range E31-E51 to a destination …
I use the following procedure in order to copy range dynamically based on a config sheet:
I use the following procedure in order to copy specific …
Why am I getting an error "Sub or Function is not defined"...Here is my code
Form 1.....Call my function "printReport" here
The error message goes here "Private Sub …
I have run into an issue that I cannot seem to get any information on.
I have a Mobile page designed, for membership.
The Form has a date selector on it, with type="date"
And it is not …
When I run myprogram.exe it shows "Publisher: Unknown".
How can I add my company name so it displays, Thank You
we receive about 3000 emails (invoices) a day with pdf attachment each with a different format we need to open them check 5 fields, based on those fields copy paste (save attachments) to respective …
A company’s greatest vulnerability is their email.
CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of …
I would like to to scroll into Picture2 using my mouse wheel. So far i was using the VScroll1.
How can i do that?
Thanks for your help.
So far, i was doing:
I am attempting to use RUNRMTCMD to fire a visual basic script that uses Excel automation. I want to open an excel file and saveas .csv and/or .pdf.
I have gotten this to work while running the …
Using VBscript & RegEx, how can I match lines starting with Oracle word in the below sample:
"OracleJobScheduler" check 12 TEST
Hi Guys, I have got an Excel attachment which I am trying to do a VLookup on, but instead of showing the result, it shows just the Vlookup formula. Anyone got any ideas why? In the attached, in cell …
Need email sent automatically when date is entered in any independent cell in column E3:E45.
(Edit: Added CODE tags)
I'm looking for the best way to automatically email out a report everyday. I have an excel file with some vba code on it. There is a macro setup to run a procudure on the excel file. I need to have…
Using Visual Basic 6.
FileDateTime only gives the Date Modified.
I need to read the Date Created and have it work on XP, Vista and Win7.
The FileSystemObject seems to warn about compatibility …
Kindly find the Sample Data for 8 files and 8 .csv sample Files attached.
In the attached Excel File
---Basic Data is in Columns E:AI
---Data is always Sorted as per Column AJ
I managed to get the data in a Array:
Fielddata = SQLdata.Fields(2).Value
wscript.popup Ubound(Fielddata) 'result in a big number
I tried this :
Dim dom: Set dom = …
How do you exclude a sub directory that is included in the selected directory
The code below excludes files
Dim sa As New CkStringArray
dim sTemp as string
Hi, I am trying to figure out a scheduler task I can inject via group policy that will run as follows:
Will run daily and do the following:
Check the system uptime and if uptime is greater than 14 …
I have a fairly complex macro which concludes as follows -
Currently the section under ############## is validating the boll rates against the worksheet 'Ratecard' …
I need some code to create FILES for the Selected Range
--Name as per Column G
--File extension as per Column H
--in Folder given in Column I
Sample file is attached.
Using Regular Expressions in VBA and VB6 Projects
By Patrick Matthews (matthewspatrick, http://www.experts-exchang
The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture. There…