Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
WIZARD ARE YOU READY - UPDATING EXCEL FROM ACCESS IN REAL TIME
My actually prob is:
At every day i import the records of this MDB in the various sheet named with the same name of the table, for example at 8.00 am of morning During the same day SOME value of this MDB (in this file the field that they be updating a NOTE_BOU, SPESE, DATA_ATT, NOTE and NOTA_LIBERA) only this field are uppdated from the external appication in real time. How I can make to update the cells of excel at every time that the value in the MDB is updating? Note: in the sheet is present a unique id in column "S" (actually is hide) and the same id is present in the MDB in the field SERVIZIO here is the MDB file http://www.gssitaly.com/prova.zip |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
WIZARD ARE YOU READY - UPDATING EXCEL FROM ACCESS IN REAL TIME
sal21
Instead of Importing, you need to use Data GetExternalData to a create a query that points to those tables. Then you only need to refresh in Excel (which you can schedule at certain time intervals) and the Excel sheets will be up to date. See here http://www.dicks-clicks.com/excel/ExternalData.htm -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com "sal21" wrote in message ... My actually prob is: At every day i import the records of this MDB in the various sheet named with the same name of the table, for example at 8.00 am of morning During the same day SOME value of this MDB (in this file the field that they be updating a NOTE_BOU, SPESE, DATA_ATT, NOTE and NOTA_LIBERA) only this field are uppdated from the external appication in real time. How I can make to update the cells of excel at every time that the value in the MDB is updating? Note: in the sheet is present a unique id in column "S" (actually is hide) and the same id is present in the MDB in the field SERVIZIO here is the MDB file http://www.gssitaly.com/prova.zip |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
WIZARD ARE YOU READY - UPDATING EXCEL FROM ACCESS IN REAL TIME
Ok! i have make that... But if update the MDB file why the sheet of excel not is updating wit the new value changed in MDB -- sal2 ----------------------------------------------------------------------- sal21's Profile: http://www.excelforum.com/member.php...nfo&userid=204 View this thread: http://www.excelforum.com/showthread.php?threadid=27577 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
WIZARD ARE YOU READY - UPDATING EXCEL FROM ACCESS IN REAL TIME
sal21
It should, as long as you Refresh the table in Excel. Are you Refreshing in Excel and it's still not showing the changes? -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com "sal21" wrote in message ... Ok! i have make that... But if update the MDB file why the sheet of excel not is updating with the new value changed in MDB? -- sal21 ------------------------------------------------------------------------ sal21's Profile: http://www.excelforum.com/member.php...fo&userid=2040 View this thread: http://www.excelforum.com/showthread...hreadid=275776 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
WIZARD ARE YOU READY - UPDATING EXCEL FROM ACCESS IN REAL TIME
But...Ok! tks for interesting me.... But i import the mdb file from a macro not "External adta"new Query ecc.... I spossible make a macro to refresh the mdb deposit omn the server an automaticly the sheet.. -- sal2 ----------------------------------------------------------------------- sal21's Profile: http://www.excelforum.com/member.php...nfo&userid=204 View this thread: http://www.excelforum.com/showthread.php?threadid=27577 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
WIZARD ARE YOU READY - UPDATING EXCEL FROM ACCESS IN REAL TIME
http://www.gssitaly.com/l0785_def.zip the MDB is linked on my first pos -- sal2 ----------------------------------------------------------------------- sal21's Profile: http://www.excelforum.com/member.php...nfo&userid=204 View this thread: http://www.excelforum.com/showthread.php?threadid=27577 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
WIZARD ARE YOU READY - UPDATING EXCEL FROM ACCESS IN REAL TIME
sal21
Can you narrow it down to which macro does the import? -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com "sal21" wrote in message ... http://www.gssitaly.com/l0785_def.zip the MDB is linked on my first post -- sal21 ------------------------------------------------------------------------ sal21's Profile: http://www.excelforum.com/member.php...fo&userid=2040 View this thread: http://www.excelforum.com/showthread...hreadid=275776 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
WIZARD ARE YOU READY - UPDATING EXCEL FROM ACCESS IN REAL TIME
Here is the .bas to import in Excel from Access file... Acctually to is present in the project that you have... Note: Change the path. Naturally if you have another way is welcome. In effect during the import the process is very, veryslow...) +-------------------------------------------------------------------+ |Filename: ESTRACT_ALL.zip | |Download: http://www.excelforum.com/attachment.php?postid=2767 | +-------------------------------------------------------------------+ -- sal21 ------------------------------------------------------------------------ sal21's Profile: http://www.excelforum.com/member.php...fo&userid=2040 View this thread: http://www.excelforum.com/showthread...hreadid=275776 |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
WIZARD ARE YOU READY - UPDATING EXCEL FROM ACCESS IN REAL TIME
"Invalid attachment specified"
I've downloaded the workbook, just tell me the name of the procedure and the module that it's in. -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com "sal21" wrote in message ... Here is the .bas to import in Excel from Access file... Acctually to is present in the project that you have... Note: Change the path. Naturally if you have another way is welcome. In effect during the import the process is very, veryslow...) +-------------------------------------------------------------------+ |Filename: ESTRACT_ALL.zip | |Download: http://www.excelforum.com/attachment.php?postid=2767 | +-------------------------------------------------------------------+ -- sal21 ------------------------------------------------------------------------ sal21's Profile: http://www.excelforum.com/member.php...fo&userid=2040 View this thread: http://www.excelforum.com/showthread...hreadid=275776 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Real-time clock in excel | Excel Discussion (Misc queries) | |||
Convert real time to a % in Excel | Excel Discussion (Misc queries) | |||
SUNDERA - Real Time Excel Collaboration | Excel Discussion (Misc queries) | |||
update access from excel - jamie collins are you ready for new adventure;-) | Excel Programming | |||
real time sharing in excel | Excel Programming |