Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 231
  • Last Modified:

Math G

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
Naresh Patel
Asked:
Naresh Patel
  • 16
  • 12
1 Solution
 
gowflowCommented:
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
 
Naresh PatelTraderAuthor Commented:
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
 
gowflowCommented:
3.Save path is C:\Data G\ (hard coded in Code itself)


pls clarify. This is not clear
gowflow
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Naresh PatelTraderAuthor Commented:
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
 
Naresh PatelTraderAuthor Commented:
3.Save path is C:\Data G\ (hard coded in Code itself)


save path of WB "C:\Data G\"
0
 
Naresh PatelTraderAuthor Commented:
Did i asked something personal....apology .
0
 
gowflowCommented:
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
 
Naresh PatelTraderAuthor Commented:
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
 
gowflowCommented:
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
 
Naresh PatelTraderAuthor Commented:
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
 
gowflowCommented:
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
 
Naresh PatelTraderAuthor Commented:
yes proceed Sir


Thanks
0
 
gowflowCommented:
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
 
Naresh PatelTraderAuthor Commented:
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
 
Naresh PatelTraderAuthor Commented:
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
 
Naresh PatelTraderAuthor Commented:
New post may take 1 or 2 day. As i am reading & applying in WB.


Thanks
0
 
gowflowCommented:
so is "Test-04-Feb-2014 0025.xlsx" fine ?
gowflow
0
 
Naresh PatelTraderAuthor Commented:
no only test is fine as in future need to add points (Data) by finding its name from whole folder.


Thanks
0
 
gowflowCommented:
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
 
Naresh PatelTraderAuthor Commented:
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
 
gowflowCommented:
hein ???
so what you want the name to be ? Test.xlsx ??? or ???
gowflow
0
 
Naresh PatelTraderAuthor Commented:
test.xlsx if there is cell L1= Test if cell L1 = xyz then xyz.xlsx

thnks
0
 
gowflowCommented:
I see !!!!
here it is
gowflow
Math-G-V04.xlsm
0
 
Naresh PatelTraderAuthor Commented:
thank you very much ....& meet you soon on EE  :) :)
0
 
Naresh PatelTraderAuthor Commented:
You are available same time tomorrow?


thanks
0
 
gowflowCommented:
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
 
Naresh PatelTraderAuthor Commented:
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
 
gowflowCommented:
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 16
  • 12
Tackle projects and never again get stuck behind a technical roadblock.
Join Now