Solved

Code Incorporate

Posted on 2014-12-27
11
105 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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
My experience with Windows 10 over a one year period and suggestions for smooth operation
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

831 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