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 Chris 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. HVtech

    Replace multiple pics in Excel

    Thanks a lot, Skip! Great and fast help!! Office 2013
  2. HVtech

    Replace multiple pics in Excel

    O sh*t... I forgot.. there is one "shape" that needs to remain there, is called "Grafiek 38" Sorry Skip.. can this be excluded from the Sp.delete routine (which is working fine btw..) Office 2013
  3. HVtech

    Replace multiple pics in Excel

    Ok, inserted the header pic, recorded as a macro, working fine. One problem to go, the removal of the old pics, where the first is namen "Picture 29", all others are named "Group 28" Can you assist me on that? Than I can combine all parts code to one. Thanks ! Office 2010
  4. HVtech

    Replace multiple pics in Excel

    You're talking chinese.. don't understand what you mean.. sorry Office 2010
  5. HVtech

    Replace multiple pics in Excel

    Hi, I have a sheet with mutiple (same) pictures on it, so when this sheet is printed, the picture (kind of logo) sits on top of every page. Now I want to change those pictures with a new logo with a macro. I tried this piece of code I found, but it's nit quite what I need. Also , i have to run...
  6. HVtech

    Forms.js not working

    Ok guys, thanks, I will try to implement your suggestions. Thanks for supporting! Office 2010
  7. HVtech

    Forms.js not working

    Thanks Phil for your respons, I do have JQuery loaded <script type="text/javascript" src="js/jquery-1.6.js"></script> Also Firbug is installed, but I don't understand what to do with it.. sorry.. Would it be possible to test the script? Should I post the php script as well? Office 2010
  8. HVtech

    Forms.js not working

    ...]+[a-zA-Z']?$/,target:'input'}...
  9. HVtech

    Create user in AD from csv in OU by variable

    It's working!! Thanks man, you saved me..:-) Cheers and Happy Eastern. Office 2010
  10. HVtech

    Create user in OU, set with variable

    Ok thanks, posted in the correct Forum. Office 2010
  11. HVtech

    Create user in AD from csv in OU by variable

    Hi all, I am trying to create users in a specific OU, which should be read from a csv file. This is a line from the csv: AAipuk1111,Aai,Puk,Welkom2012,HVServ.local,Users,Aai Puk,TopOU,SubOU VBS script: ' --------------------------------------------------- ' Script: createusers2.vbs ' Input: It...
  12. HVtech

    Create user in OU, set with variable

    Hi all, I am trying to create users in a specific OU, which should be read from a csv file. This is a line from the csv: AAipuk1111,Aai,Puk,Welkom2012,HVServ.local,Users,Aai Puk,TopOU,SubOU VBS script: ' --------------------------------------------------- ' Script: createusers2.vbs ' Input: It...
  13. HVtech

    Increment value

    Oke, will see how far I'll get for now. Probably have to start over with the sorting buttons. I'm tired, so going offline for now. Thanks very much for your time and support!! Office 2010
  14. HVtech

    Increment value

    Manually... copied the code to Notepad++, made a macro in Notepad++ and ran that to the orignal 180 (or so) lines, then copied back those lines to excel. But... now the whole sheet loops corrupted.. Sorting the column gives a 400 error (whatever that may be..) Are you willing to give a deeper...
  15. HVtech

    Increment value

    Ok, will keep that in mind! :-) Office 2010
  16. HVtech

    Increment value

    OMG.. I'm embaressed.. Well that was the easy part.. LOL As you can see in the sheet, in column A are numbers hyperlinked to direcories. How can I increment the number in this hyperlink? Office 2010
  17. HVtech

    Increment value

    on its way.. thanks Office 2010
  18. HVtech

    Increment value

    No.. Like I said, no more errors, but also no hyperlink in C column. You get hyperlinks in column C when you run the code?? Maybe I should attach the workbook?? Office 2010
  19. HVtech

    Increment value

    O yes I did! This is the code with semicolon's which gives error: .Cells(lRow, "C").Formula = "=IF(B" & lRow & "<>"""";HYPERLINK(""#(N" & lRow & ")"";""view notes"");"""")" This the substituded code > semicolon replaced by comma's: .Cells(lRow, "C").Formula = "=IF(B" & lRow &...
  20. HVtech

    Increment value

    Yep.. .Cells(lRow, "C").Formula = "=IF(B" & lRow & "<>"""",HYPERLINK(""#(N" & lRow & ")"",""view notes""),"""")" Office 2010

Part and Inventory Search

Back
Top