bst365体育投注网址大全

Questions tagged [vba]

bst365体育投注网址大全 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 about programming any MS Office application, also use the appropriate tag: [excel], [ms-access], [ms-word], [outlook], or [ms-project].

Filter by
Sorted by
Tagged with
0
votes
0answers
8 views

How to programmatically export and import code into Excel worksheet?

We will put 100s of Excel worksheets out in the field this year. The code periodically needs to be updated when bugs are found. For last year's effort, I was able to dynamically have workbooks pull ...
0
votes
1answer
20 views

Msgbox show only once

Can someone modify my code so that the message box will only show once? I've been at it for a while now without succes. The file I'm working on is a register. Whenever the sum of AD13:AJ13 exceed 4 ...
0
votes
0answers
6 views

VBA IRR function array type conversion failed

Sorry if the question is stupid since I'm new to VBA. The problem arises in the beginning since an excel IRR cannot calculate a changing column in a simulation(only calculates the initial values not ...
0
votes
0answers
11 views

How to call function from another function in VBA? (Error in results)

I am working on 2 functions in VBA. Function 1: Function sort_range(data_o As Range) Set wf = WorksheetFunction N = data_o.Rows.Count data_sort1 = data_o data_sort2 = data_o For i = 1 To N ...
0
votes
0answers
6 views

HTTPS POST Request VBA: Dealing with variable form names

So i came up with making an Excel to give myself a clear view of the value of my most pricey Magic cards. I would like to get some data from Carmarket: Mtg The purpose of my VBA-macro is to retrieve ...
0
votes
0answers
29 views

Read multiple files to extract data

I am currently using the VB code below to read a single file (.cfg format) and extract required data and have this data placed into separate columns in Excel using headings: DESCRIPTION | SPEED | ...
0
votes
0answers
8 views

VBA macro in Powerpoint

I am trying to create a macro in powerpoint. I want to that macro do this: after click on the command button will be sent e-mail with attachment (that same powerpoint) to specific e-mail address. I ...
0
votes
1answer
8 views

How to run IE with VBA using Selenium

How to overcome the IE Zoom Problem when launching it from VBA using Selenium? I have found only some code for other languages, but could not find anything for VBA. Thank you in advance
0
votes
0answers
10 views

VBA Vlookup for date fetches incorrect date format

Have been trying to vlookup a particular value and get the date value as a result from another excel tab. But the output is date with incorrect format, for only certain rows. The Sample code is below. ...
-1
votes
0answers
11 views

Opening ASCII file in Excel with VBA for multiples files

I have multiple ascii files in a folder . I want open each ascii file with delimiter comma. Then i want to do some operation . Then save the file as Excel work book without overwriting the ascii file. ...
0
votes
0answers
11 views

How can I maintain a fast spelling error correction? (change mispelled word to the first suggested word)

I use a code which corrects a mispelled word to the first suggested word. Unfortunately, this process slows down after half a page of typed words. So I type fast but eventually the cursor and the ...
0
votes
0answers
13 views

Excel VBA crashing when referencing a PowerPoint slide index number

A couple of years ago I posted a question about an issue I was having with Excel and Powerpoint VBA on Mac OS X. I never managed to solve the problem, and instead worked around it by installing ...
-3
votes
1answer
35 views

Regex pattern to replace characters [closed]

The program contains text of this type: A B Ccccc A Ccccc ACcccc ABCcccc I need only such text to remain: Ccccc I wrote a replacement function, but I just can’t pick up a pattern How to make such ...
2
votes
2answers
22 views

Can I tell what properties an object has in Watches window?

I'm trying to get the chart count in a sheet. I use the following line of code but Excel doesn't like it, saying the property is not supported. However, in the Watches window, count is listed under ...
0
votes
1answer
20 views

Check for date in filename

I don't know why but I cannot get this to work. I am am a VBA amateur so this maybe a simple fix. I am trying to check if a file exists with the current date (so with today's date on the end of the ...

15 30 50 per page
1
2 3 4 5
11236