216,652 questions
0
votes
0
answers
16
views
Error 462: The remote server machine does not exist when trying to move lines with Word via Access VBA
I have this code that moves down a line from a content control and programmatically adds another content control so it can fill it in. The reason why I do this with code is because sometimes there ...
- 835
1
vote
0
answers
41
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
19
views
Error when creating ADODB connection over SSH from VBA
Can anyone help me with this? I can connect to this remote DB from my SQL workbench, but can't get Excel to connect to it through ADO connection in VBA.
getting automation error on the DBCN.OPEN line.
...
0
votes
0
answers
20
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
22
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
34
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
1
answer
59
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
-1
votes
0
answers
23
views
Send email from a second account using thunderbird
I use an excel to send my invoices by mail. Until now i used outlook (i have a different email address for invoices). I use thunderbird for day to day. I added my invoice email as my second account in ...
- 1
0
votes
0
answers
31
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....
-1
votes
1
answer
85
views
Is there a way to 'normalise' my data as it currently is?
We have an Access database that we use for test sample submissions. We have 18 different method we can run, and each method typically has a different number of test runs associated with them (although ...
- 35
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
96
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
85
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
78
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
0
votes
0
answers
41
views
Syntax error (missing operator) in query expression, and can't figure it out [closed]
Private Sub cmdOpnPS_Click()
Dim varWhere As Variant, strForm As String
' Set an error trap in case report has no data
On Error GoTo Err_CmdOpRec1_Click
' Initialize to Null
varWhere = Null
...
