A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Office » General Discussions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Keeping track changes?



 
 
Thread Tools Display Modes
  #1  
Old May 4th, 2010, 08:03 PM posted to microsoft.public.office.misc
GirlieNinja
external usenet poster
 
Posts: 1
Default Keeping track changes?

I am trying to import some spreadsheets (that were originally tables in a
word doc) into Access 2007. I am able to keep the track changes when copying
from word to excel, however they dissapear when importing to access (or
copy/paste into access). The project I'm doing requires that users be able to
see any changes that have been made to these records, so I need to find a way
to keep the engrossing when putting it into access. My thought is that I can
replace strikethroughs with the text in brackets and replace additions with
the text in angled brackets (or something like that). Even though Access 2007
supports rich text, it doesn't import track changes (it deletes deletions and
adds insertions), however if I copy one cell at a time into access it doesn't
do that. Anyway, I'm getting a bit frustrated.

I guess what I'm asking if there is a macro I can use that will find and
replace deletions/insertions? Or does anyone know a way to import them into
Access without losing them?

Any help is appreciated.

Thanks!
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:36 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.