Replies

You can use the Charater Map too to find your symbols, this will also give you their Key Stroke number – “alt 0178” for the superscript 2. These can be entered directly into the edit line

HTH

Peter

A second thought on this is whether it is possible to get the format of the date in the .CSV file changed to either the number format that Excel uses for dates or to a Long date format that could not be misinterpreted. i.e.

I had a similar problem copying from word and pasting to Excel by code. The way I worked around it was to use sendkeys “ctrl V” to do the pasting. Maybe you can do something similar with the macro?

Not sure quite how to do it all, but rather than try to find the last Row used I would make a lookup table listing the rows used in a block and calculate the row number requierd from that

HTH

Peter

7 hrs 48 mins = 0.325 of a day

0.325 * 24 = 7.8 hrs

You just need to change the number format to “Number” and set you decimals to suit your preference

At least using Decimal hours makes it is a lot easier to do maths on!

Peter

You wrote “You can put an unbound control into the detail section of the report, make it zero height and hide it by making its foreground, background and border colors all white …”

Is there an advantage in hiding it this way rather than just setting its visible property to false?

Peter

yes, but the lack of choice still means that the only way I have of sending a report electronically is to get everyone concerned to download and install the SnapShot viewer. HTML could just have been put on a read only drive if there was thought to be a problem with meddling fingers.

I like Snapshot, but would have liked more choice as well! have things improved at all in versions after 2k?

Peter

If you are copying the same amount of data each time you could use an array formula to add the column
{=SUM(VALUE(E6:E10))}

HTH

Peter

I can see why they did not use PDF for it but I cant see why they could not have a decent HTML export though.
PowerPoint quite happily exports graphs and things in to it!

Peter

Perhaps I should just forward it to “All Users” on the network and point them towards IT?

one thing to double check is that the named range is actualy looking where you think it is, as looking outside of the range would give an #VALUE error

Peter

I suspect it should be more like
DLookUp(“refNum”,”NewQuery”,”[refNum][NewQuery]![ReferenceNumber]”)

Using will most likely just give you the first refNum in the table each time though!

Peter

Thanks for the formula Aladin.
Took me a while to work out what it was doing
I have got it tweaked to fit my setup now, just need to replace a couple of hundred formulas now!

Many thanks

Peter

RightClick over the button and select “View Code”.
You will need to toolbox toolbar showing and the “Design Mode” button selected to do this.

Peter

I don