Dear Friends,
I am new to autohotkey. Please help me with below query:
below are steps i follow everyday:
1 - Open 24 excel files from email. Name of each file is unique
2 - Go to one of excel file of 24 files - Select all data, cut and paste in Book 1 (new excel sheet)
3 - Move to empty row (ctrl+down arrow)
4 - follow step 2
Please help!
Help require on excel sheet
- flyingDman
- Posts: 2817
- Joined: 29 Sep 2013, 19:01
Re: Help require on excel sheet
A rather advanced script for someone just starting out . Are you using Outlook by any chance, as this would simplify the downloading of the 24 files?. If so, have a look here: https://www.autohotkey.com/boards/viewtopic.php?f=76&t=81767&p=356644&hilit=outlook+save+attachment#p356355 also search on "COM excel copy paste". There are several COM tutorials:
https://autohotkey.com/board/topic/69033-basic-ahk-l-com-tutorial-for-excel/
https://www.autohotkey.com/boards/viewtopic.php?f=7&t=8978
and others
https://autohotkey.com/board/topic/69033-basic-ahk-l-com-tutorial-for-excel/
https://www.autohotkey.com/boards/viewtopic.php?f=7&t=8978
and others
14.3 & 1.3.7