[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [amibroker] editing default.format



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/