Hi,
I have posted this on the access group too, it can't really be
classified as one or the other, but it's driving me mad, can anyone
help.
I have an Access 2010 database, which I have saved as .mdb. (ie not
accdb)
It has an update query in, which takes 2 string parameters. When I run
it from
thanks - it's a long story but basically I'm trying to export some sheets
from a workbook with loads of code behind it. I wanted to use move/copy
originally but it takes the vba behind the sheets with it. (Which I don't
want).
So I wrote a function that just deleted all vba code in the workbook
don't worry, I worked it out using 2 lines of code, pastespecial values then
formats - would be nice to do it in one but I'm not that fussed... For some
reason I had convinced myself doing it a second time would wipe out the
number
--
---
Hi,
Do you have any code so far that I can help you with or are you starting
from scratch?
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldai
what happens if you just rename the .txt file to .csv and open in Excel...
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our
Hi,
This is driving me crazy, can someone help!
I have a nice pretty worksheet, all coloured in and stuff - all I want
to do is select all the cells and copy - then paste into a new
workbook.
I can do all of this, but it seems when using pastespecial I have to
select values (because these cells
