473,320 Members | 1,921 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

VB Application Development

Hi ,

Can anybody guide me to develop an application (EXE) - When I click a button it should result in going to a Reporting Website and open a link (Excel sheet) on a particular path and copy data from the Excel sheet and paste it in another excel sheet on an FTP location. Please guide me with regards to the Approach and the Coding to be used.
Oct 18 '07 #1
1 1008
kadghar
1,295 Expert 1GB
Hi ,

Can anybody guide me to develop an application (EXE) - When I click a button it should result in going to a Reporting Website and open a link (Excel sheet) on a particular path and copy data from the Excel sheet and paste it in another excel sheet on an FTP location. Please guide me with regards to the Approach and the Coding to be used.
You can create an Iexplorer or an Excel application object and of course read data from each and paste it into another, what im not sure about is that you'll be able to save it into the ftp location.

You didnt mention what version of vb you're using, but this might help in most versions.
this code will open a website:
Expand|Select|Wrap|Line Numbers
  1. dim obj1 as object
  2. set obj1 = createobject("internetexplorer.application")
  3. obj1.visible=true
  4. obj1.navigate("http://www.thescripts.com")
This will open an excel workbook from any location.

Expand|Select|Wrap|Line Numbers
  1. dim obj2 as object
  2. set obj2 = createobject("excel.application")
  3. obj2.visible=true
  4. obj2.workbooks.open("http://www.myserver.com/book1.xls")
then open the other one, the same way with other name (lets say Obj3)

to pass information to one to other just do something like

obj2.range("A2:A4").copy
obj3.range("A2").pastespecial -4163

HTH
Oct 18 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

18
by: mountain man | last post by:
Greetings to all database professionals and laymen, Let us make a bold assumption that we have developed a software tool for the SQL Server environment which simply acts as an interface between...
2
by: Debbie | last post by:
Hi I have developed an application that access an SQL database and installed it on a different machine The installation is successful but when I try to run the application I get the following...
0
by: C.E.O. Gargantua | last post by:
http://arstechnica.com/columns/linux/linux-20050102.ars/2 Development application of the year We judged ease of use, documentation, maturity of tools, and ease of deployment. Those...
5
by: Leszek | last post by:
Hello, Could anybody explain what's a difference between a virtual directory and an application root under IIS? I'm a little bit confused. This is mu problem: Let's assume the following...
1
by: Carl | last post by:
Help!! What are the best concepts / startegies to deploy an ASP.NET web application? My idea is work first in Production PC then after completing the project deploy it on the Web Server. But...
1
by: xcelmind | last post by:
Hello Dev. Guru, I want to at this time introduce myself. I am Stanley Ojadovwa by name. I’m a freelance and a newbie in web application development. I’m currently using ASP as my application...
6
by: Tony Johansson | last post by:
Hello! We have a C#.ASP.NET application that runs on a IIS 6. The application contains actually several asp pages but there is no GUI. The application receive an xml file that is processed....
1
by: Bhrionn | last post by:
Hello World, I am working on implementing a build for my companies application. The scenario implemeted is producing the error: ‘Class does not support automation or does not support expected...
1
by: eshedz | last post by:
Hello everyone, (if this is not the correct forum please direct me to the right place) (we work with TFS) (the names in bold are just examples) My team has been working on a project that is...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.