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
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
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...
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
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...
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...
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
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...
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
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
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 &...
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.