By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,145 Members | 1,536 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,145 IT Pros & Developers. It's quick & easy.

Transferring strings from Access to Excel

P: 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
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
cloh

You will have to post the section of relevant code.

Mary
Sep 8 '07 #2

Post your reply

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