All Questions
163,124 questions
1
vote
0
answers
19
views
Excel/Word macro slows with iteration
This macro is used in Excel to data mine from Word documents. The macro iterates through a list of files to process. The first two or three files take 10 seconds each. After that each file takes 3.5-4+...
- 31
0
votes
0
answers
18
views
Colour set by Point.Format.fill.ForeColor.RGB changes after sorting table in Excel
I'm trying to set the colour of different markers in my chart based on their label. To do this I set the colour of the markers in a series using Point.Format.fill.ForeColor.RGB where the colour of ...
- 1
0
votes
0
answers
21
views
How to use complex formulas in data validation via VBA without Excel adding the @ symbol? [duplicate]
I'm facing two related problems while working with VBA in Excel. Both involve complex formulas, but they behave differently when set through VBA compared to when entered manually in the Excel UI.
...
0
votes
0
answers
33
views
How to export chart in Excel with text boxes
I have a chart in Excel which consists of a chart object called "Diagram". On top of this are added som text boxes with explanatory text. When I output with the Chart.Export method, the ...
- 181
0
votes
0
answers
54
views
How to get the exact Team Name using Application.VLookup
Sheet1
Error during initialize:
What should be fixed in the code below to get the exact team name populated in the Me.cmbTeam.Value (combobox) if team member is matching in column 2.
Private Sub ...
- 749
0
votes
0
answers
29
views
How to get the properties of Bundle Segment in CATIA V5 Electrical workbench using VBA?
How to get the properties from the Bundle Segment.
Below points are there in property window.
Type: Bundle Segment.
Reference designator: BNS0001.
Diameter: 6.2mm.
Bend Radius: 37.2mm.
Length: 238....
0
votes
1
answer
39
views
Calculated field in Pivot table using min of date
I have a pivot table that returns the min of a date per category . Can I have a calculated field that works like this: date - Today
I tried a calculated field but couldn't select the min of date to ...
0
votes
3
answers
94
views
Trouble at adding new sheet
Having trouble with the following code. It finds the sheet named "Out", deletes it if present, and recreates it by adding a new empty sheet and renaming it to "Out". The issue is ...
- 1,625
0
votes
3
answers
84
views
VBA For Loop to Create Data, Save to Array, and Display array on Worksheet
I am going slightly crazy on this and I'm not sure if it's because I'm searching for something that isn't possible or I'm just not searching in the right places! I am trying to use a for loop to ...
- 35
2
votes
3
answers
77
views
How to duplicate row and insert below based on cell value
How do I use excel VBA to insert a duplicate row below row 1? For example, A1 contains the cell value that corresponds to the number of rows to be duplicated below row 1. If A1 contained a value of 2,...
- 21
2
votes
0
answers
68
views
Issue with Copy/Paste from Word to Excel
I have some code to open a PDF file using Word, and then copy all the text and paste it into Excel for data mining. A good portion of the time, a portion of the text will not get pasted (it varies ...
- 31
0
votes
1
answer
47
views
What’s the correct format for a calculated time value on a userform?
I have a userform that takes my workday start time, end time, and two break times, then feeds them to cells on the spreadsheet. I can use those cells to calculate the total hours of my workday, but ...
- 101
-7
votes
0
answers
81
views
I am looking for help to modify part of code that is causing error [closed]
I used the code from this answer to remove passwords from multiple books with different passwords.
The files in my folder are all xlms.
When I run I get this error:
Runtime error: "1004"
...
-2
votes
0
answers
32
views
Trade local file with random destination [closed]
got any idea for save in the local file (a file), but my "a file" maybe will save or move to other destination as well. In my VBA could I code it and save the binary(the file have been ...
2
votes
3
answers
74
views
Excel - How to return cell value in a Column C in sheet2 to Column C in sheet1 when values in Column A of sheet1 & 2 match
I'm new to nested formulas and VBA and was hoping someone may be able to help. I am limited to using excel 2016.
I am trying to workout how to dynamically populate a cell in sheet1 column U (Due date) ...
- 21