Advertisement

06.13.2008 at 09:42AM PDT, ID: 23483314
[x]
Attachment Details

quit

Asked by RVL in Microsoft Excel Spreadsheet Software

Hi
This part of the macro works but would like to quit excel and replace the existing file.Start Free Trial 
1:
2:

Sheets("New_Item").Application.DisplayAlerts = False
Sheets"New_Item").SaveAsFileName:="G:\ANALYSIS\Kroger\TEST_DATA\new_items.dbf", FileFormat:=xlDBF4, CreateBackup:=False
[+][-]06.13.2008 at 09:52AM PDT, ID: 21780695

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Microsoft Excel Spreadsheet Software
Sign Up Now!
Solution Provided By: saurabh726
Participating Experts: 2
Solution Grade: A
 
 
[+][-]06.16.2008 at 04:42AM PDT, ID: 21792554

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628