Käynnissä

2922 Need Script or Macro

Hello: I need to have a script created that any user can initiate through a batch file or another method. Basically it scripts the sequence of events from one data download through Excel, etc. I have outlined the sequence below: The user will start the script when a ?File Download? box is on screen. 1. Select SAVE to: S:\Team4SBC\AEOnlineAppData\ with the assigned file name that it's given. 2. Need to COPY the file name (20060824075943 or whatever the filename is to clipboard) 3. Select SAVE 4. Download Complete box pops back up. I need to CLOSE this box 5. Open Excel from C:\Program Files\Microsoft Office\OFFICE11\[url removed, login to view] 6. In Excel, open folder :\Team4SBC\AEOnlineAppData\(filename from clipboard) but need to change Files of Type dropdown box to All Files to find the file 7. Open that file 8. In Excel, File, Save As, Save As Type dropdown box needs to be file type Text (tab delimited), Save, 9. Error box pops up, select YES 10. File, Exit 11. Do you want to save the changes? Select NO 12. Open Adobe Acrobat Pro which is located at "C:\Program Files\Adobe\Acrobat 7.0\Acrobat\[url removed, login to view]" 13. File, Open, navigate to: S:\Team4SBC\AEOnlineApplicationsPDF end Thanks!

Taidot: kaikki käy, Komentosarjan asennus

Näytä lisää: i need microsoft office, microsoft macro, do i need microsoft office, acrobat adobe, office macro, office install, macro excel, macro + excel, excel macro pro, close pro, copy clipboard script, macro script file, excel macro download file, clipboard box, tab delimited text, script save excel tab delimited, batch batch excel file, excel macro program, find sequence, adobe acrobat macro, batch file name, acrobat open, script box, macro acrobat, excel find select

Tietoa työnantajasta:
( 6 arvostelua )

Projektin tunnus: #1753791