iMacroScripter wrote:Problem Description Information:
1. iMacros Version: iMacros for Firefox 8.9.7 (Build=8970419)
2. Windows 10 (64-bit) [English]
3. Firefox 45.9.0
4. Included demos work ok.
5. Included VBS sample scripts run ok.
6. Not applicable/no specific recording or replay fails on a specific website.
7. Not applicable/no test for encounter of the same problem with the: iMacros Browser, iMacros for Internet Explorer, iMacros for Firefox, and iMacros for Chrome.
Problem:
I am currently working on an iMacros script, and I am asking if there is a code that will allow iMacros to run an Excel macro?
For example something like:
Code: Select all
VERSION BUILD=8970419 RECORDER=FX
WAIT SECONDS=1
TAB T=1
URL GOTO=http://*URL*/
*iMACROS CODE*
WAIT SECONDS=1
URL GOTO=imacros://run/?m=#Macro2
But instead of ending with running "Macro2" it runs an Excel macro instead; how would I do this in iMacros?
I tried the below code, and this did not work.
Code: Select all
URL GOTO=C:\Program Files\Microsoft Office\Office13\EXCEL.exe
iMacroScripter wrote:EDIT: Progress Update
Courtesy of the wiki:
http://wiki.imacros.net/URL; I was able to find the "URL GOTO=" command for running local files in Windows.
Code: Select all
URL GOTO=file:///C:\Directory\TEST.CSV
As a result, I was able initiate the running of an Excel (.CSV) file where the "URL GOTO=" triggers the browser prompt window below. How would I code iMacros to open the local file, and not download it?
Hum..., try to select the correct Sub-Forum when you open a Thread, this one has nothing to do with 'Data Extraction' and will be moved... one day... by the Forum Admin to the 'General' one where it belongs... (But no need to duplicate now...)
Hum, I've already mentioned it's better to post an Update in your Thread as you "progress" rather than editing your OP... You are "lucky" I still wanted to reply in this Thread, or I wouldn't have noticed your Edit...
And I give up asking to upload your Screenshots directly to the Forum rather than on some external Image Hosting Server as those Sites nearly always stop to exist after a few years or even months or they go commercial or they clean up "older" Images after a while, and your Screenshots will disappear...
>>>
OK, concerning this one, yeah..., you found the 'URL GOTO=file:///' Syntax to open Local Files (in a Tab) in the Browser, but it only works for '.TXT'/'.HTM(L)'/'.LOG'/etc Files and not for Executables like '.EXE' or '.BAT'. And for '.CSV'/'.XLS'/'.PDF' Files you indeed have to deal with the "Automatically open"/"Always ask" Mechanism for "known" Extensions that some external Programs want to handle, like you had already found out in your very first Thread and here again...
There are several Solutions anyway...
1- You mention each time you open a Thread "Included VBS sample scripts run ok." meaning you must be using or can use the Scripting Interface (I've already asked you which Version...?, but you didn't answer and still don't mention that in your FCI). That would be the most straightforward and more "powerful" Solution...! Have a main '.vbs' Script calling an (on-the-fly) '.iim' Macro for the 'iMacros'/Web-Automation part and let the '.vbs' Script handle the Excel/'.CVS' Macro part as you then have Full Control on Excel from your '.vbs' Script.
2- Another Solution as you are on FF is to use some extra FF Add-on called 'External Applications Button' from which you can launch from one Click in FF '.EXE'/'.BAT' Files, or even '.TXT' Files. Each Program or File you want to launch can be assigned a Shortcut that iMacros in an '.iim' Script is able to trigger using the 'EVENT' Mode.
3- And since a few months, some Syntax is "circulating" on the Forum and on SOF (came from SOF originally I would think...) about how to launch a Local File (any Extension, so it works for '.EXE'/'.BAT'/etc...) in "pure" JavaScript, and therefore from a '.js' Script with iMacros for FF.
The first time I saw it was
in this Thread, and I then "vaguely" tried at that time to convert it to be able able to use it "directly" from an '.iim' Script (as I don't use '.js' Scripts myself), but I didn't succeed directly in my "quick and dirty" Tries/Testing, and I didn't really need that Functionality for myself, so I didn't really insist to get it to work in pure '.iim'.
Have a look at that Thread for the Syntax, and what I had tried...
Some other User revived the Thread a few months later but they didn't follow up (hum..., one more...!
), so I didn't bother digging into that Matter again either, ah-ah...!
And hum, "mini-Detail" but both Options '2-' and '3-' assume that when starting 'Excel' from the Command Line ('.BAT' File or Windows Shortcut), you can pass a specific 'Excel' ('.XLS'/'.CSV') File as Argument together with a Macro or that the Macro can start automatically when opening a File in 'Excel', or same thing when launching a File associated with 'Excel', to pass the Name of the Macro as Argument/Parameter...
I don't know about that, YOU are the '.vbs'/'Excel' Specialist, ah-ah...!
But, well..., even if not possible from the Command Line, then you could include that Functionality in some mini '.vbs' Script, ah-ah...!
- (F)CI(M) = (Full) Config Info (Missing): iMacros + Browser + OS (+ all 3 Versions + 'Free'/'PE'/'Trial').
- FCI not mentioned: I don't even read the Qt...! (or only to catch Spam!)
- Script & URL help a lot for more "educated" Help...