Saving copy of an open Workbook......

**vvujke** · 04-27-2012, 09:52 PM

Hi,

I'm new with VBA nd like any other rookie, have tons of problems

Basically my idea is when someone open default file, insert data, and when he/she try to save file, macros save workbook with inserted data as another file (*.xlsx) with name whose parts are from cells of the workbook and make pdf in another folder. Pdf part is working fine, but with second part just can't find right option. I've tried various code examples but mostly reward was error announcement. Really need help

Please Login or Register  to view this content.

Thanks guys for your time
P.S Sorry if i've made any language mistake

**vvujke** · 04-28-2012, 02:30 AM

anyone? really need help

**john55** · 04-28-2012, 03:48 AM

try this

Please Login or Register  to view this content.

**vvujke** · 04-28-2012, 04:02 AM

Hi John, thank you on your replay. I've just noticed that I have accidentally copy/pasted wrong first line of code. My code is :

Please Login or Register  to view this content.

and my regular result is Run-time error '1004': method 'SaveAs' object '_Workbook' failed. I've searched the treads and found couple replays that pointed to http://www.rondebruin.nl/saveas.htm but I still can't find a solution. Thanks again for replay

**vvujke** · 04-28-2012, 04:13 AM

Hi John, thank you on your replay. I've just noticed that I have accidentally copy/pasted wrong first line of code. My code is :

Please Login or Register  to view this content.

and my regular result is Run-time error '1004': method 'SaveAs' of object '_Workbook' failed. I've searched the treads and found couple replays that pointed to http://www.rondebruin.nl/saveas.htm but I still can't find a solution. Thanks again for replay

**john55** · 04-28-2012, 04:19 AM

hi,
I tried yr code and it works very well....see the file attached

**vvujke** · 04-28-2012, 04:48 AM

Thanks John a lot, I've managed to see what was the problem, my default value in referring cells was [100] and brackets caused all the problems.hahaha typical rookie stuff.
When i tried file now i spotted few things that i wood like to improve , maybe you already know exact code

I would like to avoid:

"Open as read only.." msg on the start of the initial file,
leave macros enabled,
do you want to save changes to initial file when want to close it,
and in cell F7 i have Today function, which i would like to leave as date only in a copy of workbook.

Also, when i try to save copy, save as window popout two times, can it be reduced to one?

Thanks again a lot and have a nice weekend