Posted to microsoft.public.excel.programming

Mike H.

external usenet poster

Posts: 471

Problem in exporting to csv

After exporting,

ActiveWorkbook.SaveAs FileName:=X, _
FileFormat:=xlCSV, CreateBackup:=False
ActiveWindow.Close , savechanges:=False

Then you would be where you were before you added this workbook. But if you
must go someplace else, you could explicitly return somewhere else:

Windows("FirstFile.xls").Activate

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
exporting to excel problem	Medes	Excel Programming	0	October 8th 06 10:40 PM
exporting to excel problem	Medes	Excel Programming	0	October 8th 06 10:40 PM
Problem exporting as csv file	Felicity Geronimo	Excel Programming	2	December 8th 04 03:39 PM
Exporting To Excel With ASP - Number Problem	williamsd	Excel Programming	8	March 6th 04 06:10 PM
Exporting to Excel using ASP Problem	jtk7622	Excel Programming	0	November 17th 03 06:20 PM

All times are GMT +1. The time now is 08:48 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us