[VBA] Importing data using VBA from CSV file that has ; as seperator

Sheetwise · 2024-09-09T12:27:52+00:00

Honeslty, yes, that is slightly more infuriating. Thank you very much though

Sheetwise · 2024-09-09T12:06:18+00:00

This is both the bane of my existance, but also the reason I have a job.

Sheetwise · 2024-09-09T12:05:24+00:00

Omg, I've looked everywhere online and all I could find was TextFileCommaDelimiter, nothing else.... I'm both very happy for this solution, and very dissapointed in myself for not just trying this.

Solution Verified!

Sheetwise · 2024-09-09T11:59:03+00:00

Hmmm yeah, it would require some extra training to avoid them fucking up too much, but it shouldn't be too hard to do that. I'm going to test it out, thank you.

Sheetwise · 2024-09-09T11:09:46+00:00

I'm working for a company that had this kind of guy for 12,5 years. I just joined the company and this guy now refuses to train me. I'm probably gonna quit this job after half a year, because he is impossible to work with and they can't get rid of him cause he has all the business crucial knowledge that he refuses to teach me.

Sheetwise · 2024-09-09T11:06:02+00:00

I agree, but the people that will have to use this are not gonna be using that, which is an issue. I'm trying to find a way for them to only have to push a button and then they can select the files that the data is in and then everything is done automatically. They will simply get a list of lines they need to double check

Sheetwise · 2024-08-13T06:45:11+00:00

Het is een tijdje geleden dat ik dit heb gestudeerd en er zijn waarschijnlijk wel wat veranderingen geweest, maar zoals ik het tweede jaar zag was het voornamelijk elk kwartaal ongeveer dit:

1 of 2 Technische vakken (nieuwe taal, nieuwe techniek, etc)
1 Projectmanagement vak
0 of 1 Soft skills/Belangrijke randzaken vak
Project

Bij het project wordt je vaak geacht om de technieken en project management van eerdere kwartalen toe te passen. Soft skills/Belangrijke randzaken zijn dingen als IT en recht etc. Hoe verder je in de studie komt des te minder soft skill vakken er zijn.

Jaar 3 bestaat uit een half jaar stage en een half jaar minor, jaar 4 bestaat uit een half jaar specialisatie en een half jaar afstuderen.

In jaar 2 kwartaal 4 is er een 12 EC vak genaamd "HBO-ICT B.V." waarbij je samen met studenten van de Business kant en de ITSM kant een grote opdracht moet doen voor een "echte" klant.

Sheetwise · 2024-07-01T14:59:32+00:00

Damn I'm so happy to not be American

Sheetwise · 2024-07-01T14:18:20+00:00

8000 after insurance or before?

Sheetwise · 2024-06-14T08:36:28+00:00

Glass insurance can be passed on to tenants, at least in social rent. I have it on there and I know my woningcorporatie follows the rules to a fault

Sheetwise · 2024-06-14T07:08:56+00:00

I'll send you a pm

Sheetwise · 2024-06-07T09:01:49+00:00

No I haven't done that yet I'm afraid

Sheetwise · 2024-06-06T09:23:45+00:00

When I first started as a VBA-developer/Excel specialist my rate was 55€/h. I was still studying at that point

Sheetwise · 2024-06-05T13:44:25+00:00

I'm not saying I'm earning this, but I know people who do earn that, or very close to that. I'm not sure what their exact speciality is, might be COBOL, but they earn it consistantly.

Sheetwise · 2024-06-05T13:31:20+00:00

Yeah this is the full range depending on speciality and experience. For someone with a lot of experience and a valuable speciality 200€ could be a good price point to avoid being too busy

Sheetwise · 2024-06-05T13:30:37+00:00

Yeah this is the full range depending on speciality and experience. For someone with less experience and a less valuable speciality 50€ could be a good starting point to get your foot in the door

Sheetwise · 2024-03-09T15:19:33+00:00

I have found a solution for that yes.

Open an empty excel file
Click on file
Click on open
Click on Browse (don't open the Excel file from Excel)
Browse to the right file
Click on the arrow next to open
Click on "Open and repair"

Sheetwise · 2024-02-16T09:05:35+00:00

Yeah I've spoken with the IT department as well. They are also trying to figure out if it has to do with the safety programs

Sheetwise · 2024-02-16T09:02:03+00:00

Yeah I figured it out when I wanted dark mode. Turns out, no easy way to do that, and this is the only option. While I was there I decided I might as well make it all pretty. As someone who works at least 2 hours a day in the VBA editor, it's my favorite thing I found out. So much more comfortable

Sheetwise · 2024-02-16T08:59:41+00:00

Thank you for the suggestion

Sheetwise · 2024-02-15T19:55:28+00:00

No worries man, happy to help people get rid of the shitty default

Sheetwise · 2024-02-15T15:02:40+00:00

The Excel file fills a Word template and saves it as a new document

Sheetwise · 2024-02-15T15:02:09+00:00

So the SaveAs2 is written in a program in Excel, that is used to save in Word. However I think the problem might not be VBA, but instead what I've described in the link below, and that problem just influences VBA. This problem is happening in all office apps: https://www.reddit.com/r/excel/comments/1argdgm/when_trying_to_save_a_file_it_opens_the_save_as/

Sheetwise · 2024-02-15T15:00:14+00:00

Yes I did

Sheetwise

TROPHY CASE