Windows Vista Forums
Vista Forums Home Join Vista Forums Windows 7 Forum Vista Tutorials Tags
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.

Go Back   Vista Forums > Misc Newsgroups > VB Script

Vista - How to sedn data to an excel cell from another file using a vb script

Reply
 
Old 03-16-2009   #1 (permalink)
djfuzerebirth


 
 

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 SpecsSystem Spec
Old 03-16-2009   #2 (permalink)
Patrick Mc


 
 

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 SpecsSystem Spec
Old 03-16-2009   #3 (permalink)
Patrick Mc


 
 

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 SpecsSystem Spec
Old 03-16-2009   #4 (permalink)
Al Dunbar


 
 

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?
For future reference, vbscript is NOT visual basic.

/Al


My System SpecsSystem Spec
Old 03-17-2009   #5 (permalink)
djfuzerebirth


 
 

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
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?

Cheers
My System SpecsSystem Spec
Old 03-17-2009   #6 (permalink)
Bob Barrows


 
 

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
>>
>>
news:ca658cd6-0132-41c4-94a2-f76a1f3f37e5@xxxxxx
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?
>
For a discussion about the differences between vb and vbscript, start
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 SpecsSystem Spec
Old 03-17-2009   #7 (permalink)
Al Dunbar


 
 

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?
I have no idea, as the web page he referred you to is about a completely
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?
vbscript is the scripting language you use when writing vbscript script
code. vb is the language you use when writing


My System SpecsSystem Spec
Old 03-17-2009   #8 (permalink)
Al Dunbar


 
 

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?
I have no idea, as the web page he referred you to is about a completely
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?
vbscript is the scripting language you use when writing scripts in vbscript.
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 SpecsSystem Spec
Old 03-20-2009   #9 (permalink)
Patrick Mc


 
 

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 SpecsSystem Spec
Old 03-20-2009   #10 (permalink)
Al Dunbar


 
 

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.
That may well be, but it does not answer the question posed in the subject
line.

/Al


My System SpecsSystem Spec
Reply

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


Vista Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46