473,704 Members | 2,727 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Spreadsheet Maker Form

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
1 1829
7 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

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

Similar topics

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
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...
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
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...
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...
by: Audrey | last post by:
Hi, Can I find transitions like on movie maker ? Can I use it on C# program ?
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,...
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?
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...
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...
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
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();...
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
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
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
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...

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.