Spreadsheet Maker Form - Visual Basic 4 / 5 / 6

7 New Member

I have learned a bit about vb recently and have been using it for my job, I still have questions and dont know how to do many things yet.
I appreciate your time and efforts and hopefully I can figure out how to make this procedure work.

This is all taking place in vb6 and excel 2003.

I am making a userform that is activated once the user highlights a bit of spreadsheet and clicks a button on the command bar, here is what I want it to do:

1. (copy data from the spreadsheet
this is tricky because I am trying to have it be a conditional situation where the user highlights a place on the spreadsheet and whatever that place is at the moment, it will get copied to a variable on the form.
There are 8 fields to highlight and copy, two with info that wont be copied onto the new spreadsheet but will be used to update fields and make the filename.)

2. make a new spreadsheet:
a. the filename is made from cell values in the 'from' and 'to' columns and the date.

b. new spreadsheet needs to have a template section from a7:f7 that has 4 fields that will be filled in from the fields on the form.

c. copied data is to be moved from old spreadsheet to new spreadsheet to cell a8. There should be 6 columns that will be filled with data.

3. on the form there will be a browse button to save the file in a location specified by user and 'last saved location' name should be saved to a textbox.

I read about a browse button here that I would like to use, but I have to adapt it so it can be used in the 'browse' button. http://www.tek-tips.com/viewthread.cfm?qid=1396007

I dont even know if it is possible to copy a user-specified range. It seems that it should be, because when a user highlights an area, that area is being held in memory as a position... I tried passing these values to another sheet but it wasnt successful. I tried to dim 'selection' as string and pass it into a variable, but I am new to variables and this project is a big experience for me in vb.

I also am still learning about how to make values in a field pass to another field on a spreadsheet.

Any examples of how to do any of this is much appreciated.

Sep 7 '07 #1

Subscribe Reply

1833

platski

New Member

Here is where my file may be located:
http://www.ozgrid.com/forum/showthread.php? p=389016#post38 9016

I Ok. So everything was quite confusing before I put this into practice.

Im interested in having a dynamic selection process that the user can select a contiguous set of cells and the program will deal with routing the right values to the right columns.

I think that must be possible...

To circumvent that, I was thinking about just having an input box where the user can specify what range they want, and then the 'Mapping' of values can occur.

The program does not need much validation as it will be used by users who will be using the files they just made right after creating them.

I have made the code as much as I can understand how to make at this point.

Sep 10 '07 #2

Similar topics

3779

Javascript certificate maker code???

by: javatiger | last post by:

Can anyone give me the code or point me in the direction of a simple javascript certificate maker so that users can input there name and date so as to use on my site? cheers

Javascript

7992

How do I gain control of an Excel Spreadsheet embedded in an Access form?

by: Colleyville Alan | last post by:

I have been working on an application that queries data from Access, loads it into an array, and then writes it to an Excel spreadsheet. I use the array approach to have fine control over spacing, formatting, etc. I have gotten the first part of this to work by opening an Excel spreadsheet, writhing the data, saving the spreadsheet and closing it. But what I would like to do is to not actually open up Excel outside of Access. I want to...

Microsoft Access / VBA

6417

VB.net and excel spreadsheet

by: john andrew | last post by:

-- hello In VB.net can I import an excel spreadsheet into a formand display it. Also edit/save cells also on the form. I want to use code in VB.net form that also effect the spreadsheet. Can I do this or something like this in VB.net

Visual Basic .NET

2288

Displaying an Excel spreadsheet

by: Brooke | last post by:

I am new to ASP.NET, but have been programming for about 14 years (C# about 2 years). My manager asked me to develop a web application that would allow employees to view a spreadsheet that is used to manage resources (projects, employees, hours, dates, etc). The employee should only be able to view data that pertains to them, and not be able to modify it (read only view). My thought is to allow my manager to upload the spreadsheet to a...

ASP.NET

1464

Embed spreadsheet in Access Table programmatically

by: Derek Broughton | last post by:

I have an access table with a column defined as an OLEObject. I can drag and drop an Excel file into this column. I can create a form with an unbound ObjectFrame, and load a spreadsheet into it with a FileDialog and a little VBA code. I can even open the spreadsheet from VBA - either directly from the filesystem or from the embedded object in the form control - and manipulate the individual Cells(). What I can't seem to accomplish is...

Microsoft Access / VBA

4270

Movie maker transition

by: Audrey | last post by:

Hi, Can I find transitions like on movie maker ? Can I use it on C# program ?

C# / C Sharp

1656

Spreadsheet Input

by: jimc52 | last post by:

I work for a food company where we design new food products. I have an Access Database where I keep track of all the ingredents we use in the company, and add new ones daily. What I want to do is create a spreadsheet view where I can enter an ingredient inventory code into one field and then have it pull in from my ingredients table information about that ingredient, such as the ingredient description. I need the spreadsheet capability,...

Microsoft Access / VBA

3126

Embedding an Excel Spreadsheet in a Windows Form

by: Bill Atkins | last post by:

I'd like to embed an Excel spreadsheet in my C# application. The information I've found on the Web suggests placing a Web Browser control on the form and navigating it to an Excel spreadsheet. When I try this, I get a dialog asking if I'd like to open or save the spreadsheet - the spreadsheet never appears embedded in the application. Has anyone else had issues with this?

C# / C Sharp

7002

change link path for linked spreadsheet

by: franc sutherland | last post by:

Hello everyone, I am using Access 2003. In my database there is a table which is linked to an excel spreadsheet. When I move the mdb file to someone else's computer the spreadsheet will be in a different location. A location which I can not access from my own PC when designing the database, so can not use the Linked Table Manager to update the link. I need to find a way of telling the database where the source spreadsheet for the...

Microsoft Access / VBA

9646

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

10350

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8983

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7505

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6742

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5518

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4055

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3658

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2887

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General