08-25-2004, 03:36 PM
Actually i am not familiar with QM, but i am computer literate.
I wouldn't mind having a go at creating the macro through excel. would it be possible to run the kind of macro i need from excel? Once i have an idea of how it would work i'd upgrade too QM 2.
the idea is as follows :
Not connected/connected prior to leaving:
http://www.kligerweiss.net
username
password
menu select report
wait till loads...
select parameters (dates, summary or detailed, store location...etc.)
submit (download)
wait till loads...
open file (opens in excel
save as ....
name of file: distro report for store 1 (name of saved file needs to match the name of file downloaded)
this is basically it, i was wondering if i could start off using excel then QM
thanks
mark
I wouldn't mind having a go at creating the macro through excel. would it be possible to run the kind of macro i need from excel? Once i have an idea of how it would work i'd upgrade too QM 2.
the idea is as follows :
Not connected/connected prior to leaving:
http://www.kligerweiss.net
username
password
menu select report
wait till loads...
select parameters (dates, summary or detailed, store location...etc.)
submit (download)
wait till loads...
open file (opens in excel
save as ....
name of file: distro report for store 1 (name of saved file needs to match the name of file downloaded)
this is basically it, i was wondering if i could start off using excel then QM
thanks
mark