Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > Beginning VB 6
|
Beginning VB 6 For coders who are new to Visual Basic, working in VB version 6 (not .NET).
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Beginning VB 6 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 24th, 2005, 02:16 AM
Registered User
 
Join Date: Feb 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to Ryno
Default Excel Spreadsheet Manipulation

Hi there guys!

I will appreciate everybody’s input to help me solve this task.

Here is what I basically want to do:

I have an Excel Spreadsheet report with figures on it in the following format:


R00030 15 4 6 2 17
R00033 6 0 5 0 1
R00035 16 29 18 20 19

What I basically need to do is

1. Read the excel file from a VB application
2. Do the format conversion to look like this

R00030 15
R00030 4
R00030 6
R00030 2
R00030 17

How do I read an excel spreadsheet from VB?

Thanks,
Ryno







Similar Threads
Thread Thread Starter Forum Replies Last Post
Open Excel Spreadsheet sektor VBScript 1 June 28th, 2010 11:13 PM
Excel Spreadsheet Help SteveV VBScript 0 October 10th, 2006 04:42 PM
Excel Spreadsheet Help SteveV BOOK: Beginning VB.NET 2nd Edition/Beginning VB.NET 2003 0 October 10th, 2006 04:41 PM
Excel Spreadsheet Help SteveV BOOK: Beginning VB.NET 2nd Edition/Beginning VB.NET 2003 0 October 10th, 2006 04:40 PM
Help with formatting an excel spreadsheet lushh Access 0 October 1st, 2006 10:48 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.