This full code pulls data from a work website into Excel. Can be up to 55000 rows. Currently on Excel 2019 it takes forever to run. Also uses between 33%-50% of cpu. On 2016 it worked fine. I use a code already that turns off all things like calculations, events, etc.
I am thinking an array...
Dim InputworkBook As Workbook
Dim ReportsToReconcile As Variant
ReportsToReconcile = Array("Report1", "Report2")
Dim ReconcilingReport As Variant
Dim ReportIndex As Integer
ReportIndex = 0
Set InputworkBook = Application.Workbooks.Open(Application.GetOpenFilename, ReadOnly:=True)...
But Not this...
Evaluate(".GetPivotData(" & PivotEntity & ")")
How to make this work? If not... Is there any other alternative command available. Please Help. Thank You
Hello. When developing, I have found it convenient to use TempVars because they maintain state even when my VBA project does not. In addition, I don't have to run a load procedure every time I restart my code.
To provide a bit of validation and intellisense, I wrap them in properties in a...
There is a button click private sub on another sheet, I just want to invoke it from a macro. The below doesn't work:
CallByName Sheet30, CommandButton10_Click, VbMethod
Is there a better approach?
I have a userform that during run time creates 256 individual labels (they represent 5 charts with 53 weeks of data).
This works great, I move the axis and scale as needed, I color code them based upon data in the spreadsheets, they have control tips to show their full value.s
I also have...
I'm struggling for a while with a generic mechanism to assign some short-cuts to methods that are implemented in classes. This is what I have so far:
In a class module ("test2"):
Private Sub Class_Initialize()
Dim var(0 To 1) As Variant
var(0) = 5
var(1) = "ThisIsAstring"...
This might be a ridiculous want but I'll ask anyway. I'd like to be able to create a number of variables based on user input. Something like this:
Dim Counter as long
Dim X as long
X = inputbox(prompt:="Enter Number of Blah Blah")
For Counter = 1 to X
I have a VBA Routine where I open workbook and run some code in the newly opened workbook that requires two input parameters...I've been trying to pass them ByVal however the debugger now does not recognize the Call to the procedure if I include the variables...anybody have any ideas on...
I have a string variable which I have succesfully passed to a sub in a userform. The variable is used to call a second userform from the one it was passed into. My problem is that I have no idea how to execute the %^&$ thing.
Suppose I have a variable
MyVar = "MyName"