Hi bhwithun sorry for getting back to you so late... I have already created and saved the target file... its in the same folder and pathway as the operating excel workbook and the source workbook.
I could create a new file as I dont mind where the bas file ends up ... in fact the bas file can stay in the source file directory for me to import into the appropriate file later.
This is where it stings - I am still getting the same problem with finding the source file... which is essential.
To cut things short though.... if i cant open the file manualy - will I have the same problem when I try and extract the module as a bas file. I think I may have to go back the drawing board and re-write the code from scratch ... ho hum
let me know if you can think of anything :)
Thanks
N
I





by: bhwithunPosted on 2009-04-24 at 20:14:01ID: 24230650
Is your TargetWB supposed to reference a new file, or an existing file?
if you want Excel to stop prompting the user for a filename.
If it's supposed to be a new file, I seem to recall that you CANNOT name a workbook UNLESS you save it.
By that I mean, it will be called "Book1" (or "Book2" or whichever next sequential number) and you can't change that name except by actually saving it to disk.
Try creating your workbook using Workbooks.Add(), and then later .SaveAs() at which time you can give it a filename and path.
Read up on Application.DisplayAlerts,
Select allOpen in new window