Issue with VBA - Save as macro enabled workbook - address problem.

**galvinpaddy** · 07-09-2012, 01:34 AM

Morning happy campers,
I'm not entirely sure if you can sort this -

I have the following code that should copy the selected tab, paste into new workbook, save this workbook to the designated location, then close it.

Please Login or Register  to view this content.

However, the following line is highlighted in red.

Please Login or Register  to view this content.

Would anyone be able to have a stab at this for me?

Regards, galvinpaddy

**royUK** · 07-09-2012, 01:47 AM

Your code doesn't specify the Drive, maybe this will work

Please Login or Register  to view this content.

**galvinpaddy** · 07-09-2012, 01:50 AM

Hi Roy,
Thanks for the, the drive is W:
My original code contained the address

Please Login or Register  to view this content.

and was told it needed to be the way it currently is, but i will give it a shot now and try

regards

**galvinpaddy** · 07-09-2012, 01:52 AM

HAHAHAHA, (wait until the IT 'EXPERTS' get back on site)
you sir are a legend.
Mate, many many thanks for that, really, REALLY appreciated indeed.

Kind Regards
Galvinpaddy
**Edit***
Is there anyway i can stop the code from showing the attached message?