Posted to microsoft.public.excel.programming

Lance Hoffmeyer[_3_] Lance Hoffmeyer[_3_] is offline

external usenet poster

Posts: 8

Dialog to set path

The oApp is for SPSS.

Jim Cone wrote:

GetOpenFileName returns the path and the file name.
I have never seen your particular Open method used in Excel.
If oApp is an Excel application object then this might be more appropriate...

vFileName = oApp.GetOpenFilename()
If vFileName < False Then oApp.Workbooks.Open vFileName

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
specify default path in dialog open box	Striker	Excel Programming	1	August 12th 06 02:29 PM
dialog box to pick path & file	dlh[_7_]	Excel Programming	1	October 12th 05 04:36 AM
open dialog box for file path	krhyme[_14_]	Excel Programming	1	August 22nd 05 10:31 PM
GetOpenFilename Dialog default path	Arthlan	Excel Programming	1	June 3rd 04 09:19 PM
Getting the full path when from a File Open Dialog Box	Ric Payne	Excel Programming	3	July 10th 03 04:58 PM

All times are GMT +1. The time now is 06:27 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us