Hi, I have a spreadsheet which runs several macros, each one opening xls file and saving as csv, or opening txt file converting to xls using delimiters. Each time it save a file I have to confirm to save... is there any way i can side step this confirmation process so I can remove human intervention?
arun soni
Last edited by soniarun; 06-12-2008 at 08:10 AM.
one method
use this command before the save command
and this one after the save command
Please Login or Register to view this content.
Please Login or Register to view this content.
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
Thanks, will give it a go.
IT WORKS FOR XLS AND CSV
(Edited original)
Thanks Mudraker
Last edited by soniarun; 06-12-2008 at 09:11 AM.
How? Where?Originally Posted by mudraker
one method
use this command before the save command
and this one after the save commandPlease Login or Register to view this content.
Please Login or Register to view this content.
boomobile
If you read through the various postings of the thread it is very clear how & Where
If you do still do not not undertand the how & when then I suggest you read and follow rule 2 of the forum rules - see link below
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks