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

G

GEORGIA

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 ART Closed Detail ATL.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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top