Save As Problem

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

Save As Problem

Logged in as: Guest

arrSession:exec spGetSession 2,2,61852

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> WSH & Client Side VBScript >> Save As Problem
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

Save As Problem - 6/25/2008 6:48:31 AM

patgenn123

Posts: 37
Score: 0
Joined: 1/14/2008
Status: offline

Hello! Newbie here. This is a simple question and I think I am missing something here.

I am trying to save a "hidden" Excel file as .tsv.

Here is what I have:

Set objExcel = CreateObject("Excel.Application")
Set objWorkbook = objExcel.Workbooks.Open("C:\Documents and Settings\Pat\Desktop\ACT! Excel ole db.xls")
objExcel.Application.Visible = False

objExcel.ActiveWorkbook.SaveAs "C:\test.tsv"
objExcel.ActiveWorkbook.Close

objExcel.Application.Quit
WScript.Echo "Finished."
WScript.Quit

It's giving me some weird information in the text file. What am I doing wrong?

Thanks!

-P

Post #: 1

RE: Save As Problem - 6/25/2008 7:12:05 AM

dm_4ever

Posts: 2414
Score: 38
Joined: 6/29/2006
From: Orange County, California
Status: offline

Have you tried specifying the file format?

XlFileFormat
http://msdn.microsoft.com/en-us/library/aa221100(office.11).aspx

_____________________________

dm_4ever

My philosophy: K.I.S.S - Keep It Simple Stupid
Read Me: http://www.visualbasicscript.com/m_24727/tm.htm
Frequently Asked Stuff: http://www.visualbasicscript.com/m_47117/tm.htm

(in reply to patgenn123)

Post #: 2

RE: Save As Problem - 6/25/2008 7:38:32 AM

patgenn123

Posts: 37
Score: 0
Joined: 1/14/2008
Status: offline

Thank you!

I see XLFILEFORMAT. I think that's what you're referring to, but I don't see the .tsv Tab Separated value constant.

Treat me like the naive computer guy I am. I thank you for referring me to this site.

i don't know which one it is(if that is what you are referring to).

thanks!

P

(in reply to patgenn123)