473,385 Members | 1,518 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Transferring strings from Access to Excel

41
I have a form in Access that generates an Excel Workbook with multiple worksheets. Each worksheet is unique to a particular location. The top row of each sheet shows the dates, the left-most column has the times of the day in 5 minute intervals. Let's say the dates range from 7/01/2007 to 9/01/2007

The aim of the form is to eventually create a chart for each date that the user wants. On the form, I get the user to input either a single date (7/01/07) or a date range (two strings, 7/01/2007 and 7/07/2007 and ). I have created all the macros I need to make a single graph... what I need help with is taking the date(s) that the user inputs into the form and using those strings to search the worksheets for the corresponding dates (the rows have dates in the same format that the user enters into the form) and then return the value of the column so that I can then pass that into my macros to create the chart.

I'm not sure how to "pass" those date strings from the form input to the Excel module. Any ideas? Sorry if this is rather wordy. I hope I've described things clearly. Thanks in advance for any help.
Sep 6 '07 #1
1 1250
MMcCarthy
14,534 Expert Mod 8TB
cloh

You will have to post the section of relevant code.

Mary
Sep 8 '07 #2

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

Similar topics

1
by: James | last post by:
Hi, I am currently creating a database which will be stored on a network. Somebody will take this database out on a laptop will they will input new data via a form. Somehow this new version...
3
by: phong.lee | last post by:
Hello all, i'm new at this. I need some assistant in transferring data from excel to access. I created a macro that basically gather all the necessary data that i need to bring into access. I...
1
by: kumar yogesh via .NET 247 | last post by:
Hello, I want to develop an application to transfer data from sqlserver to excel such that , when we create a workbook in excel ,then we are able to transfer data from SQL Server to excel in away...
6
by: comp.text.xml | last post by:
Hi, I'm developing a system uses SOAP took kit version 3. The XML is transferred between the server and the client. We have noticed when transferring data using SOAP a considerable amount of...
1
by: R.A.M. | last post by:
Hi, I am learning ASP.NET and I need to have an Excel-like sheet of records from database. Users may modify data in the sheet. I thought about using GridView with DataSource but the problem is...
6
by: Kc-Mass | last post by:
In a standard Ascii table a dash or hyphen is decimal 45. A period or dot is decimal 46. If I sort a table or recordset of mixed character string ascending in Access, those strings beginning with...
2
by: cbs81 | last post by:
hi all, problem: transferring data from workbooks that are stored in a particular directory from excel to a table in access. when done, the workbooks that have been processed are automatically...
0
andrewsteed
by: andrewsteed | last post by:
I have an Excel file on the server that I need to pass to the client. I tried dynamically generating the excel file through response.write's, but I was unable to get a file/table type that would...
2
by: grego9 | last post by:
I have a problem in Excel 2000. I have written some VBA code that transfers data from the current excel workbook to a file called "Deal Input2.xls". Everything transfers ok apart from the date in...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

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.