Solved

Code Incorporate

Posted on 2014-12-27
11
103 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:itjockey
  • 6
  • 5
11 Comments
 
LVL 29

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:itjockey
ID: 40519754
Yes Sir
0
 
LVL 29

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
 
LVL 8

Author Comment

by:itjockey
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 29

Expert Comment

by:gowflow
ID: 40519795
let me chk will revert
gowflow
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 8

Author Comment

by:itjockey
ID: 40519801
Ok Sir.
0
 
LVL 29

Accepted Solution

by:
gowflow earned 500 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:itjockey
ID: 40519813
Pore Perfect.
0
 
LVL 8

Author Comment

by:itjockey
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 29

Expert Comment

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

Author Comment

by:itjockey
ID: 40519841
Here it is.


Thanks
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will show you how to use shortcut menus in the Access run-time environment.
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

863 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

27 Experts available now in Live!

Get 1:1 Help Now