| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
write a macro like the /file copy combine named range in lotus 12
I wrote macros in Lotus and we are currently switching over to Excel but I
can't find the command that will allow the user to input the name of the file to open and get the data from the file. I have it set up to open a file , copy a range , close the file and paste it in the current worksheet but it works for a hard coded file. I need to be able to input the name of the file to get the data from. Can anyone help me? You can reach me at tow emails address. The lone attached to this name and Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lotus Notes - Unable to Copy Paste Special in macro | Excel Worksheet Functions | |||
| Saving a copy of excel file in macro but have it auto write | Excel Worksheet Functions | |||
| Copy named range from file list to summary workbook | Excel Programming | |||
| Would like Macro example to write out a range of cells to a file | Excel Programming | |||
| Converting Lotus 123 macro to Excel - copy/move data to worksheet | Excel Programming | |||
Threaded Mode
