Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Excel Open, Close, Save, SaveAs Arguments in VBScript

Reply
Thread Tools

Excel Open, Close, Save, SaveAs Arguments in VBScript

 
 
Mark Ritchey
Guest
Posts: n/a
 
      12-10-2003
I don't know if I am sending this to the right place, but
I have looked everywhere and have not found anything. My
question is this.

I am trying to Open a Excel Spreadsheet that contains
macros and when I open the document with VBScript it halts
because of the Prompt asking me if I want to enable
Macros. So, I was wanting to know if there is a way that
on the objExcel.Workbooks.Open Path what other arguments I
can add and the syntax behind that. I was hoping that
there is a possiblity that I can add to that OPEN command
and an argument that will automaticly open the document
enabling the Macros.

Also does anyone know what and if there are arguments for
the Close, Save, and SaveAs commands.

I would more than appreciate the help!

Thanks,
Mark Ritchey
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
SaveAs excel Dialog and IIS ConnectionTimeOut N. Shehzad ASP .Net 2 04-22-2010 09:08 AM
SaveAs excel Dialog and IIS ConnectionTimeOut N. Shehzad ASP .Net Security 0 04-20-2010 05:11 PM
Problem with Excel reports ::::Excel 2003 Migration To Excel 2007 =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?= ASP .Net 15 10-24-2007 01:34 PM
Silent SaveAs when using the Excel win32com module Chris Python 3 09-10-2007 10:41 PM
Using the SaveAs in Excel not working with Ruby anon1m0us@yahoo.com Ruby 5 12-12-2006 08:57 PM



Advertisments
 



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57