View Single Post
  #8   Report Post  
Fredrik Wahlgren
 
Posts: n/a
Default


"Alan Beban" wrote in message
...
Fredrik Wahlgren wrote:
"weclean" wrote in message
...

Fredrik,
Actuall I'm exporting standard P&L and B/S from Quickbooks to Excel so

the
format is ok. My issue is to update excel when the data changes from

such
activity as an adjusting journal entry I think ther's a "hyperlink"


command

that needs to be used at some point.
If you know the answer please help.



I see. I understand you mean that the import is OK but you now want to

be
able to update the Quickbook database from Excel.


No; he means he wants to update the Excel "database" from QuickBooks.

Alan Beban



Right. I didn't read this properly. The proble is that if the data comesinto
Excel from a csv file, there's no connection of any kind betseen the data
in an Excel cell and a value in the Quickbook's database. Uou need some kind
of DDE link or RTD component that maintains the connection. Ask those who
made QB.

/Fredrik