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

VBA Excel Form build from module, disappear after few 10/seconds

Looking for a more customizable MsgBox, I read some users that suggested to others with my same problem: build a form "on the fly"! Well. That's what I do. Unfortenately my code run, my form's shown, but suddently disappear.Only fews 10/secs, maybe…
Emanuele Tinari
  • 120
  • 1
  • 2
  • 10
0
votes
0 answers

Using excel VBA to connect to azure sql with active directory authentication

I'm trying to connect in excel vba to a azure sql database using adodb and AD Integration but none of the connection strings I am using seem to work. I am using ADODB.Connection in conjunction with the string below to connect to my sql server. I've…
user21205485
  • 1
  • 1
0
votes
0 answers

Syntax error when attempting to embed Javascript into VBA7 Macros

I have no experience with JScript or javascript, but I had an issue that I thought might be a quick solution with what was available online. Ultimately I am trying to create a macro with javascript, but the rest of it is in VBA7. I found a dated…
user14894283
  • 73
  • 6
0
votes
0 answers

Error in deletion of publication in catia

I have a issue in deletion of publication in catia. below is the code which i use. Sub removepub(remove_p) Dim PubName As String For i = 1 To remove_p.Product.Publications.Count PubName = remove_p.Product.Publications.Item(i).Name …
tls
  • 11
  • 2
0
votes
0 answers

Constraint in Catia VBA

I have a issue regarding the constraints in Catia VBA, please look at the below code. Sub catmain() Dim CAT_documents As Documents Set CAT_documents = CATIA.Documents Dim prod_doc As ProductDocument Set prod_doc = CATIA.ActiveDocument Dim prod As…
tls
  • 11
  • 2
0
votes
0 answers

Convert VBA user form into Android mobile application is there any way to achieve this?

I designed an user form in VBA. I key in data in the user form and entries get registered in the excel automatically in the background. However, I was wondering if there is any way to convert VBA desktop user-form UI into mobile application. So…
Habeeb E Sadeed
  • 49
  • 7
0
votes
0 answers

Creating a Word VBA code for Modified Merge Formatting Paste

I've been working on a VBA code to paste in a text string that will always have the same formatting. The text string will always include starting and ending quotation marks followed by text. I want to put the text string with the quotation marks in…
broncos15
  • 59
  • 1
  • 8
0
votes
0 answers

VBA Script which compares two sheets and returns unique values in a new sheet

I created a VBA Script which compares a sheet named "New Data" and a sheet named "Old Data" to return only rows with a column differing. I created this in order to find back dating which occurs from time to time, so the two sheets "New Data" and…
edsaniti
  • 3
  • 2
0
votes
1 answer

Duplicate a specific word page for "N" times

I am new to the world of coding. I am trying to create a macro to duplicate a specific page for "N" a number of times. The code duplicates the entire document, hope someone could help me fix this issue. Thanks in advance. Sub DuplicatePage() Dim…
Sujith Gopakumar Dhanalekshmi
  • 1
  • 1
0
votes
0 answers

Invalid procedure call or argument (VBA Excel)

I am trying to make a tool in VBA excel. I created a userform with a textbox and some checkboxes. Underneath this checkbox i have 3 buttons. Each button has to run a powershell script. The powershell script is as following ('value-button', 'value…
MoBo87
  • 1
0
votes
0 answers

2FA of the Google Authenticator App with VBA

First of all I am not a native English speaker and new here. It is also not a question, but a possible solution. I've been looking for a complete solution on how to implement the Google Authenticator App function in VBA. But all hmac and sha1…
Stephan
  • 1
0
votes
0 answers

Want to fetch last traded price in parallel

Here is the code I have for fetching the values between Two Particular values, I need to fetch Last traded price at the same time, please help this is my code for fetching all values between min value and axvalueout Here is the excel sheet I tried…
Pooja Dhongadi-ReactNative
  • 1
0
votes
1 answer

VBA Resize shape according to cell timevalue data

I want to populate my shape according to time range value in 1st Range and 2nd Range cell as shown in the image. Thank you. Your help is much appreciated https://i.stack.imgur.com/XNNy2.jpg I've tried this code but it won't work. Dim z As Range …
Enrique Ferolino
  • 27
  • 4
0
votes
1 answer

Insert the data into a Table from an unbounded form

I have been facing the below issue while I'm using the VBA code to Insert the data into a Table from an unbounded form: Syntax 3134 - Runtime Error On Error GoTo Err_Handler Dim strSQL As String If DCount("EmpDBID", "tbl_R&R", "EmpDBID=" &…
mrk777
  • 117
  • 1
  • 12
0
votes
0 answers

Trying to add a record or edit if it is a duplicate in VBA

I'm creating a form that is intended to add records to a data table or edit existing record if the ID is a duplicate. ` UPDATE** I've figured out how to make this work. Sort of. My current code is `Option Compare Database Private Sub…
Dynamite Jarrod
  • 5
  • 2
1 2 3
…
9 10