hi guys :) Any Idea what might be wrong here? "Sub TableSetUp(path As String) Dim strTargetFile As String Dim wo As Workbook Dim ws As Worksheet Dim s As String Set ws = ThisWorkbook.Sheets("Daten") Dim j As Integer
Application.ScreenUpdating = False Application.DisplayAlerts = False strTargetFile = path Set wo = Workbooks.OpenXML(filename:=strTargetFile, LoadOption:=xlXmlLoadImportToList) Application.DisplayAlerts = True MsgBox (wo.Sheets(1).Cells(1, 1)) MsgBox (ws.Range("A1")) For j = 1 To wo.Sheets(1).UsedRange.Columns.Count
you'll have to insert Option Explicit at the top of your existing modules. But for all new modules it will be set automatically. It will force you to declare all your variables. So when you unintentionally (due to typo) use one that's not declared, the compiler will complain.
at first because no Option Explicit and then some more (variable used but not declared; and more?)
the font Consolas seems ok-ish regarding the distinction between l and 1
this, or hosch?, told me about some nice alternative (Google source or something along those lines), problem was of course: No privileges means IT has to be involved. ;)
I've built a VBA Excel macro that works on a spreadsheet of duplicated files, and displays only groups in which at least one duplication is owned by the current user.
The spreadsheet lists file metadata, one file per row, grouped with other files whose content is identical, i.e. "duplicated". Ea...
@PeterMTaylor it's specifically designed for use in IDEs. It's not a font for writing essays in, or webpages/forms, but it is definitely better than Courier New, and I'd argue that it's better than Consolas, but that's just my opinion.
@PeterMTaylor but if you're looking for a nice webfont, or font for generating text in a PDF, then I highly recommend Raleway for body text and Montserrat for headings. Both are available on Google Fonts. fonts.google.com/specimen/Raleway?selection.family=Montserrat
I have the following code I'm using to show/hide multiple shape groups in Excel 2016 using VBA and macros:
Sub Pic_1_SA_click()
ActiveSheet.Shapes("Group 23").Visible = True
ActiveSheet.Shapes("Group 71").Visible = False
ActiveSheet.Shapes("Group 19").Visible = False
ActiveSheet.S...
I have an array which has duplicate rows which can be identified by the concatenation of columns 1-4. I want to loop this and decant unique rows into a second array. I was thinking to use a scripting dictionary to identify duplicate rows. I would loop the array , adding a key,which is the concatentation of the 4 columns , into the dictionary if it does not exist. If it didn't exist I then decant the row into my second array.
It got me thinking.....if I don't care about which row is kept amongst the duplicates, is it more efficient to simply overwrite the value in the dictionary for a given key or to do a test of if exists? It feels like the overwrite should be more efficient.
@MathieuGuindon just a thought. Maybe the pretty printing handling stuff needs to be its own thing. If it's a service, you can eliminate that from the unit tests and make sure works correctly w/ VBE. That way, if we do ever go AvalonEdit, it's still easily abstracted out.
For the unit tests themselves, use a no-op pretty printing handling service.
Merged cells are a PITA in Excel. They prevent doing a lot of actions and make copying columns impossible. So I wrote this little code to change all the merged cells in a given sheet into 'Center across selection'.
I did NOT test against vertically merged cells, but it should not trigger an error...
also, bonus points for ParseCurrentScope that only tokenizes the current procedure if the caret is in one, or just the declarations section if that's where we're at :)
That said, I'm not sure if I'm resolving stuff in there. I assume yes since I just run the parser on it. Didn't feel slow but that's just opening a dialog rather than each keypress.
ah, and that's where we need that another PR that never happened to keep on parsing in face of errors.
Dragons don't "test the boundaries of what is capable of flying," as any dragon worth the name is a good deal larger and heavier than even the biggest flightless birds. Rather, they look the Square-Cube Law straight in the eye and say "I'm a dragon. Move!" and physics obligingly gets out of their way and lets them do their thing. — Mason WheelerDec 1 '16 at 18:57
@MathieuGuindon I'm not sure if you already tried this: keep a dictionary of the current placeholder values, then, replace the entire code block with a regex-replacement of the original snippet every time one of the placeholder values changes. That doesn't require any parsing and it allows the user to move forward and backwards between placeholders using tab and shift-tab (so they can go back and change a placeholder value if they change their mind.
@MathieuGuindon but you know the start positions after each replacement, and the length of the next value... But you only need to know the position of the current placeholder target.
I have something mocked up in a VBA form using textboxes (as I didn't want the distraction of the hooks). It's not quite done, but I think it will work. And my snippet involves writing to multiple locations in the module, not just a single contiguous block.
The Builder Pattern is rarely something you need. Often a Factory Method does the job just fine, as far as creating object instances goes. But sometimes, creating an object in a valid state would require a Create method with many parameters, and that gets annoying. There’s something rather elegant about chained member calls that build an object. The methods of a… Continue reading OO…
@BloggingDuck that draft had been collecting dust for well over a month... trimmed to death and published
Gaps would be records that were deleted. You would hit the exact same problem if this were SQL Server with an int primary key with identity specification, which is pretty much standard and best practice. In SQL Server you can set identity insert on; not sure if Access has something similar, or if it lets you just insert values in an autonumber column. — Mathieu Guindon31 secs ago
^ @this does Access have anything like set identity insert on;?
In VBA, it is possible to assign the result of Array() to a typed array:
Dim a() as Integer
a = Array(1, 3, 5)
But for some reason, this breaks when the result is passed into a function:
Sub Main()
Foo(Array(1,2,3)) '<- "Type mismatch: array or user-defined type expected"
End Sub
Sub ...
Get told "You can't do this" by help desk pineapples. 10 mins of monkeying with it proves them wrong. It helps to answer questions if you understand what you work with...
Nothing special either, basic feature of sharing meeting within the same family of accounts.
anyway thinking about it, it is same thing - a builder that returns another builder can be used to constraint the API.... whether it's a good idea.... ???
I did not find the CW API to be too confusing after reading the documentation.
BTW, the associating Descriptor with reflection is rather correct. It is simply a description of what you want to register. You can call some methods on it to get a descriptor with more details specified.
might be me then. When I try to research the errors I got, I could not locate the documentation that would have clarified whether I was missing something.
It works in production, because we register the RubberduckParserState.
The point of an IoC container is that you do not have to wire up the injection for all types by hand. You still have to tell the container what you want to have injected for a given parameter type.
However, since these would not be set up correctly, all properties and functions would return the default value for the return type, most of the time null.
InfoQ: What will be important in the future of testing?
Bhamare: Let me take a deep breath first.
Well, for me the important thing in the future of testing is going to be “having to share it” with different job-roles and managing it with authority at the same time, in such a way that quality of the end product is not compromised.
:+1: for RD. Making refactoring easier and with more confidence stuff oughtnt break.
Should the parse button be clickable when it's on inspecting? I've noticed that when I alt tab to another application while it's parsing and tab back it goes from greyed out unclickable to blue and clickable.
I have the following code I'm using to show/hide multiple shape groups in Excel 2016 using VBA and macros:
Sub Pic_1_SA_click()
ActiveSheet.Shapes("Group 23").Visible = True
ActiveSheet.Shapes("Group 71").Visible = False
ActiveSheet.Shapes("Group 19").Visible = False
ActiveSheet.S...
In VBA, it is possible to assign the result of Array() to a typed array:
Dim a() as Integer
a = Array(1, 3, 5)
But for some reason, this breaks when the result is passed into a function:
Sub Main()
Foo(Array(1,2,3)) '<- "Type mismatch: array or user-defined type expected"
End Sub
Sub ...
VBA Rubberducking
VBA Rubberducking