Replies

Spot on Hans!
As always – the question is easy…… when you know the answer.
My search for XLDialog was obviously too restrictive and didn’t return that particular thread.
Many thanks
Alan
Cheshire
UK

In cell C8 I have entered
FIRE EXTINGUISHER

In cell C8 I have entered
FIRE EXTINGUISHER

Apologies and thanks Hans,
My foot is now lodged in my mouth. I was distracted a little by there being no number 4’s and compared them to my original coding – kind of like 2+2=5.
Just redone the code in two subs and it works fine.
Many thanks and I appreciate your patience.
Alan
Cheshire UK

Apologies and thanks Hans,
My foot is now lodged in my mouth. I was distracted a little by there being no number 4’s and compared them to my original coding – kind of like 2+2=5.
Just redone the code in two subs and it works fine.
Many thanks and I appreciate your patience.
Alan
Cheshire UK

Sorry to be a pain but I can’t see the application of that code in my scenario. The array which I am trying to bring in is in typically a csv type file but with pipe separators. The defined array as in the original sample coding can be explained as:
Array(1,2) – this is first column and is to be imported as “General” format
Array(2,2) – this is second column and is to be imported as “Text” format
….
Array(17,4) – this is the seventeenth column and is to be imported as “Date” format
….
Array(54,2) – this is the fifty fifth column and is to be imported as “Text” format

etcetera.
First number is column number and second number is:
1 = General format
2 = Text format
4 = Date format

The formats of the columns are already specified from the original transfer.
Hence my problem is that I need the separate array components to be of 2 values, the second of which needs to be defined and not incremental or to any pattern.

Hope this sounds clear.

Is multi-dimensional arrays the answer??

Sorry to be a pain but I can’t see the application of that code in my scenario. The array which I am trying to bring in is in typically a csv type file but with pipe separators. The defined array as in the original sample coding can be explained as:
Array(1,2) – this is first column and is to be imported as “General” format
Array(2,2) – this is second column and is to be imported as “Text” format
….
Array(17,4) – this is the seventeenth column and is to be imported as “Date” format
….
Array(54,2) – this is the fifty fifth column and is to be imported as “Text” format

etcetera.
First number is column number and second number is:
1 = General format
2 = Text format
4 = Date format

The formats of the columns are already specified from the original transfer.
Hence my problem is that I need the separate array components to be of 2 values, the second of which needs to be defined and not incremental or to any pattern.

Hope this sounds clear.

Is multi-dimensional arrays the answer??

Thanks for the prompt replies. The solution given will resolve the problem and I appreciate another fresh pair of eyes to be able to help it along.
As with most of the excel problems the words “cat”, “skin” and “many ways” spring to mind.
Using the NOT compare was something I hadn’t tried and the rounding will indeed cut out the error problem, but it doesn’t exactly explain why it throws a googley.
I have resolved myself to the fact that in future I should really only be working in whole integers and save the decimals for the final summation.
Once again many thanks.
Alan
Cheshire
UK

Thanks for the prompt replies. The solution given will resolve the problem and I appreciate another fresh pair of eyes to be able to help it along.
As with most of the excel problems the words “cat”, “skin” and “many ways” spring to mind.
Using the NOT compare was something I hadn’t tried and the rounding will indeed cut out the error problem, but it doesn’t exactly explain why it throws a googley.
I have resolved myself to the fact that in future I should really only be working in whole integers and save the decimals for the final summation.
Once again many thanks.
Alan
Cheshire
UK

Magazine in the UK called PC Plus (http://www.pcplus.co.uk) ran article on vinyl transfers a couple of month ago. You may want to check their site ‘cos they do run free software now and then.
Alan
Cheshire (currently very sunny)
UK

In XP Professional there is the Power Toys option of having the display change every 30 minutes or so. I recently downloaded the power toys in hope of making screen more user friendly. It had the opposite effect and became very annoying until I realised what was happening and ran the power toys option from Program>Windows XP Power toys.
When you open the application you’ll see that you can spec the display to change to a picture from your pictures folder or have the screen stay precisely as you choose it.
Hope this helps.
Alan
Cheshire
UK

Hi Gary,

There’s no argument about it, you are quite right in saying the For ..next is more efficient when running through a range
The reason I used the do..loop in some of my current “adopted” projects was because up until about a week ago I was ignorant of the fact that I could re-assign the used range of a worksheet using “activesheet.usedrange” and hence for some of the worksheets that were coming my way I had less than 5~10 k rows of data but the used range extended to the 65k row in the worksheet.

Alan

All three programs you mention are pretty much fine for developing web pages. However, as you get into it in a more teckie kind of way you’ll realise from the code generated that each of these programs also comes with a helluva lot of dross code in the final output.
You may want to try a free program to begin with such as evrsoft. I can’t remember the link at this moment in time but its a starter for ten and its free and I personally used it for some time before assessing other packages such as dreamweaver (my now final choice and installed software), allaires home page and front page et al.
Basically, they all do the same thing except some do it with extra bells and whistles, but for a company site, try evrsoft for a start.

Sorry guys, I’ve joined this after the horse has bolted etcetera but thought the following may be “helpful” in a devils advocate kinda way:
set the following code in say “before_right_click” event
in top of list when right clicked the following code runs pretty smoothly, catching all rows (providing theres no blanks mid range)
Do
if activecell.value = “MyValue” then
activecell.entirerow.delete
else
activecell.offset(1,0).select
end if
loop until activecell.value = “”

Alan
cheshire
UK

Both replies are very valid on their own merits.
I personally have used both methods when sharing information in a technical authoring/doc publishing company.
The advantage of pdf is that, given the correct usage, you can restrict printing of the files by setting the security when first creating the pdf PLUS the pdf document is laid out exactly same as the word document.
The disadvantage is as pointed out previously, the file sizes can be quite large, but if you separate into chapters, and use an index link page for the creating links then it works fine, however,……if your company has a couple of strange fonts or logos, be sure to include the fonts with the file when creating the pdf. All the settings are changeable when running the distiller (if you use acrobat that is).
When you use html, you have to accept that people can and will cut/paste/copy/print many copies (because their new 21 inch screen has not arrived from the IT department yet) and generally send a bucket load of critiques about the layout of the original word document not being the same as the printed intranet version.
Me? Cynical? Its another word for experience.
Best of luck
Alan
Cheshire
UK