All Questions
478
questions
0
votes
1
answer
35
views
VBA For Each Loop Crashes Excel
I have a loop which reliably crashes Excel when it is run at full speed. If it is stepped through in the debugger, there is no problem with the loop, and it produces the correct output.
Private ...
0
votes
0
answers
46
views
How to have a button to download all object in Excel
I have the excel file, I will insert many objects in the file.
The file has no specific format (.pdf .xlsx .word etc)
I want to add a button, when I press the button, all the object will be ...
0
votes
0
answers
40
views
VBA Code Works for Me But Not My Colleague on Chart Object Scaling
I have a part of a much larger code that essentially runs the following process.
Excel Screen Zoom in from 100% to 200%
Make a bunch of tables and charts in the Excel document into Chart Objects
...
0
votes
1
answer
65
views
Changing Object Names Based on Initial Object Size Calculation in Coreldraw
I would like to ask. "Previously, I have already created Object Names A-Z on the Green Line" and I'm trying to create a VBA code, here's the code:
works manually by selecting 2 objects
Sub ...
1
vote
1
answer
75
views
Opening Intellicad via Excel
I have two separate Excel workbooks that open Intellicad and draw an object. I have declared my variable
Dim icadApp As Object
followed by my statement to open Intellicad.
Set icadApp = GetObject(...
0
votes
2
answers
193
views
Object Variable Error in VBA Printing Script
I recently moved a Excel vba project from my personal computer to my work computer. This project is meant to connect and print using a Brother Printer. I keep getting a Run-time error '91': Object ...
0
votes
2
answers
91
views
Updating Broken Data Validation Lists via VBA
I have a spreadsheet with several validation lists, one of which is linked to conditional formatting to identify the status of the record, "closed", "open", "pending", ...
0
votes
0
answers
35
views
Can I call a checkbox by it's name with a variable component in VBA? [duplicate]
I want to loop through a Range with values and attach them to a string. The result is then the name of a checkbox of which I want to know whether it's true or False. I think it recognizes the name as ...
0
votes
0
answers
52
views
Creating object DLL(C#) in VBA
I've created dll and tlb file in C# to use it in VBA.
Code for dll looks like this:
using ModulPlanista.ServiceReference1;
using System;
using System.Collections.Generic;
using System.Linq;
namespace ...
0
votes
0
answers
23
views
Finding a layer in Visual Laser Marker
I have a problem with execution. When I try to execute I got message that there is missing a reference in VLM.
The error is:969xxxxxx.vlm:Object'Group1234', ID = 123 reference missing QP-set'Layer'
I ...
0
votes
2
answers
91
views
VBA: Get a ComboBox to display unique values to choose from filter sheet data - to then run a specific search through filtered data
Hello and thank you for clicking and spending your time. I am not proud to just ask for help, but due to a deadline for this project I am running out of time to properly understand and solve it myself....
1
vote
1
answer
38
views
How to cast worksheet type variable into Sheet1 type Object instance
There are 8 sheets with several different ActiveX comboboxes in each. Some comboboxes are able to filter the list of options of remain comboboxes. The logic behind controls are rather similar between ...
1
vote
1
answer
141
views
Word VBA to check every object in the doc is smaller than page margin
I need to check every object (table, figure) in a large document and ensure they do not go outside of margins? i.e., compare each object's width with page width... then flag with <TOO_LARGE> on ...
0
votes
1
answer
48
views
Object doesnt support this property or method in VBA with SortFields referencing Object
I am trying to reference this below function in the Tab which has all the questions numbers linked into another tab which has all the question numbers. I am creating a scorecard in complete different ...
0
votes
0
answers
67
views
Writing a file from object
I want to write a text file that contains all the data from within an object.
I know how to create and open a text file using vba, also how to write from a range or string going through every line but ...