Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default How to display an open file?


Hi All,

I want to display and html file in the middle of an application and
after looking at it return to Excel. I already have the html file, the
path and the name, but i havn;t been able to display the file. Coud you
give me a hand with it?

I have tryed these codes:



Code:
--------------------
Sub Abrir()
nPath = ActiveWorkbook.Path
nname = "HCostos2.mht"
arch = nPath & nname
Open arch For Random Access Read Lock Read As #1

End Sub

Sub Cerrar()
Close #1
End Sub
--------------------


Besides i try this one, but I would like make the things easy to the
user and display the file once selected in Excel, and with this method
She still has the possibilty to choose any other file or mistakedly
click another.


Code:
--------------------
Sub Abrir2()
nPath = ActiveWorkbook.Path
nname = "HCostos2.mht"
nname2 = ActiveWorkbook.Name
arch = nPath & nname
myPictureName = Application.GetOpenFilename(filefilter:="HTML Files,*.mht;*.hmtl")

End Sub
--------------------



Thanks in advance,

Regards

Jose Luis


--
jose luis
------------------------------------------------------------------------
jose luis's Profile: http://www.excelforum.com/member.php...o&userid=13312
View this thread: http://www.excelforum.com/showthread...hreadid=384974

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel file seems to open but does not display neilc Excel Discussion (Misc queries) 2 August 13th 09 06:52 PM
File Open display in Excel 2007 Dave iii Excel Discussion (Misc queries) 2 June 15th 09 09:08 PM
open csv file, display format kei Excel Discussion (Misc queries) 2 January 23rd 06 09:57 AM
Open an excel file but it does not display Fred Zack Excel Discussion (Misc queries) 3 December 21st 05 06:45 PM
How do I display each Excel file I open in the task bar bocjoel Excel Discussion (Misc queries) 3 September 28th 05 08:04 PM


All times are GMT +1. The time now is 09:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"