You can try this direct VBA approach which doesn’t require HEX editing. It will work for any files (*.xls, *.xlsm, *.xlam …). Tested and works on: Excel 2007Excel 2010Excel 2013 – 32 bit versionExcel 2016 – 32 bit version Looking for 64 bit version? See this answer How it works I will try my best to explain how it works … Read more
I am trying to call a sub on a different worksheet but I got a run time error message. Specifically, I have two worksheets and multiple VBA sub s in those worksheets. In one of the VBA Project (say workbook1.xlsm), I have the following code: But I got the following error. The macros on both … Read more
Every For statement with a body must have a matching Next, and every If-Then statement with a body must have a matching End If. Example: You have part of the body of your If statement inside your For i loop, and part of it outside. It has to be either ALL inside or ALL outside. … Read more
Here is your problem statement: Evaluate the innermost parentheses: This is a range, but a range’s default property is its .Value. Unless there is a named range corresponding to this value, the error is expected. Instead, try: Or you could simplify slightly:
Below is code that I currently use to pull data from a MS SQL Server 2008 into VBA. You need to make sure you have the proper ADODB reference [VBA Editor->Tools->References] and make sure you have Microsoft ActiveX Data Objects 2.8 Library checked, which is the second from the bottom row that is checked (I’m using Excel … Read more
Try the code below (explanation inside the code as comments):
I am trying to develop a form to track invoices as they come in. The form will have a combobox where I can click on and select a vendor number. I want the textbox to automatically fill in based on the vendor number selected from the combobox. Here’s what I have so far: Worksheet 3 … Read more
Question 1 xlPaperUser is a User-Defined paper size that is assigned a constant value of 256. If this has not been defined, it may throw an error. Question 2 There is no way to create custom paper sizes in Excel, however you can create custom paper sizes on many printers. Under Page Setup, click the … Read more
I am working on VBA code in excel and i have the following piece of code When I run the code I get a compile error to debug and it reads Object Required. What is it asking me to do? This is a larger piece of the code:
You can use this password to unlock the SOLVER.XLAM project; Wildebeest!!