![]() |
![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
| Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks. |
| |||||||
![]() |
| |
| | #1 (permalink) |
| | How to sedn data to an excel cell from another file using a vb script Hi, I am very new to visual basic and I am trying to find out what script i need to use in order to read data from another file and send it to cells in an excel spreadsheet so i can change the data accordingly. Does anyone have any pointers? Cheers in advance |
My System Specs![]() |
| | #2 (permalink) |
| | Re: How to sedn data to an excel cell from another file using a vb script There are couple of examples posted at http://www.biterscripting.com/samples_data.html . You can extract data into a spreadsheet readable format from flat files, web pages, etc. If you don't have biterscripting, download it free from http://www.biterscripting.com . It is good for doing things like this. Patrick *** Sent via Developersdex http://www.developersdex.com *** |
My System Specs![]() |
| | #3 (permalink) |
| | Re: How to sedn data to an excel cell from another file using a vb script There are couple of examples posted at http://www.biterscripting.com/samples_data.html . You can extract data into a spreadsheet readable format from flat files, web pages, etc. If you don't have biterscripting, download it free from http://www.biterscripting.com . It is good for doing things like this. Patrick *** Sent via Developersdex http://www.developersdex.com *** |
My System Specs![]() |
| | #4 (permalink) |
| | Re: How to sedn data to an excel cell from another file using a vb script <djfuzerebirth@xxxxxx> wrote in message news:ca658cd6-0132-41c4-94a2-f76a1f3f37e5@xxxxxx Quote: > Hi, I am very new to visual basic and I am trying to find out what > script i need to use in order to read data from another file and send > it to cells in an excel spreadsheet so i can change the data > accordingly. > > Does anyone have any pointers? /Al |
My System Specs![]() |
| | #5 (permalink) |
| | Re: How to sedn data to an excel cell from another file using a vbscript On 17 Mar, 02:09, "Al Dunbar" <aland...@xxxxxx> wrote: Quote: > <djfuzerebi...@xxxxxx> wrote in message > > news:ca658cd6-0132-41c4-94a2-f76a1f3f37e5@xxxxxx > Quote: > > Hi, I am very new to visual basic and I am trying to find out what > > script i need to use in order to read data from another file and send > > it to cells in an excel spreadsheet so i can change the data > > accordingly. Quote: > > Does anyone have any pointers? > For future reference, vbscript is NOT visual basic. > > /Al invalid? I wa sunder the impression that vbscript was the code you used in visual basic, can you correct me please? Cheers |
My System Specs![]() |
| | #6 (permalink) |
| | Re: How to sedn data to an excel cell from another file using a vb script djfuzerebirth@xxxxxx wrote: Quote: > On 17 Mar, 02:09, "Al Dunbar" <aland...@xxxxxx> wrote: Quote: >> <djfuzerebi...@xxxxxx> wrote in message >> >> Quote: Quote: >> Quote: >>> Hi, I am very new to visual basic and I am trying to find out what >>> script i need to use in order to read data from another file and >>> send it to cells in an excel spreadsheet so i can change the data >>> accordingly. Quote: >>> Does anyone have any pointers? >> For future reference, vbscript is NOT visual basic. >> >> /Al > Ok, i am using visual basic. Does that make Patrick mc's advice > invalid? I wa sunder the impression that vbscript was the code you > used in visual basic, can you correct me please? > here: http://msdn.microsoft.com/en-us/libr...c7(VS.85).aspx However, that is only a start. Nowadays you need to make a further distinction: you need to tell people whether you are using "classic" vb (vb6 or older) or vb.net. For classic vb questions, you need to post to the microsoft.public.vb hierarchy of newsgroups. For vb.net, you need to post to the dotnet or vbnet newsgroup hierarchies. -- HTH, Bob Barrows |
My System Specs![]() |
| | #7 (permalink) |
| | Re: How to sedn data to an excel cell from another file using a vb script <djfuzerebirth@xxxxxx> wrote in message news:62d3d5dd-3661-4d33-a50b-cda3e5351eb2@xxxxxx Quote: > On 17 Mar, 02:09, "Al Dunbar" <aland...@xxxxxx> wrote: Quote: >> <djfuzerebi...@xxxxxx> wrote in message >> >> news:ca658cd6-0132-41c4-94a2-f76a1f3f37e5@xxxxxx >> Quote: >> > Hi, I am very new to visual basic and I am trying to find out what >> > script i need to use in order to read data from another file and send >> > it to cells in an excel spreadsheet so i can change the data >> > accordingly. Quote: >> > Does anyone have any pointers? >> For future reference, vbscript is NOT visual basic. >> >> /Al > Ok, i am using visual basic. Does that make Patrick mc's advice > invalid? different scripting environment called "biterscripting" that seems to have less in common with vb or vbscript than either has with each other. Quote: > I wa sunder the impression that vbscript was the code you > used in visual basic, can you correct me please? code. vb is the language you use when writing |
My System Specs![]() |
| | #8 (permalink) |
| | Re: How to sedn data to an excel cell from another file using a vb script <djfuzerebirth@xxxxxx> wrote in message news:62d3d5dd-3661-4d33-a50b-cda3e5351eb2@xxxxxx Quote: > On 17 Mar, 02:09, "Al Dunbar" <aland...@xxxxxx> wrote: Quote: >> <djfuzerebi...@xxxxxx> wrote in message >> >> news:ca658cd6-0132-41c4-94a2-f76a1f3f37e5@xxxxxx >> Quote: >> > Hi, I am very new to visual basic and I am trying to find out what >> > script i need to use in order to read data from another file and send >> > it to cells in an excel spreadsheet so i can change the data >> > accordingly. Quote: >> > Does anyone have any pointers? >> For future reference, vbscript is NOT visual basic. >> >> /Al > Ok, i am using visual basic. Does that make Patrick mc's advice > invalid? different scripting environment called "biterscripting" that seems to have less in common with vb or vbscript than either has with each other. Quote: > I wa sunder the impression that vbscript was the code you > used in visual basic, can you correct me please? vb is the programming language you use when writing programs in vb. The languages look similar (vbscript is based on vb), but they are not the same thing. /Al |
My System Specs![]() |
| | #9 (permalink) |
| | Re: How to sedn data to an excel cell from another file using a vb script I use biterscripting in addition to anything else. I am a system admin and need to do things FAST with small quick scripts. Biterscripting comes in handy for that, especially like the task on hand here. Patrick *** Sent via Developersdex http://www.developersdex.com *** |
My System Specs![]() |
| | #10 (permalink) |
| | Re: How to sedn data to an excel cell from another file using a vb script "Patrick Mc" <ptrckmc249@xxxxxx> wrote in message news:O4tCh6XqJHA.5832@xxxxxx Quote: > > > I use biterscripting in addition to anything else. I am a system admin > and need to do things FAST with small quick scripts. Biterscripting > comes in handy for that, especially like the task on hand here. line. /Al |
My System Specs![]() |
![]() |
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Forum | |||
| Opening a excel file and select the 1st column of data | PowerShell | |||
| How to create a new file and write data in Excel page | VB Script | |||
| Re: How to do something in an VBS script for all worksheets of an Excel file? | VB Script | |||
| Script to consolidate excel files into sheets in one file | PowerShell | |||
| Opening an Open Office data file in Excel | Vista General | |||