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...
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)
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...
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...
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!
:-)
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...
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.
:}
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...
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"...
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...
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.
:}
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.