Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create button to open a file
I don't have any programming experience, but I was wondering if ther
was a way to make a button in Excel that you could click and have i open a file and copy the file into your already open worksheet. At first I thought it may be as simple as creating a macro, but now don't think so. What I would like the button to do is: 1. Open a box that asks you to select the file you want to open. 2. Open the file (a .txt file) and select Delimited with Tabs an Spaces as delimiters. 3. Copy the contents of the file an place them into the worksheet yo already have open. I would love it if the only user intervention was selecting the prope file to open, and the program did the rest. Is this that difficult to accomplish? I guess I will go read up o programming in Excel -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need macro from button to open selectable file | Excel Worksheet Functions | |||
how to get a button added to a speardsheet to open another file? | Excel Discussion (Misc queries) | |||
Favourites button - File Open dialog box | Excel Discussion (Misc queries) | |||
Create a button in excel that can open an outlook appointment? | Excel Worksheet Functions | |||
VBA - on a button event, open another closed file, post changes, close file | Excel Programming |