excel - convert xlsx file to csv -


i trying find fast way save xlsx files csv files same filename xlsx file (just in csv format). have recorded macro shortcut, issue whenever try new file saves same filename recorded initial macro (i.e. see below, because have file labelled in code as: 3wdl_1 (2014-08-07)10secdatatable sit.csv). there need replace 3wdl_1 (2014-08-07)10secdatatable sit.csv make macro save same filename actual workbook working with.

so have folder full of xlsx files , want use shortcut/macro on each xslx file convert them csv files have same name original xlsx file, , saved same folder.

i need replace 3wdl_1 (2014-08-07)10secdatatable sit.csv portion of code work new xlsx file open up. otherwise may old fashioned way mouse

thanks in adcance,

paddy

sub saveascsvfile  chdir "c:\users\paddy\desktop\new csv files whole cgm date ok!" activeworkbook.saveas filename:= _     "c:\users\paddy\desktop\new csv files whole cgm date ok!\" & _          "3wdl_1 (2014-08-07)10secdatatable sit.csv", _         fileformat:=xlcsvmac, createbackup:=false end sub

to file name, use: activeworkbook.name path, use: activeworkbook.path

something should work well:

activeworkbook.saveas filename:= activeworkbook.path & "\" & _     replace(activeworkbook.name, "xslx", "csv"), _     fileformat:=xlcsvmac, createbackup:=false

Comments

Post a Comment

Popular posts from this blog

jquery - How do you format the date used in the popover widget title of FullCalendar? -

Image
in fullcalendar, how format date used in popover widget title when clicking '+n more'? code: <div class="fc-popover fc-more-popover"> <div class="fc-header fc-widget-header"> <span class="fc-close fc-icon fc-icon-x"></span> <span class="fc-title">tuesday, april 7</span> ... </div> ... </div> you use daypopoverformat that. determines date format of title of popover created eventlimitclick option. must date formatting string. default value "dddd, mmmm d" english , "ll" other languages.
Read more

asp.net mvc - SSO between MVCForum and Umbraco7 -

i need integrate sso between mvcforum (forum of company) , umbraco7 (manages cms company). however struggling shared authentication work. tried several ways suggested on other threads still not running expected. here did: 1. in mvcforum (forum.mywebsite.com) 1.1. machine key in web.xml: <machinekey validationkey="the same key umbraco7" decryptionkey="the same key umbraco7" validation="sha1" decryption="aes" /> 1.2. authenticate forms in web.xml <forms name="my-sso-auth" protection="all" path="/" timeout="43200" domain="forum.mywebsite.com" loginurl="/members/logon" enablecrossappredirects="true" /> 2. in umbraco7 (news.mywebsite.com) 2.1. machine key in web.xml: <machinekey validationkey="the same key mvcforum" decryptionkey="the same key mvcforum" validation="sha1" decryption="aes" /> 2.2. a...
Read more

Python Tkinter keyboard using bind -

i have problem using bind option can click button in keyboard, , call function once key pressed. tried taking other codes have similar purpose , saw i'm doing pretty same, though still have problem must've missed. thankful if me this. here's code: # -*- coding: utf-8 -*- #imports tkinter import * pil import imagetk, image import time import tkmessagebox #===========================================================================================================================================# #tkinter class class app(frame): def __init__(self, master=none): frame.__init__(self, master) self.pack() #===========================================================================================================================================# #game pieces classes class board: def __init__(self, rows = 7, columns = 6, picture_height = none, picture_width = none): self.rows = rows self.columns = columns self.picture ...
Read more