Batch excel import
Closed
overloaded
-
Jan 14, 2010 at 03:19 AM
wbarrett
wbarrett
- Posts
- 2
- Registration date
- Thursday January 14, 2010
- Status
- Member
- Last seen
- January 15, 2010
Related:
- Batch excel import
- Excel - Import CSV: bad alignment of dates - How-To - Excel
- How to import data from one excel sheet to another automatically - Guide
- Excel vba import sheet from another workbook without opening ✓ - Forum - Excel
- Import pdf to excel vba ✓ - Forum - PDF
- Excel - Disable compression of imported images - How-To - Excel
1 reply
wbarrett
Jan 15, 2010 at 05:39 PM
- Posts
- 2
- Registration date
- Thursday January 14, 2010
- Status
- Member
- Last seen
- January 15, 2010
Jan 15, 2010 at 05:39 PM
I've written several Excel macros for various operations, though none for your particular application.
Try this: turn on the macros (you may have to adjust the Excel security level, as Excel is snotty about user-generated macros), then go through a sample operation of the sort you describe. Turn off macros, give the macro a name.
Open the macro editor. You will find a function with your macro name in Visual Basic. So it provides clues about how to generalize your problem with an extended macro. You will have to learn some Visual Basic, I suggest buying a reference manual and tutorial for that, unless you want the pain of deciphering the online help.
So, in principle, you should be able to write a macro that grabs your file names (could be in a list in a special worksheet), creates a worksheet for each file, and downloads the file.
I've written very elaborate macros for PowerPoint, and simple ones for Excel. It takes some detective work to decipher how it's done, but start by having Excel generate some macros for the operations you need.
If you'd like some professional help with this, contact me through my web site www.wbarrett.us.
Try this: turn on the macros (you may have to adjust the Excel security level, as Excel is snotty about user-generated macros), then go through a sample operation of the sort you describe. Turn off macros, give the macro a name.
Open the macro editor. You will find a function with your macro name in Visual Basic. So it provides clues about how to generalize your problem with an extended macro. You will have to learn some Visual Basic, I suggest buying a reference manual and tutorial for that, unless you want the pain of deciphering the online help.
So, in principle, you should be able to write a macro that grabs your file names (could be in a list in a special worksheet), creates a worksheet for each file, and downloads the file.
I've written very elaborate macros for PowerPoint, and simple ones for Excel. It takes some detective work to decipher how it's done, but start by having Excel generate some macros for the operations you need.
If you'd like some professional help with this, contact me through my web site www.wbarrett.us.