Hi,
We are using SAP as ERP in our office. We have developed some macros for
preparation of reports in Excel. But every time, we have to LOG IN to SAP
for preparation of Report abd Export Data in EXcel.
If anybody know any program/Macro by which the data from the SAP can be
extracted without log
Hi Ashkaran,
It seems you didn't followed the link properly, you need to set a
reference to "Microsoft Internet Controls" through Tools -->
References before you run the code. For full step-by-step procedure,
please follow the link.
http://www.excelitems.com/2009/03/access-search-engines-on-brows
Thanks again Ashish. You have been very kind.
This time, however, when I run the macro, My yahoo mail opens, but no
search is performed.
In excel, I get the following error:
"Run-time error '-2147467259 (80004005)':
Automation error
Unspecified error"
I tried playing around with it, but have h
It means one of the application is based on Oracle 9i and the data is linked
through MSaccess which is transferred to Excel.In other case, the application
is based on Oracle
10g and the data is linked to Access which is again transferred to Excel.
I hope it is clear now.Please let me know if a
what does it mean?
"The Oracle Version being used is 9i in one case and 10g in second case"
On Sun, Mar 15, 2009 at 1:02 AM, Alok Mahajan wrote:
> Abdul,
>
> The Oracle Version being used is 9i in one case and 10g in second case.
>
> Regards,
>
> Alok
>
> --- On *Sun, 3/15/09, Xebec Groups * w
Hi Team,
I am also trying to do something of this sort. However when I copied this
program in my excel VB Editor. It is giving me error at the declaration
line of 'MyBrowser', system is not recognising SHDocVw.InternetExplorer
Can anyone help me to know how to open internet explorer from
Hi Ashkaran,
Please mention the site where you want to do this. Please try this
possible solution too.
Possible Solution -
http://www.excelitems.com/2009/03/access-search-engines-on-browser.html
For more tips, tricks, downloads and problem solutions: visit -->
http://www.excelitems.com
Hi Mike
Here is your solution:
Sub Login_Yahoo()
'Requires Reference to "Microsoft Internet Controls"
'Requires Reference to "Microsoft HTML Library"
'Declare Reference to InternetExplorer Object
Dim MyBrowser As SHDocVw.InternetExplorer
'Set Reference to InternetExplorer Object
