Solved

Math G

Posted on 2014-02-03
28
197 Views
Last Modified: 2014-02-04
Hi Experts,

need to do one procedure while clicking button add to database in WB Math G it create new WB with specific format & save to hard corded destination path in code.

Step 1 copy data from WB Math G range L:W
Step 2 Sort Date oldest to new
Step 3 save as name = L1 i.e. "Test" in attached example.
Step 4 save to hard coded location.

See attached

Thanks
Math-G.xlsm
Test.xlsx
0
Comment
Question by:itjockey
  • 16
  • 12
28 Comments
 
LVL 29

Expert Comment

by:gowflow
ID: 39830008
Is this what you want ?
Activate the button save database and then look where the file has been saved it should be in the same directory when you save this current file !!!

Let me know we can fine-tune.
gowflow
Math-G-V01.xlsm
0
 
LVL 8

Author Comment

by:itjockey
ID: 39830050
Four things
1.Column B data round off to (No decimals).
2.date is oldest first & latest last.
3.Save path is C:\Data G\ (hard coded in Code itself)
4.Name as "Test" as cell value L1 in Math G = "Test" if there is "ABC" then name it "ABC".

remove messages as there is 2 message box pop up - remove it.


Thanks
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39830090
3.Save path is C:\Data G\ (hard coded in Code itself)


pls clarify. This is not clear
gowflow
0
 
LVL 8

Author Comment

by:itjockey
ID: 39830091
Sir will you tell me at what time you spare your time on EE, so I will post my question on that time only. it is up to you attend my question or not.


Thanks
0
 
LVL 8

Author Comment

by:itjockey
ID: 39830093
3.Save path is C:\Data G\ (hard coded in Code itself)


save path of WB "C:\Data G\"
0
 
LVL 8

Author Comment

by:itjockey
ID: 39830186
Did i asked something personal....apology .
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39830188
ok I have 2 problems:

No problem with the coded path "C:\Data G\" if it is not there it will be created.

my problems are:

1) you want to suppress the msgbox, that's fine however, if user by mistake press on Add to Database, how will he know that it has been saved correctly if nothing is said. I would suggest at least the last one to say File so and so saved successfully.

2) You asked for Col B to be no decimal that is ok HOWEVER you have also Col D, E, F and G are also same as Col B should they also be No decimal ?

gowflow
0
 
LVL 8

Author Comment

by:itjockey
ID: 39830229
1) you want to suppress the msgbox, that's fine however, if user by mistake press on Add to Database, how will he know that it has been saved correctly if nothing is said. I would suggest at least the last one to say File so and so saved successfully.

Agreed ok with message box.

2) You asked for Col B to be no decimal that is ok HOWEVER you have also Col D, E, F and G are also same as Col B should they also be No decimal ?

Yes but i dint find decimals point in that columns that is why i ignored.

Thanks
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39830251
Yes but i dint find decimals point in that columns that is why i ignored.

What it is full of Decimals !!!
You are mistaken with the columns I guess:
Col       D          E               F            G
      Open    High         low          Close

Shall I have them also no decimals ?
and comes to nice formatting you mind having them with coma at the 0000 ?
like 5,234 instead of 5234

easier to read. For the msgbox I put one at the end !

Let me know so I post it it is ready.
gowflow
0
 
LVL 8

Author Comment

by:itjockey
ID: 39830285
ohhhh my bad D E F G required decimals, it is actual trading points.
not required coma as  i am used to with without coma & i required this data for only calculation purpose i dint see this data at all (D E F G).i see only final results which is not in this process. this very first step of calculation. did you ever heard of W.D Gann.i am working on his strategy.



Thanks
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39830299
so bottom line what we have ?
B no decimal
D-G Decimal 2 ??? as now you have values 5432.2 and 6434.45 and 6522 shall I go ahead and do ####.00 ?

gowflow
0
 
LVL 8

Author Comment

by:itjockey
ID: 39830316
yes proceed Sir


Thanks
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39830326
ok here it is !!!
Let me know.

btw if you need to post something new I am on for the next few hours (however taking a break now for 1 hour or so).

gowflow
Math-G-V04.xlsm
0
 
LVL 8

Author Comment

by:itjockey
ID: 39830343
Not Now Sir - Stage 1 Clear - Now doing calculation part - it is easy by formula once we understand but to understand it is too difficult.

Thanks
0
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 
LVL 8

Author Comment

by:itjockey
ID: 39830354
Still missed naming part as it is saved as "DB-04-Feb-2014 0025" but actually it should be "Test". "Test" is actually name for testing it will be differ is real scenario.
0
 
LVL 8

Author Comment

by:itjockey
ID: 39830366
New post may take 1 or 2 day. As i am reading & applying in WB.


Thanks
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39830464
so is "Test-04-Feb-2014 0025.xlsx" fine ?
gowflow
0
 
LVL 8

Author Comment

by:itjockey
ID: 39830504
no only test is fine as in future need to add points (Data) by finding its name from whole folder.


Thanks
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39830536
so if you run it now it will be Test.xlsx and run it again with different values in 1 hour it will be Text.xlsx and override the previous ???
gowflow
0
 
LVL 8

Author Comment

by:itjockey
ID: 39830557
Not like that - now we are populating whole historical points, but after we done over calculation part it wont be like this process - it is like one row line data as & when it appears & add to data base in bottom.

Thanks
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39830568
hein ???
so what you want the name to be ? Test.xlsx ??? or ???
gowflow
0
 
LVL 8

Author Comment

by:itjockey
ID: 39830575
test.xlsx if there is cell L1= Test if cell L1 = xyz then xyz.xlsx

thnks
0
 
LVL 29

Accepted Solution

by:
gowflow earned 500 total points
ID: 39830660
I see !!!!
here it is
gowflow
Math-G-V04.xlsm
0
 
LVL 8

Author Closing Comment

by:itjockey
ID: 39830685
thank you very much ....& meet you soon on EE  :) :)
0
 
LVL 8

Author Comment

by:itjockey
ID: 39830721
You are available same time tomorrow?


thanks
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39832068
Well when you need something just put a message in here ... and when I reply will tak it from there. I usually always keep the last question opened and monitored so that when you need something you drop a line then I can assist with whatever. I cannot commit a certain time as with timezones differences everything changes.
gowflow
0
 
LVL 8

Author Comment

by:itjockey
ID: 39832327
it is just side line question than what we are working. if you wish pls look in to Macro To Activate Macro In Network WB


Thanks
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39832380
I will close this one and keep monitoring the new. Each and every time you have a new question I monitor the latest one and unmonitor all previous if they are closed.
gowflow
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now