Solved

Code Incorporate

Posted on 2014-12-27
11
111 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
11 Comments
 
LVL 30

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 30

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
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

 
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 30

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 30

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

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

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

This article describes a serious pitfall that can happen when deleting shapes using VBA.
Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

688 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