LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default SasAs Issue: Automation Error

When i use the xlWorkBook.SaveAs(fileName,
Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue,
Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue,
misValue); it was giving me an error.


The issue got resolved when i changed the code to following
xlWorkBook.SaveCopyAs(fileName);
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Sever side excel automation issue djcohen66 Excel Programming 2 July 18th 09 12:47 AM
programming issue when using Excel automation Jack Excel Programming 8 July 2nd 08 01:11 AM
Continue to have issue with array in Subtotals automation robs3131 Excel Programming 2 December 9th 07 02:17 AM
Automation issue Dimmer Excel Discussion (Misc queries) 1 June 30th 05 11:38 AM
Excel Automation Issue Matthew Wieder Excel Programming 4 September 8th 03 06:26 AM


All times are GMT +1. The time now is 06:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"