Solved

Code Incorporate

Posted on 2014-12-27
11
99 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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

708 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

16 Experts available now in Live!

Get 1:1 Help Now