[Download-List] Fwd: [DOWNLOAD] Any format that Excel will open without prompting ?

[Susan Misnick]

Yes, you're right, the suggestion below will only solve half the issue.

I think you can make a tab be a default separator if you click on it while using the text-to-columns feature, even if the cell(s) you use it on have no tabs.

I think it keeps the default delimiter of the tab character for opening files, too, once you use it for text-to-columns.

I'm not on a Windows box at the moment, so can't check.


========================
Susan Misnick
Sr. Programmer/Analyst
Information Technology
World Learning
Kipling Road
P.O. Box 676
Brattleboro, VT 05302
802-258-3210

________________________________________
From: download-list-bounces at cedarville.edu [download-list-bounces at cedarville.edu] on behalf of Wjhonson [wjhonson at aol.com]
Sent: Saturday, August 24, 2013 1:01 PM
To: download-list at cedarville.edu
Subject: [Download-List] Fwd: [DOWNLOAD] Any format that Excel will open without prompting ?

You can set any extension to be opened by
Excel, or notepad for that matter.

But
The goal here is for Excel to actually comprehend
that what it's opening is in fact a spreadsheet.

And have it open it without prompts, and put
the results into columns and rows.

It would be nice if DOWNLOAD could do that
since Accuterm's export facility does allow
exporting natively to Excel files, so we can
see that it's *possible* to do so.




-----Original Message-----
From: Susan Misnick <Susan.Misnick at worldlearning.org>
To: Cedarville DOWNLOAD Users <download-list at cedarville.edu>
Sent: Sat, Aug 24, 2013 7:33 am
Subject: Re: [Download-List] [DOWNLOAD] Any format that Excel will open without prompting ?

Julie, this is a function of Windows.

Based on the suffix of the file, Windows will always open the default app (if any) for that type of suffix.

The default can be changed on the recipient’s PC by setting Excel as the default program for text files (.txt).  Then clicking on the file will automatically open Excel.

If you go to a formerly-saved “.txt” file, then right-click.   Select “open with”, and then choose the default program.

Of course, if you’re sending to different folk all the time, this wouldn’t do the trick.

Regards,
Susan


__________________________________________________________________
Susan Misnick
Senior Programmer/Analyst
Information Technology

World Learning
1 Kipling Road, PO Box 676, Brattleboro, VT 05302  |   802 258-3210
Connect With Us<http://www.worldlearning.org/about-us/connect-with-us/> | susan.misnick at worldlearning.org<mailto:susan.misnick at worldlearning.org>
www.worldlearning.org<http://www.worldlearning.org/>  | www.sit.edu<http://www.sit.edu/> | www.experimentinternational.org<http://www.experimentinternational.org/>

To learn about how World Learning and its supporters are advancing leadership, please read our Annual Report<http://www.worldlearning.org/about-us/annual-report-2012-celebrating-80-years-of-leadership/>.

From: download-list-bounces at cedarville.edu<mailto:download-list-bounces at cedarville.edu> [mailto:download-list-bounces at cedarville.edu<mailto:download-list-bounces at cedarville.edu?>] On Behalf Of Kellie, Julie
Sent: Friday, August 23, 2013 2:44 PM
To: download-list at cedarville.edu<mailto:download-list at cedarville.edu>
Subject: Re: [Download-List] [DOWNLOAD] Any format that Excel will open without prompting ?

Finally had a chance to revisit this and realized I should have had coffee a little earlier this morning. The solution is fine but my problem is a bit different, I think.

When I create a .csv file with Download and email it to a user, s/he can double-click on the (Outlook) attachment and the file opens in Excel. It doesn’t ask any questions, and while the format may not be all that is desired, it works, it’s readable, and it can be sorted and filtered.

When I create a tab-delimited text file and email it, the user has to save it, then open Excel, then open it from within Excel. It’s not exactly a huge burden, but the save/open/import routine is a bit clumsy.  I’d like to make it easier –I’d like them to be able to double-click on the attachment and open it, as they would a .csv.

That’s the problem I’m really trying to solve.

Julie Kellie
Programmer/Analyst
Metropolitan Community College
Omaha

From: download-list-bounces at cedarville.edu<mailto:download-list-bounces at cedarville.edu> [mailto:download-list-bounces at cedarville.edu<mailto:download-list-bounces at cedarville.edu?>] On Behalf Of Wjhonson
Sent: Thursday, August 22, 2013 8:09 PM
To: download-list at cedarville.edu<mailto:download-list at cedarville.edu>
Subject: Re: [Download-List] [DOWNLOAD] Any format that Excel will open without prompting ?

html opens in the browser



-----Original Message-----
From: Bowen, Ryan <bowenr at cedarville.edu<mailto:bowenr at cedarville.edu>>
To: Cedarville DOWNLOAD Users <download-list at cedarville.edu<mailto:download-list at cedarville.edu>>
Sent: Thu, Aug 22, 2013 6:06 pm
Subject: Re: [Download-List] [DOWNLOAD] Any format that Excel will open without prompting ?
Try HTML.  I have used that before and it works great.

On Thu, Aug 22, 2013 at 6:46 PM, Wjhonson <wjhonson at aol.com<mailto:wjhonson at aol.com>> wrote:
Does Cedarville Download produce any kind of output that can be opened in Excel without any prompting from Excel?

CSV is fine, but I'd rather not have to answer prompts to get the file to open.

_______________________________________________
download-list mailing list
download-list at cedarville.edu<mailto:download-list at cedarville.edu>
http://mail.cedarville.edu/mailman/listinfo/download-list


_______________________________________________

download-list mailing list

download-list at cedarville.edu<mailto:download-list at cedarville.edu>

http://mail.cedarville.edu/mailman/listinfo/download-list

_______________________________________________
download-list mailing list
download-list at cedarville.edu<mailto:download-list at cedarville.edu>
http://mail.cedarville.edu/mailman/listinfo/download-list