Is It Possible to Push Dates to Excel - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Is It Possible to Push Dates to Excel

Stanley Mc Keown

15 months ago

I have thousands of excel sheets non macro enabled and can't be.
I can index and match to find and pull values from various places on each individual sheet and also import these values to access.
Now I want to do it the other way round. I've restructured the access database to do all the date processing and handling of records but want to push these dates to the existing excel sheets into cells found by index and match.
Is this actually possible?

	John Davy @Reply 15 months ago
Hi Stanley Take a look at Richard's Excel Automation HTH John

Stanley Mc Keown OP @Reply

15 months ago

Thanks John -- I had thought of a way using a two stage process.

1.Make a macro enabled workbook that has dedicated cells which have Vlookups in to lift the data ( which will be dates ) from access. ( I've done this successfully before using a formula like

=IFERROR(VLOOKUP(G8,Table!1:1048576,18,FALSE),"")

2. then with an index and match looking in the non macro workbook to find the next row below the date column and insert the vlookup values from the macro enabled workbook -- not sure how to go about that second stage but maybe someone can point me in the right direction?

	John Davy @Reply 15 months ago
Have you watched Richard's Excel Automation? John

	Stanley Mc Keown OP @Reply 15 months ago
I've seen ones that cover automatically importing excel spreadsheets as tables / temporary tables etc but I want to go the other way to existing excel workbooks find the cells ( cos they can move) and insert new dates into them. Do you have a link to Richards videos?

	Kevin Robertson @Reply 15 months ago
Excel Automation Excel Automation 2 Excel Automation 3

	Kevin Robertson @Reply 15 months ago
Here are also a couple of Excel videos. Excel Automation Excel Automation 2

	Stanley Mc Keown OP @Reply 15 months ago
Thanks Kevin I'll get a look at these after work today

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View