|
PureBytes Links
Trading Reference Links
|
Yuki,
When I have more time Išll read your question in detail.
A quick tip is that Excel allows you to have a PERSONAL macro. You can save
any macro here and it is not save with the workbook macros. I is save in a
file called Personal.xls located in C:\Documents and
Settings\~user\Application Data\Microsoft\Excel\Personal.xls where ~user is
your login name.
Terry
--
> 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 Sponsor
>
> ADVERTISEMENT
>
> <http://us.ard.yahoo.com/SIG=1295r04ib/M=298184.5285298.6392945.3001176/D=grou
> ps/S=1705632198:HM/EXP=1092491086/A=2164331/R=0/SIG=11eaelai9/*http://www.netf
> lix.com/Default?mqso=60183351>
>
>
> 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
> <mailto:amibroker-unsubscribe@xxxxxxxxxxxxxxx?subject=Unsubscribe>
> *
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/> .
>
--
Terry
[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/
|