|
PureBytes Links
Trading Reference Links
|
Hi Yuki,
As per my knowledge, you can do the required by using a external Macro, like Macro Express. One of the steps which can be taken out is Item No.2, you can give default save format as .csv.
MacroExpress has a 30 day trial. Do try it out. I do think you can accomplish the needfull by using that.
Regards
Prashanth
----- Original Message -----
From: "Yuki Taga" <yukitaga@xxxxxxxxxxxxx>
To: "Terry" <amibroker@xxxxxxxxxxxxxxx>
Sent: 13 August, 2004 7:14 PM
Subject: Re: [amibroker] Re: editing default.format
> Hi Terry,
>
> Friday, August 13, 2004, 10:02:05 PM, you wrote:
>
> T> Yuki,
>
> T> Your Excel file can be saved as a normal Excel file and the macro can be
> T> modified to automatically SaveAs a .csv before importing.
>
> This is exactly what Graham is trying to help me with. Exactly.
>
> But here in a nutshell is my problem, that I don't know how to solve:
>
> If I record a macro of the act of saving a file from an xls file
> (macro capable) to a csv file (macro incapable), I guess I lose the
> macro, because the file is saved in a format that cannot contain a
> macro. See my problem?
>
> Here is what I'm looking to automate as much as possible:
>
> (copy of partial mail I sent to Graham on this)
>
> The idea of course is to save as much time and keystrokes as
> possible. But, the most time consuming part of the operation is
> hitting Save As, then scrolling through the myriad Excel file type
> choices, finally selecting CSV.
>
> Worse, there are a lot of popup dialogs when all this happens. First,
> an "overwrite ok?" popup (I'd usually be overwriting the csv file).
> Then, an "okay to give up incompatible formatting?" dialog. And
> until one actually *closes* the csv file, AB gives a shared-file
> error on import attempt.
>
> Now, here is a really odd thing: To close this newly overwritten csv
> file, one we just agreed to overwrite and give up formatting on, we
> must now go through the same two dialog routines again. Aggravating!
>
> So, to be as clear as I can about this, the following procedure needs
> to be automated as best as possible:
>
> 1) Save as
> 2) Scroll down the file type list to CSV files
> 3) Agree to an overwrite pop up dialog
> 4) Agree to a "give up incompatible formatting" pop up dialog
> 5) Close the cvs file (or close Excel) which means . . .
> 6) Agree to save changes (weird, but yes, every time)
> 7) Agree to "give up formatting" (why this duplication?)
> 8) Now we are finally good for AB to import
>
> I would love to be able to handle the first 7 steps with a macro, but
> I can't figure out how to do it. ^_^
>
> I guess I could (if I was capable) create this macro externally from
> the file, and save it. But I would not know how to write the thing.
> The only way I could do this is record it, and that doesn't seem to
> work.
>
> Yuki
>
>
>
>
> Check AmiBroker web page at:
> http://www.amibroker.com/
>
> Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html
> Yahoo! Groups Links
>
>
>
>
>
>
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Yahoo! Domains - Claim yours for only $14.70
http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/GHeqlB/TM
--------------------------------------------------------------------~->
Check AmiBroker web page at:
http://www.amibroker.com/
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/amibroker/
<*> To unsubscribe from this group, send an email to:
amibroker-unsubscribe@xxxxxxxxxxxxxxx
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
|