My client already made application which will input my csv file in other program and it use "|" as separator and, also, he use "," as decimal separator so I can't change neither "|" or ",". Any suggestion how to change code so I could get same result?
Sorry, I don't often use help from this forum so I don't know how to post macro like you correct me. I'm not sure did you mean to put a file that I use or something else so I posted a file which I use to export csv file.
Also, thanks for helping me last time I posted question here, about 2...
Hey everybody,
I'm trying to write a macro that will export one of the sheets from workbook as csv file. The sheet I want to export looks like this (picture 1). The problem I have is that I always get double quotes around my text when I open a exported csv file (picture 2). This is the macro...
Hi, thank you for your answer.
Regarding Excel, I am using version 2013. In the attachment I am sending you: one pic (screenshot 6) - the potential look of a base which should be made by macro, the second one (screenshot 4) - the look of the imported file. The last attachment is a file that...
Hie,
I need to write a macro that should look to a certain cell where would be a location of a folder with an unknown numbers of .txt files. Macro should import and separate files on columns and then paste them one under another. In the end, it should delete all the files imported from folder...
I was trying to unlock sheet tab but it didn't work. Luckily, I found a password in some macro.
Vletm, I posted macro in vba, in sheet which I wanted to unlock and every time I got the same result, NOT RESPONDING. :)
Hie everybody,
I have a trouble to unlock sheet in xlsb excel file. College forgot password so I tried macro that I found on internet but it doesnt work. Also, I tried to convert it to zip and than unlock it with a trick that I found on yt but it also doesnt work. If somebody have idea, please...
Hi,
I would need some help.
I've attached a code and I have 9 of them for each file separately and they are all the same, only thing that differs is a name of file that each code should enter and the name of macro. The name of file is a name of brand manager which is also a name of each macro...
Hi everyone!
I'm trying to write a macro which will copy some sheet from one workbook and save it as a new workbook to location written on cell B14 in sheet "Uputstvo". For example, instead of saving it to location written in code, like I did, I want vba to look at cell B14 in sheet "Uputstvo"...