Replies

TY, I will go read that thread

Peter

Now you have the data in Access have you tried using Access to convert it back to numbers, dates etc.??

Peter

Can’t you just add the new records to the end and then sort them to the right order?

Peter

I have not tried it with a web site as such, but the saved Querys work and a html file on my harddrive linked in Ok

Peter

I have xl2k, I can get the external data ok if I know the path, I just cant use explorer to browse for it.

Peter

Yes, I am using IE5 under Win2K. be a job to browse this lounge with out one!

Peter

I went to Data | Get external data | NewWebQuery, hit the browse button and go a Message
“To use this feature, you must have a World Wide Web Browser such as Microsoft Internet Explorer” !!

Wonder what I have broken now?

Peter

Thanks again. will just go tidy up now

Knew that there had to be a proper way of doing it

Peter

Many thanks

This has done the trick and I can get on with the next bit of the puzzle now

on quick check though, I take it that I no longer need the
Set WordApp = Nothing ‘ clear the reference.
statement any more?

Thanks again
Peter

It looks like Shane probably had the right idea in using theTag Property to let you check for info abut the control, then decide if to leave locked or unlocked!

Peter

I have the same problem with Paste Special as I did with the normal paste method in code.
Excel ignores regional setting when you paste in code so that Currency

on an old dot matrix printer I used to get around it by setting a custom page wider than the real page which let me print to the edge. not sure what would happen to your page lengths if you tried it though

not sure how to do it properly so I used reverse logic
Formated the cell to a white font and used Conditional formating to turn if black if greater than -1!!

Of course you would have to pick a number out side of the possible range for you data

Not sure how to send the sheet back to the forum though

Could you use conditional formating to hide the font when NA#, White on White?

Peter