需要帮助MS excel [英] Need help in MS excel

问题描述

我的一位朋友在他的excel文件中有关于每个IPO的1500-2500数据。

Excel文件包含以下数据：

PAN卡号，

IPO表格申请号，

名称。 名称无关紧要（可以删除）

现在我们需要从excel获取PAN和应用程序编号，然后在BSE网站上提交并获取分配结果。

，结果数据应存储回Excel表格。



BSE网站只需要PAN编号和申请编号要选择的组合框中的IPO名称。



需要尽快自动执行此过程。



我尝试了什么：



我们试图找到一些函数和公式，但它不会起作用希望。

需要一些专家为同一个

One of my friend is having 1500-2500 data about each IPO in his excel file.
Excel file contains data as:
PAN Card number,
IPO Form Application number,
name. name doesn't matter(it can be removed)
now we need to fetch PAN and Application number from excel then submit on BSE Website and fetch the result of allotment.
and the resulting data should be stored back into excel sheet.

BSE website needs only PAN number and application number along with the IPO name from the combo box to be selected.

need to automate this process as soon as possible.

What I have tried:

we tried to find some functions and formula but it won't worked as desired.
need some expert to write some script for the same

推荐答案

编写一些脚本。它不会像这样工作。

您必须尽量解决问题。当你遇到困难时，你可以回到这里并发布一个完整详细的问题。



此时我强烈建议从这里开始：使用VBA自动化Internet Explorer（IE）



祝你好运！

It doesn't work like this.
You have to get minimum effort to resolve your issue. When you get stuck, you can return here and post a fully detailed question.

At this moment i'd strogly suggest to start here: Automate Internet Explorer (IE) Using VBA

Good luck!

这篇关于需要帮助MS excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！