@Comintern - No, VB6 was still before Bill's internet epiphany. The key just needs to have sum of first 3 digits mod 3 = 0, and sum of last 7 digits mod 7 = 0.
new to this part of the site so sorry if my formatting is not correct
Here's my question - I have this function I'm building to return the RBG code of a cell I input. The code "works" but something funny is going on. If I write multiple functions each referencing different cells, then all the ...
> Authors Leonhard and Chen found these [72 undocumented Word Basic] commands the way much of the book was discovered: They actually tested every possible use of every command and noted the results.
I am using the following VBA to fetch data from an Access database. The query works but there is a lot of information in the database and the response time is very slow, about 30 seconds.
Is there any part of the code that I could optimise or write differently?
Sub test()
Dim strsql1, tr As St...
> I've just rebuilt my PC. installed Office 2013 32-bit, then VS 2013, then pulled from next and built (including registry and regasm).
When opening Excel's VBE, I get a hard crash every time. When I look in the Rubberduck directory I see there are logs, but **there isn't a config file**.
I can open Word's VBE with only a soft-crash (the VBE is still usable even though Windows said it crashed), and I can open the settings Window, which I reset, navigate around without changing anything and
> Look at the default Settings window size on a 1080p monitor 
Look at the same window expanded in height to nearly 1080px. Notice the indenter sample procedure text is not scaling, and not relative to the setting-controls at the top. 
@ThunderFrame - It shouldn't strictly need a config file unless there were settings added that didn't get initialized in the defaults. Can you post the log from windows error reporting?
> Application: EXCEL.EXE Framework Version: v4.0.30319 Description: The process was terminated due to an unhandled exception. Exception Info: System.NullReferenceException at Rubberduck.Inspections.UseMeaningfulNameInspection.GetInspectionResults() at DynamicClass.(System.Object, System.Object[]) at Ninject.Extensions.Interception.Injection.Dynamic.DynamicMethodInjector.Invoke(System.Object, System.Object[]) at Ninject.Extensions.Interception.Invocation.Invocation.CallTargetMe
I have a File System. It is *supposed* to be laid out / used / added to in certain ways.
This is a program to report on the *actual* state of the file system versus what it's supposed to be.
In particular, pick out unexpected folders and (eventually) validate that Client Folder Names follow a ...
> FWIW, I wonder if the different behavior in Word is because there is always a template plus the host document, so there are 2 projects for RD to parse. Or maybe Word is just more resilient?
The error dialog you get is a COM Interop error - My guess is that RD either tried to load the menu before Excel was ready or Excel was doing something that blocked the COM call.
actually, they're not so functional. :( selecting Rename doesn't do anything...
@Comintern we used to, and (EST - Indiana) is still in most products, but we finally decided to join the early 20th century about 7-8 years ago, and now switch between ST & DT like most of the rest of the world.
I usually pick US-NY or US-ET, and leave the IN out of it.
which got me thinking - machine was freshly imaged, what did they select?
> After a fresh rebuild of my machine (using the corporate image of Win7x64), I'm getting a COM Interop error when launching the VBE from Excel:  After clicking the `OK` button, the VBE does launch, and I get this:  Note that the RD menu is missing, and that RD has _not_ launche
I am very new to coding and know only the basics. The first part of this code is running fine. It converts a range of values to a single column. However, with my data set the rows of data step down, as shown in the sample data set below, so that when they are converted to a single column there...
@Hosch250 I'm running Windoz Update right now - there were 15 updates for .NET. That may have something to do with 2156. I'll test it out again after the updates are complete and update the issue
> My machine was freshly imaged yesterday (Win7 x64), and I'm still getting the crash.
Here are the details from the 2 events that were recorded ~~~ Application: EXCEL.EXE Framework Version: v4.0.30319 Description: The process was terminated due to an unhandled exception. Exception Info: Rubberduck.Root.InterceptedException Stack: at System.Runtime.CompilerServices.AsyncMethodBuilderCore.<ThrowAsync>b__5(System.Object) at System.Threading.QueueUserWorkItemCallback.WaitCallback_
well, the .NET updates didn't have an impact on #2156. There are several other fixes that need to be installed, we'll see if any of those take care of it.
This did only start today, and there are all sorts of changes on my machine, so my main thought is that something's borked at my end...
Const Foo = 1.2 is a Double by default so no problem there...
AFAICT it looks like the compiler assigns type based on the same rule it uses for assignment of a literal to a Variant - shouldn't be any quick-fix problems.
I have a 100+ page Word document, that I would like to extract all of the underlined words from. I am very familiar with VBA and Excel, but relatively new to Word. I was wondering if this is the best way to do what I'm trying.
I will run this from my Word document:
Sub extractUnderlinedWords()...
Although it is reminding me that I've never fixed my browser's spell-check locale at home. System locale is US, spellcheck locale is UK. Drives me nuts.
You know, to an outsider it might look like I'm milking the Date Time Manipulation topic for +2s. They really need to fix the script freezing issue when making substantial edits. They can keep the stupid +2s.
You know, they should really give people positive rep for approving and negative rep for rejecting. It's all part of the "feel good and be nice" they want.
I'm new to StackOverflow and have been told by my colleagues that the users of this site are "mean" and "jerks", especially to new users. Since I would like to properly integrate myself into this community, what are some good practices to correctly be a jerk on StackOverflow?
I'm sure I'm not as good as I think I am, but I think I'm not too bad a candidate for a job. By next summer, when I graduate, I'll have some commits with Roslyn/VS, a fair with with VSDiagnostics, and two years with Rubberduck.
@FreeMan Nah, I started on RD last summer around when college ended.
School is worth it though once its over. I forgot while getting my master's that my father died, and my wife lost a baby... Talk about some stress while going to school... LOL
So it only feels like a year over the last 90 days? Seriously, with the number of commits, comments here, etc. it seems like you've done a year's worth of work. It's greatly appreciated!
That's great. You'll be doing fine then. I wish when I started that open source and freelancing would have been so accessible back then. Sounds like you are doing great!
Also seems like you have a good support group as well. :-)
@DustinF I was on a six-sigma team at a nameless former employer for 2 months before they kicked me off it. I was being "uncooperative" at my task telling them how many bugs we didn't know about.
Corporations are nuts... Sprint also had blue project money type stuff... so my boss would come tell me to add hours to some project I never heard of, because the numbers were too high on the one I was currently charging my hours to.. Neither were anything that I was working on
@Hosch250 There's a reason behind it - The built in DateAdd function is horrendous overkill for most simple date handling. More often than not, I'll just leave everything as a Long until I'm done messing with it (unless I need the time component of course) to make sure that rounding errors don't creep in. It also monumentally faster to process them in Longs and just use the math operators.
LOL - I switched to a laptop as my primary PC in about 2012. The desktop has been gathering dust in the garage ever since. I turned it on to get the Windows 10 upgrade license, and after 3 days of failed updates, I gave up and burned a DVD only to find the PC doesn't support all of the chip instructions required for Windows 10.
Not that I paid retail, but the PC was an HP XW8200 Workstation with dual XEONs, which when new, sold for US$10K
new to this part of the site so sorry if my formatting is not correct
Here's my question - I have this function I'm building to return the RBG code of a cell I input. The code "works" but something funny is going on. If I write multiple functions each referencing different cells, then all the ...
I am using the following VBA to fetch data from an Access database. The query works but there is a lot of information in the database and the response time is very slow, about 30 seconds.
Is there any part of the code that I could optimise or write differently?
Sub test()
Dim strsql1, tr As St...
I am very new to coding and know only the basics. The first part of this code is running fine. It converts a range of values to a single column. However, with my data set the rows of data step down, as shown in the sample data set below, so that when they are converted to a single column there...
I have a 100+ page Word document, that I would like to extract all of the underlined words from. I am very familiar with VBA and Excel, but relatively new to Word. I was wondering if this is the best way to do what I'm trying.
I will run this from my Word document:
Sub extractUnderlinedWords()...
VBA Rubberducking
VBA Rubberducking