I have looked in books and online and can't seem to locate how to create a macro that opens a browse function. From Excel I would like to click a button to start a macro and have that macro prompt me where to browse for the file. There is a lot of other code that will go after this step (which I already have), so once I click to "open" a file I want the macro to continue.
I appreciate your help in advance!
Is this what you mean?
Or
Please Login or Register to view this content.
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
This will activate the File Open dialog. Is this what you want
Please Login or Register to view this content.
Edit: Posted just behind RoyUK (better/full solution).
It looks like all of those get me to the same point. The file I open is a .txt file and contains a total of 39 columns. The # of rows vary depending on the file I recieve. The program I'm working on converts this text file to an excel file. The opening code looks like this:
I get the debug error where it starts at "origin." Any ideas how to mesh the code?Please Login or Register to view this content.
thanks!
P.S. in case you're wonding what I started with I'll include it below. The code below works but not for what I need. It opens the same file every time instead of asking me to search for the file.
Please Login or Register to view this content.
Last edited by curbster; 08-28-2009 at 01:49 PM.
Hello curbster,
The setting for the named argument Origin can be omitted. 437 This indicates the file was was saved in DOS-US font. Omitting the entry lets your system choose the font the closest to the original.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi Leith,
that code in the editor is still red. Something is not meshing together
Ok, with a little trial and error I think I got it. This seems to be working. I had to take out the "on error" and the "exit sub" and manipulate the "workbooks.open" to be "workbooks.opentext". See below:
Thanks for all of your help!Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks