> **Justification** When working with source control, syncing from the repository can cause files to be changed externally. There is currently no mechanism in the VBE to detect such changes and sync them to the current project.
**Description** For simplicity, this issue is limited to VB6, as it already stores files externally and lists them all in a project file. However, this could potentially be extended to VBA with additional work.
VB6 has no concept of external file changes, once a p
> All VBA projects internally use a symbol table that only allows up to 32K entries. This limitation can be hit in a large enough project and will produce unusual errors or refuse to compile. The inspection should count the number of identifiers declared within a single VBA project and if it's >30K, alert the users that they are approaching the limit and throw a red flag if it's >32K.
There's no examples nor quickfixes. The usual workaround is to split VBA project into a library project and r
> **Justification** When using the "export active project" function for source control, all files are dumped in a single folder - this makes navigation in Windows explorer or on GitHub more difficult. It would be good to specify a folder structure when exporting the project, similar to how RD is structured in GitHub.
**Description** I think the best option would be to use existing folder annotations to dictate export directory. Folder paths would be relative to a specified root directory or
> **Rubberduck version information** The info below can be copy-paste-completed from the first lines of Rubberduck's log or the About box:
Version 2.4.1.5196 OS: Microsoft Windows NT 10.0.15063.0, x64 Host Product: Microsoft Office 2016 x86 Host Version: 16.0.4912.1000 Host Executable: EXCEL.EXE
**Description** I´m not able to change the entry 'Empty line handling' in the Special Options menue of Indenter Settings. If I hit save&close, the value is not changed, it is still Ignore
@this You can make a very effective cabinet scraper out of an old saw blade. It can get annoying to hold, so wood makes an effective handle.
And yes, long before you could pop down to the local big-box retailer or even the specialized woodworker's tool store, they would make their own tools. Sometimes working with the blacksmith for the metal bits, sometimes doing it themselves.
Loads of hand-made planes, lovingly passed down from father to son, still floating around out there.
It's more important to have good control of how far the blade sticks out.
If you control how far the blade sticks out, you can use a straightedge to find what needs to come off the surface you are planing and carefully work that area.
just had to read up to make sense of "planes" in the way it was used; i'm with ben on this: "surfacers" can make things planar
cross-surfacers are a great way to level; cross-surfacer is a tool with a grit base (modern folks just use sand paper), typically a porous cloth on the bottom of wood, where you add silica or diamond chippings with a lubricant and start polishing in a figure 8 pattern to ensure a planar/level surface. some very large cross-surfacers are turned upside down and you move the final product atop it (e.g., electrodes)
interesting... I have \git\project\Forms\files.def. I added Create Branch to the top level context menu in tortoise settings - it only appears when I right-click on ..\project. That sorta makes sense, but it's sorta weird...
I guess you make a branch of the project, but I'd have thought that r-clicking on \git\project\.git would be the logical place for that
are you the owner of the project? not sure if it's a settings issue, but for one of my projects on there i cannot touch the base project folder, only subfolders so the owner can move from dev to production, etc.
@this Can you elaborate on "import & delete". I don't see a single command that does this - is it a series of steps to delete all code, etc. from the project then import only what's in the current branch, or am I totally misreading this statement?
OK, VBA Experts... Say that you have a bunch of rows in an Excel document, with a column like this: 16:39-16:42,17:18-17:18,19:44-19:44,19:49-19:49,20:48-20:48, and you would like to count the number of minutes that overlaps with other rows, how would you do that?
If I could solve the problem in Splunk, I would, but I'm afraid that's very tricky because this data is already aggregated with a transaction and other fun stuff Splunk queries can contain (This is one of the more complex Splunk queries I'm dealing with at work)
another way I'd do this is to split the start & end parts into their own columns. Find the minimum start and maximum end date. Create a complete set of minutes from the min start and max end, then count the occurrences and then count where the occurences are non-zero.
may be simpler to use an array and sort, where arr(x,y) has the time as x and if it's a bound in your criteria y=1 for lower bound and y=2 for upper bound, so you can tell what is between ranges
simply pasting said array would show where outliers exist
From LibreOffice's online help file:
With a few exceptions, Microsoft Office and LibreOffice cannot run the same macro code. Microsoft Office uses VBA (Visual Basic for Applications) code, and LibreOffice uses Basic code based on the LibreOffice API (Application Program Interface) environment...
i would say this depends how your data is set-up... if you can texttocolumns using "-" then you get your preferred ranges into two columns easier... then you can use formulas for your data column to determine if it's contained, and where false you flag and voila, done
```` sub main() 'select your data to be separated selection.texttocolumns datatype:=xldelimited, other:=true, otherchar="-" 'now compare if >=colA and <=colB (assumes your data was in colA to start) end sub
msgbox("hello world")
<-- being that guy using selection and select... lol
@Cyril Selection in the Word object model has nothing to do with Excel's Selection. In Excel Application.Selection is a late-bound abomination; in Word it's a full-fledged early-bound object with actual members
@MathieuGuindon in word you use it for damn near everything, which really, really hurts... the fact that it's the preferred approach for headers/footers is difficult
the excel side, it has some uses, but can be avoided like 90% of the time
@MathieuGuindon that was my next thought after seeing it. the other option is to use consecutivedelimiter=true and collect the final usedrange as an array and put it into a 1-dimension array for sorting
> Microsoft Power Query for Excel is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery, access and collaboration.
connector = translator for a specific API. there are SalesForce connectors, SAP connectors, etc., which allow for simplified access via password screens, blah, with inherent hashing. many companies sell their connectors as addins for excel so you can have "every" user able to put in data without having licenses for the specific software
It's ok to have a copy of it as a template for other users but the actual one has to be outside the working tree's directory, with the Access binary file
From LibreOffice's online help file:
With a few exceptions, Microsoft Office and LibreOffice cannot run the same macro code. Microsoft Office uses VBA (Visual Basic for Applications) code, and LibreOffice uses Basic code based on the LibreOffice API (Application Program Interface) environment...
VBA Rubberducking
VBA Rubberducking