Stack Overflow
Stack Overflow

Questions tagged [vba6]

Visual Basic for Applications (VBA) is an event-driven, object-oriented programming language for writing macros, used for the MS Office suite as well as other applications. VBA is not equivalent to VBA6, VBA7, VB.NET, or VBS. If your question is specifically about programming any MS Office application, also use the appropriate tag: [excel], [ms-access], [ms-word], [outlook], [powerpoint] or [ms-project].

Visual Basic for Applications (VBA) is an event-driven programming language which was first introduced by Microsoft in 1993 to give Excel 5.0 a more robust object-oriented language for writing macros and automating the use of Excel. The language and its runtime quickly matured and began being used in products beyond Microsoft Office applications.

Differences between VBA 6.0 and VBA 7.0?

There's not a whole lot that has changed between VBA6 and VBA7. VBA7 was introduced to support 64-bit versions of both Office and Windows while VBA6 only supports the 32-bit versions of Office.

Reference

Differences between VBA 6.0 and VBA 7.0

139 questions
0
votes
1 answer

sending a mail with attachment through excel

Sending a mail with attachment from excel in vba works most of the time, but sometimes "d.docs.live.net" is added to this attachment, with result that this attachment cannot be found or/and is unreadable. PS. Cortana doesn't work in my region. I…
EVL
  • 1
  • 1
0
votes
1 answer

Custom lookup using search in VBA

I am not sure, how to fix this function. if Isnumber(search) is true, then get value from lookup_table after 2nd round, it ends Image of excel data Function Slookup(lookup_value As String, lookup_table As Range) As String Dim i As Integer On Error…
KrazyAC
  • 13
  • 3
0
votes
1 answer

sort two dim array which is declared as one dim array and inserted values as array()

I'm on dead end which I am no able to figure out even google up :( Let's say I have this exemple (please do not comment that it might be better ways to create such an array, this is on purpose): Dim someArray() As Variant: ReDim someArray(0 To…
Jiri Zaloudek
  • 326
  • 3
  • 19
0
votes
0 answers

How to limit range of columns from a table with VBA and Access in a select case structure

I have the code below and I need to import the data from a table in the range of "A:K". Function ImportExport(ByVal template As String) As Boolean Dim Name As String Dim Code As String Dim table As String Dim Sheet As String …
Flash
  • 85
  • 10
0
votes
0 answers

Why is my excel vba code throwing error when the count of rows for a particular data increases 16?

I have a vba tool which analyzes the excel data and counts the number of data for a particular person and prepares powerpoint reports by pasting the comments for each person based on it. I have noticed, the tool throws error when the data count…
LearnerP
  • 1
  • 1
0
votes
1 answer

Can I compile old Excel COM Add-in code written in VB6.0 to work in 64-bit Excel?

I have code for an excel add-in I wrote over 20 years ago that I find myself needing again. It works fine in Windows XP and Excel 2003 in a virtualbox. In the VB6.0 IDE, I can load the code and make the dll which I can register as an excel add-in…
snowguy
  • 899
  • 2
  • 13
  • 23
0
votes
0 answers

GET Request fails to show complete response when done through VBA but working on Postman

I am working on making a report for my company that takes values from a GET API request and cross compares received values against values received from elsewhere. The problem I am facing is that the GET request works perfectly on Postman but returns…
Aldrin Thomas
  • 1
0
votes
1 answer

How to move text between tags to new document word from excel vba

I have a long list of word documents which all have three pages. now i want every fist page in document 1, every 2nd page in document 2 and every 3rd page in document 3. I have tags on every page in my word document but every page has the same tag.…
Daniël Vegter
  • 7
  • 3
0
votes
4 answers

In VBA trying to create a dynamic Sumifs Formula with multiple criterias in multiple sheets

In VBA I am trying to create a sumifs formula with multiple criteria across different workbooks, but I am struggling on the syntax. WorkbookRecut.Worksheets("Summary").Activate Dim CountRows As Long Dim CountRows2 As Long CountRows =…
Drew101
  • 63
  • 6
0
votes
1 answer

Webscraping innertext in id

Inner text under id is not printing. Sub JJ() Dim IE As New SHDocVw.InternetExplorer Dim hdoc As MSHTML.HTMLDocument Dim HEL, HBE As MSHTML.IHTMLElement Dim HBEs As MSHTML.IHTMLElementCollection Dim ha, hb, hc, hd, he, hf, hg, hh, hi, hj As…
AAdi
  • 15
  • 4
0
votes
1 answer

Two sheets Filter data results only selective column copy paste to another sheet data should not replace while pasting

Could you help me for this small issue: let me explain you I have one workbook with multiple sheets Filter apple sheet column A results one by one copy few column paste to respective given sheet in respective columns and same need to do for Orange…
Basavaraj k.s.
  • 3
  • 6
0
votes
1 answer

VBA code to search for a column data from one sheet to another and paste corresponding rows data onto first sheet

I am new to VBA and i am not able to find any solution to my problem. I have two workbooks with data. In workbook1 there is a name column A.In workbook2 there is also a name columnA and other data from column B to D. I need to search name from…
Priya Mukherjee
  • 1
  • 2
0
votes
1 answer

How to distribute a known number evenly across a range in VBA

I've a problem here, I've been trying to use VBA to distribute a known number evenly across a range.The problem is that I need to find the way where the numbers in the range be as equal as possible to each other, could you help me? or give…
Xkid
  • 338
  • 1
  • 4
  • 17
0
votes
1 answer

Regular expression in Excel VBA to perform exact match

So, I am taking the text from a Cell in excel and then searching for a particular phrase in that text. Now, I need to return true only if it is an exact word match. For e.g. if the text is "The Quick brown fox jumped over the lazy dog" and I am…
Sudhanshu Gupta
  • 1
  • 1
0
votes
3 answers

What is the sumproduct syntax in vba?

What is the correct syntax for sum product? Here is my code: mFormula = "=SUMPRODUCT(--((1.Insert_Data!F:F)=2.Counting_sheet!A8)),(--((1.Insert_Data!E:E)))" Range("C8") = Evaluate(mFormula)
Vincent Vuong
  • 27
  • 2
1 2 3
…
9 10