Search results

Thanks for the responses, I didn't think of looking at the xmls or at the temp files, nice thinking out the box :) Unfortunately the files I'm looking at are up on esink, I can browse through the web browser or drill down from a link I use in windows explorer. The path from windows explorer...

Has anyone seen any VBA that will let me see who has a network file open? I thought I had found something with http://www.xcelfiles.com/IsFileOpenVBA.htm but this only seems to work with the xls files I check, it fails on xlsx files.

Hi shrivallabha and thanks for your response. That will work, and it is a lot simpler than what I was coming up with. I don't need to find the number of times, only if B1 appears on the left of the | and then a second search on the right of the | but this formula will allow me to find a hit...

Hi all, I feel like I'm chasing my tail with something here and was hoping for some fresh creative insight :) In A1 I have test1|test2 In A2 I have test2|test3 In B1 I have test2 In C6 I have =IF(IF(ISERROR(FIND("|",A:A )),A:A,LEFT(A:A,(FIND("|",A:A ))-1))=B1,"1","0") with ctrl+alt+Ent...

Thanks for the responses, both responses have come back with results. Narayank, the [] round the 6es seemed to throw that off but when removed it fixed it, RC6 was looking at column M instead of F. I found that the formula was looking at the wrong range though, which brought up your question...

Any quick pointers on what I am missing here would be greatly appreciated. I have dimmed a range with Dim rngRole As Range Filled the range Range("A1").Select Range(Selection, Selection.End(xlDown)).Select Set rngRole = Selection And now trying to populate a column with a vlookup...

Hi JB, sorry for the delay. The storm before the calm at work, (holiday at end of the month). Extracting text strings from an exe is what I am looking to do so I will have a good look at that, thanks.

Hi JB, Thanks for the pointer. I take it that's a decompiler? I will have a look at it and see if I can use it to work out the logic that is going on in the exe and see if I can apply it to the vba though I think the exe is using some kind of C language which is way over my head, not that I'm...

I think I might have misunderstood your idea of piping, if you mean altering the exe I don't have the access to do this. If I can use the exe it has to be in its current form. It is something that is used by a couple of apps that allow users to query Sybase without having to enter their...

Hi Sajan, thanks for the suggestion. It crossed my mind but I am looking for a solution that is contained within the vba that won't leave text files lying about.

Hi, Does anyone have any pointers on how to grab the text output of an exe. Scenario is that I have access to run an exe which when I run in my cmd window will give me my name. If someone else runs it from their machine it will display their name, seems perfect for putting into vba queries...

I do believe this is working well, I'm grateful for all input. Thank you very much.

I think I have that offset working with: Dim numRows As Integer Dim role As Variant Dim login As String Dim c As Range numRows = ActiveCell.CurrentRegion.Rows.Count For r = 2 To numRows perm = Worksheets("Sheet1").Cells(r, 5).Value login = Worksheets("Sheet1").Cells(r...

Just saw your post Luke, we must have been posting at the same time. Will have a look at that too, thanks.

Thanks Hui, I think I tried to be to clever in changing my data in the name of discretion and end result is I've made it more confusing than it needs to be. The condition I am trying to meet is if a 'Login' has a 'Role' then remove a row with this 'Permission' listed in it. So my code with...

Hi, Hoping someone might be able to put me on track for something to replace the VLOOKUP in the following code. It works, but not if the situation has multiple ‘var1s’ for one entry Dim numRows As Integer Dim var1 As Variant Dim var2 As String numRows = ActiveCell.CurrentRegion.Rows.Count...

Thanks Luke, and on the backtick mark too :)

Hi, Looking for the correct way to translate =countif(u2r,cellvalue) to vba. u2r being a named range. I currently have the following which has been bodged into different variations. Dim numRows As Integer Dim c As Double Range("A1").Select numRows =...

Doh, pivot table was using 2 row labels, move one to the Column label.

Hi, Seems like a simple thing to do but it seems to be eluding me. Hoping for a pointer at how to remedy it or a link to somewhere I can read about doing it. I have a pivot small pivot table that has numbers in first column, 1, 2 and 3. The data in the second column is grouped by those...

Is excel meant to be able to handle more than one xlam? I am trying to run at least 2. One called Dev for working stuff out and at least one more that gets published out onto the network for a given team to use. If I add 'Dev' I don't see it by it's proper name of Dev in the...

Just had to do something similair, I used the following which is probably not the cleanest but the import itself came from just hitting record macro button. 'Opens file browser to select file Dim fn fn = Application.GetOpenFilename If fn = False Then End End If 'Creates...

That's bang on, works perfect! :D Tequilas all round!

Will mess about with it but I imagine in the short term the fix may lie in something to do with ElseIf cal > 1 OR (find some year calc that will decide if it is forward of this year) Then Move to Future ElseIf cal < -1 OR (find some year calc that will decide if it before this...

How would you like to up that beer to a tequila? I'm just realising that anything pre January of this year is actually appearing in my 'Future' sheet which catches everything further than next week rather than the 'Past' sheet which is used to catch everything from before last week. Is there...