Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 3rd, 2005, 10:45 AM
Registered User
 
Join Date: Jun 2005
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Open File Dialog In Excel XP

I have an Excel Spreadsheet that has a button, I need this button to open an Open File Dialog Box to select another Excel (.xls) file with raw data and import that data from the one .XLS to the parent .XLS

I imported the Microsoft Common Dialog Control V. 6.0 but it sayd OpenFileDialog is undefined.

Am I missing something?
 
Old June 6th, 2005, 09:19 AM
Registered User
 
Join Date: Jun 2005
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I was thinking VB.NET I got the Open File Dialog working, now I just need to import from one Excel Spreadsheet to another one.








Similar Threads
Thread Thread Starter Forum Replies Last Post
Open File Dialog Issue rodmcleay VS.NET 2002/2003 0 March 7th, 2007 12:10 PM
open file dialog box mh VB.NET 7 April 11th, 2005 10:15 AM
Preview a picture in the open file dialog? Dinesh22 VB.NET 2002/2003 Basics 1 January 19th, 2004 11:21 AM
Open File Dialog Box KennethMungwira VB.NET 3 August 3rd, 2003 09:44 PM
Open File Dialog Box KennethMungwira VB.NET 2 June 27th, 2003 04:36 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.