?
Solved

Code Incorporate

Posted on 2014-12-27
11
Medium Priority
?
130 Views
Last Modified: 2014-12-27
Hi Experts,

I have Three WB
1 Downloading - which downloads Zip Files from Web
2 Unzipping - which unzip zip files which is downloaded by 1 i.e. above WB
3 Formatting -  which format unzipped .csv files.

I need to incorporate above all 3 in one WB so on one click Download then unzipping & formatting done.
I am attaching all 3 WB ...pls look in to this.

Thanks
01-Downloading.xlsm
02-Unziping.xlsm
03-Formating.xlsm
0
Comment
Question by:Naresh Patel
  • 6
  • 5
11 Comments
 
LVL 31

Expert Comment

by:gowflow
ID: 40519744
You mean to say you need at the end 1 click that will start from
download
then
Unzip
then
Format

all automatic right ?
gowflow
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 40519754
Yes Sir
0
 
LVL 31

Expert Comment

by:gowflow
ID: 40519770
ok here it is !!!

All you need to do is put now your start date in G3 instead of A1 and end date if you wish in H3 instead of B1 and press on start process ...

and, Enjoy !!!

I tested it from Dec 1 to date and worked fine.
Let me know.
gowflow
Incorporate-V02.xlsm
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
LVL 8

Author Comment

by:Naresh Patel
ID: 40519788
Downloading Done perfect but Unzipping not done so formatting also not done as there is No Zipped files in directory.
DownlodingUnzipping not done
Thanks
0
 
LVL 31

Expert Comment

by:gowflow
ID: 40519795
let me chk will revert
gowflow
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 40519801
Ok Sir.
0
 
LVL 31

Accepted Solution

by:
gowflow earned 2000 total points
ID: 40519805
ok your correct. it was question of trailing \
try this one now. Make sure you delete your current Incorporate-V02 and replace it with this one !!!!

gowflow
Incorporate-V02.xlsm
0
 
LVL 8

Author Closing Comment

by:Naresh Patel
ID: 40519813
Pore Perfect.
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 40519820
May I ask new question ....with new link. need to disable all clicks except "Start Process" i.e. need only one click and result ...no need of pop messages.

May I ?
0
 
LVL 31

Expert Comment

by:gowflow
ID: 40519828
Very quickly as going out in 5 minutes
gowflow
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 40519841
Here it is.


Thanks
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Though there are a few manual ways to import PST files to Office 365 , third-party PST to Office 365 import tools are preferred over them due to various reasons.  Consequently, many tools or services are available for the same. Here, we pick the to…
Here is why.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

590 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