PC Review


Reply
Thread Tools Rate Thread

Code to open file on intranet and save in excel isn't working

 
 
=?Utf-8?B?R0VPUkdJQQ==?=
Guest
Posts: n/a
 
      10th Jun 2005
I am trying to open a file in intranet with the button and save as text. It
will open the file in excel but it won't save as text.
what am i doing wrong?


Shell ("C:\Program Files\Microsoft Office\Office\excel.exe")
Application.FollowHyperlink
"http://srfi.inc.ikon.org/Daily_Dir/Oracle%20ART%20Closed%20Detail%20ATL.xls"

ActiveWorkbook.SaveAs Filename:="D:\My Documents\ATLCLOSE.txt", FileFormat _
:=xlText, CreateBackup:=False
ActiveWorkbook.SaveAs Filename:="D:\My Documents\ATLCLOSE.txt",
FileFormat _
:=xlText, CreateBackup:=False
ActiveWindow.Close

Thank you!
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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
Excel 2007 sorting ribbon is not working with .Net save code Yihong Microsoft Excel Programming 0 25th May 2010 09:43 PM
Userform on intranet: disble save option, allow open only sam Microsoft Excel Programming 1 3rd Aug 2009 05:35 PM
Word why does working file save other file I have open instead? =?Utf-8?B?TGluZGFFdGhlTVQ=?= Microsoft Word Document Management 0 1st Sep 2007 12:22 AM
Open excel file from password protected Intranet site(IE) Dan McCollick Microsoft Excel Programming 5 17th May 2006 07:37 PM
Create code to Run Adobe, Open file, Save and REPEAT =?Utf-8?B?U2hlaWxh?= Microsoft Access VBA Modules 0 9th Feb 2006 03:01 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:17 AM.