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

Runtime error involving sQRY in VBA code to import AccessDB queries to Excel

I've been coding a module to import an access database query (hopefully several in the future) into an excel worksheet but keep on getting the same error: Run-time error '-2147217900 (80040e14)': Syntax error in FROM clause. The code I am using to…
mblack204
  • 39
  • 5
0
votes
2 answers

Drop All Relationships and relAttributes

I'm trying to repair some relationships in a database and I've created an xml copy of a backup DB. Do you need to drop all existing relationships first. I tried DropRelationships from here Importing/Exporting Relationships Function…
JohnM
  • 1
  • 2
0
votes
1 answer

Commulative function in sequences Cells in the same row

The code (with the SumOffset1) works perfectly and gives the correct result in the cell(5,2) running the function which it starts from the cell(3,3).Could you please help me how to modify the function so as to get the correct result in the cell(5,3)…
user22120139
  • 1
0
votes
0 answers

Group [Col-OFF] with duplicate or identical values (Short text), and [Col-Amt $$] I want to group dups from [Col-OFF] and Sum of dups in column

I have a table named tbl-Rec with columns [Col-OFFICE] that contains duplicate or identical values, and [Col-Amt] that has the corresponding dollar values of Col-Office. I need to show in a query result the total amount of all identical duplicates…
Datamint
  • 1
  • 1
0
votes
0 answers

downloader.autdwnlrner/w97m and VBA.Heur.SDownloader.2.4E2AC9F2.Gen Detected on my VBA code

I have this VBA code that works perfectly but the problem I have is the code been detected by Major antivirus when scanned on Virustotal.com. Its a 52% detection rate which is very poor. From the scan result, major antivirus as detecting…
Dieketseng Moreki
  • 1
0
votes
0 answers

How to Copy a range in a worksheet from one workbook to another sheet in another workbook

Copying from one workbook to another workbook Sub foo() Dim x As Workbook Dim y As Workbook Dim ws1 As Worksheet, ws2 As Worksheet '## Open both workbooks first: Set x = Workbooks.Open("") Set y = Workbooks.Open("") 'Now, transfer values from x…
PrincessAria
  • 1
  • 1
0
votes
0 answers

Paste text from slide number placeholder on PowerPoint slide into Word

I am trying to copy three things from a PowerPoint slide and paste them into Word (using a VBA Marco in PowerPoint): 1) Slide number, 2) Thumbnail image of the slide, and 3) the Slide notes. I'm able to grab the slide notes by using Placeholders(2),…
PMPM2000
  • 3
  • 3
0
votes
0 answers

Not able to Get Final Result in Textbox23

I need Code to Get Final Result in Textbox23 after updating below list of textbox and combobx Details As Below If LME_Data.ComboBox1.Value = "SHORT" And LME_Data.ComboBox2.Value = "HEDGE POSITION CREATED" And LME_Data.TextBox14.Value > 0 And…
Rakesh Wala
  • 1
0
votes
0 answers

Excel VBA Post File and Json body to Azure Function

I am tasked with a problem of using a Macro Enabled Excel file that needs to collect json and upload them to an ftp location. Yesterday trying a number of things with FTP, found that this wasnt going to be a smooth ride for various reasons. Biggest…
Simon Price
  • 3,011
  • 3
  • 34
  • 98
0
votes
1 answer

vba excel-loop through set of Data, populate depending the Date and skip weekends

I'm having an issue trying to integrate a condition inside a Loop. This condition populates the first 5 cells in a Row (Weekdays) and then skips the next 2 (the Weekend). This goes on depending on the number of the Days. This happens while reading a…
jjjhhh
  • 15
  • 5
0
votes
0 answers

How to keep Number Format in a Variant data type

I have an APF variable store in columns apf_rev_info_col I set up its format number with 1 decimal number like this: Columns(apf_rev_info_col).NumberFormat = "0.0" Then I want to pick up unique value from this columns, using Application.Unique like…
Le Dieu Ha PHI
  • 19
  • 4
0
votes
1 answer

How to solve VBA - FormulaArray error 1004?

I am a new user of vba and I am experiencing this error 1004 "Unable to set the FormulaArray property of the Range class" by running the following code: Worksheets("Discriminatory_power").Range("G11").FormulaArray =…
Vanessa
  • 1
0
votes
0 answers

To filter data in table using a Access form and selecting a value in combo box

I'm working on Access Tracker, basically it has a table and form. The column headers of table are parent entity, subs, Compliance etc., the combo boxes in form are parententity2, subs2, compliance2, etc. Each parent in the table can have multiple…
user21308963
  • 1
  • 1
0
votes
1 answer

error object doesn't support this property or method

i dont know where is the problem :( Sorryy Private Sub Tmbl_Del_Click() Dim sampah As TextBox Dim sampah2 As ComboBox For Each sampah In Jurnal If IsEmpty(sampah) Then If sampah.Name <> TxtTanggal Then …
Asyraf Muzhaffar Lanaan
  • 1
0
votes
0 answers

Subscript out of range in VB Script

I have a SAS Code where inside we have embedded the VB script, While trying to execute the code through sas application i am getting an error stating like subscript out of an error, at the following block of code With…
Vijay prasath
  • 1
1 2 3
…
9 10