Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JPJeffery

    Hiding an Excel workbook loses focus

    Is .Activate a better choice? I'm asking because the line wsAdvancedFilter.Range("A1").Activate produces that "Run-time error '1004': Activate method of Range class failed" error when I have wbNewReport.Windows(1).Visible = False in operation... Here's the full sub (and yes, I know I've not...
  2. JPJeffery

    Hiding an Excel workbook loses focus

    Nice! Thanks, both. I appreciate all your help (as I strive to learn how to VBA properly). JJ Variables won't. Constants aren't There is no apostrophe in the plural of PC (or PST, or CPU, or HDD, or FDD, or photo, or breakfast...and so on)
  3. JPJeffery

    Hiding an Excel workbook loses focus

    Totally agree! It does feel like a very bad habit (born from starting with recorded macros). Top quality staring! :-D ...because you're right,, that's exactly what it does. I didn't bother pasting the array code, but for completeness, here it is: Public arrColumns(1 To 10) As String...
  4. JPJeffery

    Hiding an Excel workbook loses focus

    Sub CallsReport_01_Add_AdvancedFilterSheet() Set wbNewReport = Workbooks.Add wbNewReport.Windows(1).Visible = False strNewReportName = wbNewReport.Name strNewSheetName = "AdvancedFilter" sub_RenameSheet strNewReportName, strNewSheetName ' Create the Column headers...
  5. JPJeffery

    Hiding an Excel workbook loses focus

    Excellent idea (and I'd like to be similarly more explicit all the way through my code), but in this instance it just gives Run-time Error '438': Object doesn't support this property or Method The variable is defined as Public wbNewReport As Workbook JJ Variables won't. Constants aren't There...
  6. JPJeffery

    Hiding an Excel workbook loses focus

    Hi I have some VBA code code in a workbook for summarising a CSV file report. Let's call this workbook "Reporter" One of the first things it does is create a new workbook in to which all the data is imported, filtered, tidied/formatted and so on. All works well but even with...
  7. JPJeffery

    Golf Club Sign-In Sheets

    Firstly, apologies for not responding sooner, and thanks for the responses received so far. Well, I'm certainly a lot more confident with VBA in Excel than anywhere else, but I guess my concern is getting the final result to fit nicely on three separate A3 sheets (bearing in mind some of the...
  8. JPJeffery

    Golf Club Sign-In Sheets

    Hello Tek-Tippers! LTNS! My golf club (like most, if not all, other golf clubs) runs monthly competitions called 'Monthly Medals'. This competition is open for entry over three days, usually the Friday, Saturday, and Sunday of the second full weekend of the month (so 7th-9th at the earliest...
  9. JPJeffery

    Mapped drives script odd behaviour

    Thank you, both @strongm (Hey! How are ya?!) @gbaughma & strongm This script includes two required parameters. The first is the path to which the log file should be copied at the end of the script run. The second parameter is the number of seconds to wait before analysing what drives have been...
  10. JPJeffery

    Mapped drives script odd behaviour

    As you start reading this you might think "This is an AD issue! Why is he posting this here?!" Well, you might well be right, but this issue ONLY occurs with Windows 10 clients, though I grant you only then when the script is called from GPO. Anyhoo, please, read on. We have a logon script...
  11. JPJeffery

    Appending folder permissions

    It is bizarre. Because I've had to make progress I've had to lowered my puritanical approach to PS script coding and have worked out how to achieve the same thing using icacls calls from Powershell, so this isn't a show stopper. It really does seem to just be a problem here though, which is a...
  12. JPJeffery

    Appending folder permissions

    I've not incorporated any of your suggestions in to my script, I've only tested them from a Powershell console. So most recently as per your suggestions of 14 Feb 17 15:22. JJ Variables won't. Constants aren't There is no apostrophe in the plural of PC (or PST, or CPU, or HDD, or FDD, or photo...
  13. JPJeffery

    How to fix the IF/THEN statements?

    Just for laughs, I had a quick go at this in Powershell (because, VB is so last century! [wink]), and came up with... $sasVersion="8" if ( Get-ChildItem ".\" "run sas*.txt" | Where-Object {$_.Name -like "*9*"} ) { $sasVersion="9" } write-host "Run SAS $sasVersion" But I'm not...
  14. JPJeffery

    Appending folder permissions

    OK. BEFORE PS C:\WINDOWS\system32> $homeDriveACL = Get-ACL $FullUNCPath PS C:\WINDOWS\system32> $homeDriveACL.access FileSystemRights : ReadAndExecute, Synchronize AccessControlType : Allow IdentityReference : DOMAIN\SPsearch IsInherited : True InheritanceFlags : ContainerInherit...
  15. JPJeffery

    Appending folder permissions

    Alas no...its still replaces. JJ Variables won't. Constants aren't There is no apostrophe in the plural of PC (or PST, or CPU, or HDD, or FDD, or photo, or breakfast...and so on)
  16. JPJeffery

    Appending folder permissions

    Thank you. Well, no errors this time, but still not the desired effect. BEFORE: PS C:\> $homeDriveACL|fl Path : Microsoft.PowerShell.Core\FileSystem::\\SERVER\linter_u Owner : BUILTIN\Administrators Group : DOMAIN\Domain Users Access : DOMAIN\SPsearch Allow ReadAndExecute, Synchronize...
  17. JPJeffery

    Appending folder permissions

    No. :-( Set-ACL : Cannot bind parameter 'AclObject'. Cannot convert the "System.Security.AccessControl.FileSystemAccessRule" value of type "System.Security.AccessControl.FileSystemAccess Rule" to type "System.Security.AccessControl.ObjectSecurity". At line:1 char:40 + Set-ACL -path:$objACL...
  18. JPJeffery

    Appending folder permissions

    Most kind, thank you. I'll let you know on Monday. JJ Variables won't. Constants aren't There is no apostrophe in the plural of PC (or PST, or CPU, or HDD, or FDD, or photo, or breakfast...and so on)
  19. JPJeffery

    Completely remove server from the domain so another can take it's place

    Or, create an alias 'ServerA' that points to 'ServerB'. I'm not sure how that would work with SQL (this article suggests it should work quite well), but using aliases is the way forward. A file server might be called PLDNWINFS01 (Physical - London - Windows - File Server - 01) but you'll have...
  20. JPJeffery

    Delete User from Domain + Extras

    We take the approach of never deleting anything. When a user leaves we disable their AD account and move it to a 'Left Company' OU. This allows us to re-nable in the unlikely event they rejoin, and avoids any mysterious SIDs being left lying around on objects. Of course the latter point should...

Part and Inventory Search

Back
Top