Replies

Coleman, you were right. For my task, I can also do it this way. Thanks!

Hans, thanks a lot for your help.

Coleman, thank you very much for your reply. this code helps me to shift other datas in following columns.

I appreciate your help.

Hans,
i use this to study financial market.
Thanks for the code. Thanks a lot.
i hope you can help me.

Regards,
Boat.

Coleman and Steve and Kieran,
Thanks. Thanks a lot.

Thanks. Thank you very much.

ok Hans. i kind of get it. Thanks.

ok Hans. i kind of get it. Thanks.

hi Tony, just want to check with you although let me explain first with how my pc went, i got the pc installed with XP myself with the guide displayed during my XP installation.

is reformat pc is same as reinstall XP? as i understand and wanted to do is delete all the software and whatever data available in the pc after i done this procedure. i seems to know that the techinician deleted all my data and files using CD before asking me to reinstall XP, which means deleting the old stuffs is another procedur? thanks.

hi Tony, just want to check with you although let me explain first with how my pc went, i got the pc installed with XP myself with the guide displayed during my XP installation.

is reformat pc is same as reinstall XP? as i understand and wanted to do is delete all the software and whatever data available in the pc after i done this procedure. i seems to know that the techinician deleted all my data and files using CD before asking me to reinstall XP, which means deleting the old stuffs is another procedur? thanks.

Hi jscher, i seems not to get it done with your idea, maybe you could have a look where went wrong in attached file. there are Data tab, Line chart with symbol tab and Line chart tab. the Data tab basically is the data source with date, price and symbol information. Line chart is the basic chart from data source of date and price. and Line chart with symbol is the line chart included symbol column. the line chart seems reasonable but something is wrong with the line chart with symbol. if chart wizard alone can do it, it possible reduce other efforts in doing so. thank you.

Edit: although i realise data with rows like 2000 does cramp in a chart, with not nice looking graph, but i haven’t got any software that does this, and i just wanted to view the price trend and its symbol somewhere roughly, if at least this is the first step. thanks again.

Hi jscher, i seems not to get it done with your idea, maybe you could have a look where went wrong in attached file. there are Data tab, Line chart with symbol tab and Line chart tab. the Data tab basically is the data source with date, price and symbol information. Line chart is the basic chart from data source of date and price. and Line chart with symbol is the line chart included symbol column. the line chart seems reasonable but something is wrong with the line chart with symbol. if chart wizard alone can do it, it possible reduce other efforts in doing so. thank you.

Edit: although i realise data with rows like 2000 does cramp in a chart, with not nice looking graph, but i haven’t got any software that does this, and i just wanted to view the price trend and its symbol somewhere roughly, if at least this is the first step. thanks again.

hi all. thank you for so many expert advices. i do agree macro recording is for beginner and vba programming is for advance user. and i also realise vba programming language learning is not quite easily adaptable by every person.

thanks.

Edit: one more question about macro please, is it harmful to pc or software or in anyway, if i often cancell a macro that is running, meaning i press Esc to cancell it. thanks.

hi all. thank you for so many expert advices. i do agree macro recording is for beginner and vba programming is for advance user. and i also realise vba programming language learning is not quite easily adaptable by every person.

thanks.

Edit: one more question about macro please, is it harmful to pc or software or in anyway, if i often cancell a macro that is running, meaning i press Esc to cancell it. thanks.

This set of replies was moved here from the Hardware board by StuartR. They were originally posted as replies to post 425930

hi Howard Kaikow. now i understand. one more thing i want to check with you, normally, or is it, recorded macro run more faster than vba programmed macro (of the same task) or vice versa.

thanks for your advice.

Edit: one more thing, what do you mean by ‘ALL dat’. ‘dat’, is it data?

This set of replies was moved here from the Hardware board by StuartR. They were originally posted as replies to post 425930

hi Howard Kaikow. now i understand. one more thing i want to check with you, normally, or is it, recorded macro run more faster than vba programmed macro (of the same task) or vice versa.

thanks for your advice.

Edit: one more thing, what do you mean by ‘ALL dat’. ‘dat’, is it data?