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!

  • Congratulations SkipVought 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. Woolers

    HTA iframe Content?

    Hi There, Apologies if this has cropped up elsewhere, I did a search but couldn't find anything.. I found some code that launches an explorer type window inside an HTA & amended it, but it uses an iframe to load the content. - What I'd like to do is to return the value (name, path) of a...
  2. Woolers

    Excel find/add

    Sorry, let me clarify: strNewPath = "DestinationWorksheet.xlsx" Set objWorkbook1 = objExcel.Workbooks.Open("TargetWorksheet.xlsx") Set objWorksheet1 = objWorkbook1.Worksheets(1) Set objWorkbook2 = objExcel2.Workbooks.Open(strNewPath) Set objWorksheet2 = objWorkbook2.Worksheets(1)
  3. Woolers

    Excel find/add

    Hi Guys, I have the following script that looks in 1 excel sheet, then looks in another sheet for a matching server name, then will append certain information if found. I think it's working fine, but wondered if there was a quicker way to check as it runs quite slowly? Perhaps there's a better...
  4. Woolers

    Find/Replace?

    Blister911 You Sir, are brilliant!! - it's now working like a charm.. I used the switch code in it & boom! Thank you very much indeed!! :) Woolers
  5. Woolers

    Find/Replace?

    Hi blister! Totally forgot about this until now! - Yes I'm afraid it still seems to be showing duplicates... I'm clearly not good with powershell! Here's the code:: $change_name = "SERVER1" $change_name2 = "SERVER2" $change_name3 = "SERVER3" $new_name = "O365 - Mobile Device/iPad/Android"...
  6. Woolers

    Find/Replace?

    Hi Blister, Just FYI, this seems to be working fine, however it's outputting twice now.... with the original machine, then the replaced name.. So the output looks like this TimeCreated User Name Client Name ----------- --------- ----------- 26/02/2016 07:51:05 lockeduser LockedOutMachine...
  7. Woolers

    Find/Replace?

    Hi Blister, That certainly looks like it will work! As soon as I come across a user that has been locked out via our ISA box I'll give it a try! Many thanks for pointing me in the right direction! :-)
  8. Woolers

    Find/Replace?

    Hi Blister, So this script grabs events from locked out user accounts & outputs the format as follows: TimeCreated User Name Client Name ----------- --------- ----------- 26/02/2016 07:51:05 lockeduser...
  9. Woolers

    Find/Replace?

    Hi guys, I'm using the following that i've cobbled together for helpdesk to get info on account lockouts... what I'm not too sure about is that when it outputs a specific servername (as 'Client Name'), i.e. OURISASERVER - I want it to replace that field with "Mobile Device"... I'm just not...
  10. Woolers

    Marquee iFrame Sizing Problem?

    Do you have any advice on what the best way to accomplish this might be at all? I only need to scroll some text from an external page.. fundamentally very simple I suspect but I just don't know where to start?? TIA Keyboard Not Detected..... Press F1 to Continue. :}
  11. Woolers

    Marquee iFrame Sizing Problem?

    Hmmm thanks traingamer.... I'm really searching for any kind of page way to do this, I'm good with vbscript but haven't got a clue when it comes to doing something that can be displayed in a webpage. Doesn't have to be html but that seemed the most abundant thing when I ran web searches on...
  12. Woolers

    Marquee iFrame Sizing Problem?

    Hi Guys, I was wondering if anyone has come across this issue before? I found some code for a webpage that looks like this>> <MARQUEE id="m1" style="BORDER-TOP-WIDTH: 1px; BORDER-LEFT-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; BORDER-RIGHT-WIDTH: 1px" scrollAmount="4" width="75"...
  13. Woolers

    Help with Dates??

    Anyone ?? Keyboard Not Detected..... Press F1 to Continue. :}
  14. Woolers

    ASP Newbie Question

    Anyone ??? Keyboard Not Detected..... Press F1 to Continue. :}
  15. Woolers

    ASP Newbie Question

    Oh, it's line 14 causing the problem.. Keyboard Not Detected..... Press F1 to Continue. :}
  16. Woolers

    ASP Newbie Question

    Hi All, I'm very new to all this .NET but am good with vb script. Anyway, I'm trying to get round the 2GB Limit of uploading & so have cobbled together a get around script that will be used internally (with the help of googling for the right scripts.. I have a webpage (default.aspx) that has...
  17. Woolers

    Help with Dates??

    The front end tool is a bespoke helpdesk system that I think is based around Crystal Reports but not too sure - but it does rely on the date format being exactly as above, it cannot take the date format in any other way unfortunately.... Keyboard Not Detected..... Press F1 to Continue. :}
  18. Woolers

    Help with Dates??

    No it's a proprietary helpdesk system based on SQL... The people that develop it won't help us, as they say the SQL can't be done manually but I know enough to know I can run the manual query in the software & use profiler to record the SQL which is where I got it in the first place :) I can...
  19. Woolers

    Help with Dates??

    RiverGuy, Unfortunately the query needs to follow the format above but I could probably substitute having to type in the values manually if I could get something in between the quotes... i.e. at present it states { ts ' 2008-07-30 00:00:00'} Now I know I can use the following statement to...
  20. Woolers

    Help with Dates??

    Hi All - I have the following code as part of a query string on a database: Request.LoggedDate >= { ts ' 2008-07-30 00:00:00'} And Request.LoggedDate <= { ts ' 2008-07-30 23:59:59'} However, the date/time value has to ben entered manually. Is there a way that the value of this between the...

Part and Inventory Search

Back
Top