Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Old Quattro Macros

2 views
Skip to first unread message

Terry

unread,
Jul 16, 2008, 5:13:29 PM7/16/08
to
I'm trying to move some old Quattro Pro files to Excel. The problem is I
wrote macros many, many years ago and can't figure out how to get some
translated to Excel.

Here is one
\s {let SAVED,YES}~
{goto}DATE~
@NOW~
{edit}{calc}~{home}
/fsr

The macro was to save the file and put "yes" in a cell and update the saved
date in another cell. That way I could remember if I had previously saved
as I played with the data. The problem I have is with the last line. It
calls for opening File/ Save/ Replace. I'm having trouble rewriting that
line. Any suggestions?


rava...@yahoo.com

unread,
Jul 18, 2008, 1:28:04 PM7/18/08
to

What version of QuattroPro are you using?

In Excel, the instruction "ActiveWorkbook.Save" will save the file
with the current name replacing an older file if it exists.

Terry

unread,
Jul 30, 2008, 5:21:29 PM7/30/08
to
I'm using the original version 1 for Windows.


<rava...@yahoo.com> wrote in message
news:78ea407c-6c53-4b4a...@t12g2000prg.googlegroups.com...

0 new messages