使用VBA将压缩的csv文件导入Excel [英] Importing zipped csv file to Excel using VBA
问题描述
大家好，
我正在寻找一些建议。我必须以zip格式导入网站页面上的csv文件。我有一段代码可以与winzip一起工作，但我不认为客户端有winzip可用。在我坚持他们必须得到它之前，我想知道是否有任何其他方法可以使用Windows压缩文件选项。
此过程必须自动化。
欢迎任何建议。
Mary
Hi guys,
I''m looking for some advice. I have to import a csv file which is on a website page in zip format. I have a piece of code thats supposed to work with winzip but I don''t think the client has winzip available. Before I insist that they must get it I was wondering if anyone has any other method that would work with windows compressed files option.
This process has to be automated.
Any advice welcome.
Mary
推荐答案
是否是传统压缩？ Windows拥有自己的带命令行功能的zip。
Is it legacy compression? Windows has it''s own zip with command line functionality.
你好兔子
感谢您的建议。
不确定这对我有何帮助。假设我将它与shell命令一起使用，如何将命令引导到网站路径以及我使用什么命令解压缩并将内容保存为？
Mary
Hi Rabbit
Thanks for the suggestion.
Not sure how this will help me. Assuming I use it with the shell command, how do I direct the command to the website path and what command do I use to unzip and save contents as?
Mary
你好兔子
感谢您的建议。
Not确定这对我有什么帮助。假设我将它与shell命令一起使用，如何将命令引导到网站路径以及我用什么命令将内容解压缩并保存为？
Mary
Hi Rabbit
Thanks for the suggestion.
Not sure how this will help me. Assuming I use it with the shell command, how do I direct the command to the website path and what command do I use to unzip and save contents as?
Mary
你是如何用winzip做的？ winzip是否允许您指定网站路径？我以为你先用一个单独的方法来下载文件。
How did you do it with winzip? Does winzip let you specify a website path? I thought you were using a separate method to download the file first.
这篇关于使用VBA将压缩的csv文件导入Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
