Batch excel import
Closed
overloaded
-
Jan 14, 2010 at 03:19 AM
wbarrett Posts 2 Registration date Thursday January 14, 2010 Status Member Last seen January 15, 2010 - Jan 15, 2010 at 05:39 PM
wbarrett Posts 2 Registration date Thursday January 14, 2010 Status Member Last seen January 15, 2010 - Jan 15, 2010 at 05:39 PM
Related:
- Batch excel import
- Import sim contacts - Guide
- Excel marksheet - Guide
- Excel free download - Download - Spreadsheets
- Number to words in excel - Guide
- Kernel for excel - Download - Backup and recovery
1 response
wbarrett
Posts
2
Registration date
Thursday January 14, 2010
Status
Member
Last seen
January 15, 2010
Jan 15, 2010 at 05:39 PM
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.