03-11-2010, 08:01 PM
I'm sure there are, and I'm trying to learn how to do things better, unfortunatley I'm not a programmer and I have to balance learning time with getting the job done. I don't know all the tricks but I'm willing to work on it.
Anyway
When I paste what Gintares suggests into the macro,
It errors Error unknown member.
on timeformat
str s1.getclip
str s2.timeformat(".{MMddyy}.chg")
s2-s1
key (s2)
Anyway
When I paste what Gintares suggests into the macro,
It errors Error unknown member.
on timeformat
str s1.getclip
str s2.timeformat(".{MMddyy}.chg")
s2-s1
key (s2)
TheVig Wrote:So you want to essentially export text versions from an excel file with the date appended to the file name?
I'm sure you could use QM to control Save As functions in excel directly without using your hack method.
Search the forum for Excel, somewhere there is a post for Save As. It may or may not be able to choose file format.
There are many better ways to do this than what you are doing right now.
Jimmy Vig