Join us in building a kind, collaborative learning community via our updatedCode of Conduct.

Questions tagged [vba]

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 ...

0
votes
0answers
10 views

How to have cascading inserts?

I hope my request is clear. I will try and be as informative as possible.I have a form that has a Tabular Form ControlThe Parent Form holds Student data. The Record Source isSELECT * FROM ...
-1
votes
0answers
9 views

Excel VBA - Copy and Insert copied cells from the last two rows, delete partial data, and copy based on a criteria (Macro Code)

I want to start off by saying I don't have experience with VBA so I will try my best to explain as much as I can regarding the problem. I have this excel sheet that I would update every month by ...
2
votes
2answers
20 views

Almost there! How to Hide Rows by Integer?

I am trying to hide rows in Excel by integer counting in this simple example based on the input from a cell. I can't seem to get my syntax right for the Application.Rows("x:x")Select command. Here ...
0
votes
0answers
17 views

VBA Spliting Code and passing arguments

I'm quite a beginner at coding and the problem that I'm having is that the procedure is too large. I read that this can be fixed by dividing the code into smaller modules. However I want to know if ...
3
votes
1answer
39 views

VBA Macro to count minutes

I was wondering if it would be feasible to do the task I'm about to explain via VBA or not.Basically what I'm trying to do is, go through "DUMMY2" and once the values are "27", I would like to ...
2
votes
0answers
12 views

Outlook vba Download Attachment rename with prior date received

Good Day Experts,I would consider myself pretty new to VBA in general. I have managed to create a few codes for various platforms of Microsoft. However, I'm running into a major stumping block and ...
0
votes
0answers
15 views

iMacros Tag Line properties

I'm trying to create a macro to log in to a company owned web page. When I record putting the cursor into the User Name text box, the following command is recorded:TAG POS=1 TYPE=INPUT:TEXT FORM=...
2
votes
0answers
23 views

Excel doc locked for read only after outlook vba code updates worksheet

I'll try to summarize the purpose of this project for some background on the task. I have searched around and adapted some code that checks the subject line of new Outlook emails for a keyword and ...
1
vote
2answers
35 views

Create an array of rows VBA

New to VBA. I'm trying to create an array of rows. Basically, I have an entire sheet and want to take all the rows that start with a certain value ("MA") in column 8.I eventually want to ...
0
votes
1answer
19 views

Referencing specific HTML tags and classes with VBA

I built an application for work that uses visual studios built in web client to perform a search for stock numbers on our website. It automatically searches and returns the url of the corresponding ...
0
votes
0answers
13 views

VBA: Uploading file to iManage/Worksite to a particular folder

I know that there are posts about uploading to worksite already but I have a problem with a different part. Let's say that I have a particular FolderID and I'd like to be able to upload files to ...
1
vote
0answers
11 views

SolidWorks EPDM GetVar for BoM not working in VBA

This one has me really stymied and I suspect its because I am now too "close" to the problem. I am converting a VB.NET routine into a VBA routine. Here is the VB.NET code that works as expected.` ...
0
votes
2answers
16 views

VBA numbering loop

I am trying to simplify a code in a Macro for numbering rows of specific columns of excel. Currently I am using With Sheet1.Range("V6").Value=1.AutoFill .Resize(V6 + C, 1), xlFillSeriesEnd With ...
0
votes
2answers
21 views

Catalog word file data in MS Access using VBA

I've been asked to create a MS access database that catalogs all the data that is stored in MS Word Files. The Word files have tables that contain the data.For example, "Customer Name:" | Customer ...
1
vote
0answers
16 views

Excel VBA attaching print area as PDF

I'm trying to create a macro whereby the print area of a sheet, "Hotel Booking" is attached as a PDF file to an email. The email will be created using CDO and not Outlook Application. Everything else ...

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