| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
faster way to save/restore a worksheet in MS Access
Hi,
I'm looking for a faster way to save/restore a worksheet including the cell formating in an MS Access table. I'm using Windows and Office 2k I have built a macro to loop on all the cells, put the cell data and formating in a string with "~" as separator then save it in MS Access table. But the save and restore took a very long time. Is there a faster wasy to do this? Thank you very much. Ben |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
faster way to save/restore a worksheet in MS Access
You cannot save formating in an Access table.
What exactly are you trying to achieve? MH "Ben" wrote in message ... Hi, I'm looking for a faster way to save/restore a worksheet including the cell formating in an MS Access table. I'm using Windows and Office 2k I have built a macro to loop on all the cells, put the cell data and formating in a string with "~" as separator then save it in MS Access table. But the save and restore took a very long time. Is there a faster wasy to do this? Thank you very much. Ben |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
faster way to save/restore a worksheet in MS Access
Hi MH,
I want to save the cell color/Border/Font/Font size... Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I restore previous content before a save? | Excel Discussion (Misc queries) | |||
| How can make Save faster | Excel Programming | |||
| Can faster CPU+larger/faster RAM significantly speed up recalulati | Excel Discussion (Misc queries) | |||
| On hard drive, how do I restore .XLS prior to last save? | Excel Programming | |||
| Restore the auto save function, it was a life saver. | Excel Discussion (Misc queries) | |||
Linear Mode
