Visual Basic for Applications (VBA) is an event-driven, object-oriented programming language for writing macros, used for the entire Office suite as well as other applications. VBA is not equivalent to VB.NET, or VBS; if you're working in Visual Studio use [vb.net]. If your question is specifically ...

learn more…| top users | synonyms (3)

0
votes
0answers
4 views

VBA - loop to collect all the contacts and separate them by ;

so , I have a list of contact , each email is written vertically in a cell for better visibility. I need to send the some file to all those contacts so first I need to collect them by a loop and put a ...
0
votes
3answers
18 views

VBA Macro to Scan Header Row and Alter Column Data Types

I frequently paste data from my SSMS query results into Excel to then analyze the data further from there.When pasting datetime stamps into Excel, the format comes through pretty messy. I constantly ...
0
votes
0answers
7 views

MS Word ExportAsFixedFormat(..) throws Exception 80070057

I want to automate the print 2 PDF procdure in Microsoft Word for use with Dragon NaturallySpeaking.I created this macro which is executed when the user has a document opened and says "Print to PDF":...
0
votes
4answers
36 views

Importing CSV as text Excel VBA

I'm importing a CSV file that contains a 20-or-so digit number (for example 12345678901234567890123). Since Excel only supports 15 digits in each cell, importing the data as number yelds something ...
0
votes
0answers
10 views

Access VBA parameters query

Can we update character size of access query because whenever I am trying to run query through VBA coding showing error that "an expression can't be longer than 2048 characters "
1
vote
2answers
31 views

VBA - Copying and Pasting - Running Error

Please see my code below.I have a list of data in columns A to R in sheet7.I need to copy the data from row 1 columns A-F to the first 12 rows of sheet6, starting in row E.After doing this I need ...
1
vote
0answers
16 views

Querying DB with ADODB Always Shows Error 'Either BOF or EOF is True, or the current record has been deleted'

I can fetch data using DAO method, but in my current company the IT Dept. prohibit me adding reference other than ADO. So I want to use ADODB method to fetch data from Query.These data will be used ...
0
votes
0answers
11 views

Power Point VBA - Change color of each bar

I need to change color of bar to red or green based on value.Code works fine on Column chart but does not work on waterfall chart. It says "This action is not supported."Please help making below ...
0
votes
0answers
15 views

Last record on page

I got a problem with a report.I will draw a line on the last record's page like in the example below.In the report I have:Header section (with the company info)Page header section (with the ...
0
votes
1answer
34 views

Storing excel data into several arrays in VBA?

I have several sets of data in 1 excel sheet. I would like to store each of the sets of data into their own array so that I can do the necessary calculations after. I saw this thread on how to get ...
0
votes
0answers
11 views

Access selecting combobox column in VBA returns “function not defined”-error

when trying to access a specific column value of my combobox in VBA, I will get a runtime error telling me the "function is not defined".Is there any mistake in my calling structure or another ...
2
votes
3answers
31 views

Loop that adds a new excel sheet for each time button is clicked

I'm trying to add a new excel for each time a button is clicked, since the sheet is named after the date. However, I get an error that says "Cannot rename a sheet to the same name as another sheet, a ...
0
votes
2answers
29 views

Excel dont wanna see all rows same time

my question little bit spesicific.I created an Excel file includes 10 000 rows. And used some formulas for some columns. I am sharing this workbook with 3 friends. Everybody filling cells but now ...
0
votes
2answers
34 views

How to use a .Value object to reference the value of one column to a row as a substitute to .Copy Transpose:=True

Newb here.I used this loop to copy the values from one sheet's cols to another sheet's cols:Dim ExposureDataInput As WorksheetDim ManualSimulation As WorksheetSet EDI=Sheets("...
0
votes
1answer
21 views

Autofill leaves blank blank cells

I've browsed the site looking for an answer to the following question (to no avail):I'd like to autofill down using only the format.In cell T3 I have the following formula=IFERROR(AVERAGEIF(K3:S3;...

153050per page
angop.ao, elkhabar.com, noa.al, afghanpaper.com, bbc.com, time.com, cdc.gov, nih.gov, xnxx.com, github.com,