Mike
Okay I did Prince 2 some years back - a 5 or 6 week course would you believe and since then I have never used the full blown thing because very few of the customer base have any interest in taking up any Prince role responsibilities and most of the rest of the IT staff are too busy...
Learning new skills is supposed to keep the grey matter in good nick - perhaps something that is not so work orientated like competitive Duplicate Bridge. Also physical exercise to keep the blood flowing - Karate or Dancing perhaps.
TipGiver
Thanks - I remembered that after I posted [blush].
Thanks to Skip's advice on using interior instead of font the code now does what I want.
For c = 0 To icols
For r = 0 To irows
FlexDatesDays.Row = r
FlexDatesDays.Col = c
rplus = r + 1...
skip
this code
xlSheet.Cells(10, 10).Interior.Color = vbGreen
does exactly what I want outside the loops but not when I use it inside the loops using the r and c variables - so I have a little more work to do.
But you have answered my question so thanks a lot and have a star.
Dteve
skip
I'll try what you suggest and see what happens. Thanks for the prompt reply.
After I posted I remembered that if you start a macro in Excel you can examine the code - so I did that and got
xlSheet.Range("G1", "G7").Select
With Selection.Interior
.ColorIndex = 4...
I am working on dumping the contents of a flexigrid to an Excel spreadsheet and I want to change the colour of some of the cells.
I have some crude code that works after a fashion:
Set xlApp = New Excel.Application
Set xlBook = xlApp.Workbooks.Add(xlWBATWorksheet)
Set xlSheet =...
Does anyone expect an accurate answer? Its just cliché level of communication. Why not ask "do you have a STD?" you are just as likely to get an honest answer.
What's wrong with good morning or good evening?
I used to love the Gruss Got used by Bavarians to complete strangers met out walking...
blutekhnd
Have you noticed that when an 'interesting' word is replaced with another it is usually a case of a multisyllabic word being replaced by a monosyllabic word?
Whether this is related to a general dumbing down in education or a desire to live more speedily than in the past - I don't...
Thanks Ghodmode
I've been programming for a long time and I agree that there are many shared concepts between programming languages. However it is not always possible to guess syntax and that was what I was after and I thank the responders for taking the trouble.
I've had no contact with perl...
Did you hear about the cross-dresser who claimed in his defence (in court) that he "couldn't have done it because he was a broad at the time"?...
yes it is very, very dated
Paul
Thanks a million - that is the syntax that I have been after. The laptop with the perl.exe is due next Friday so I'll be able to test then.
Thanks again
Steve
Paul
Thanks for the code example. We won't be expected to tinker with the perl script that is being supplied. What I really want to know is what I need to run it. I am thinking of running it from VB and I wonder if it is as simple as;
Dim RetVal
RetVal = Shell("c:\blah\perlscript.pl,param1...
That explains a lot. Apparently large numbers of people think the world is less than 10000 years old, and large numbers of people think it is billions of years old. So either side would judge the other's views to be examples of truthiness - I suppose?
But is truthiness supposed to be a 'good'...
Paul
Thanks for answering. If a perl script needs as input 2 files and the path to these is not hardwired in the script what would be a standard way to supply the location of these 2 files as parameters - if you were running the perl script from Start->Run. I want to to test that from some VB...
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.