User Meehow | chat.stackexchange.com

Meehow

Sep 14, 2017 21:19

you have fun here I'll see you around

Meehow

Sep 14, 2017 21:18

im off lads, gotta get up at round 5 am to drive my sis to Luton airport...

Meehow

Sep 14, 2017 21:16

doesn't even requre Excel (newish excel is XML anyway)

Meehow

Sep 14, 2017 21:16

closest that comes to me now would be ~ClosedXml

Meehow

Sep 14, 2017 21:15

i havent touched VBA in ages so Im a bit rusty

Meehow

Sep 14, 2017 21:15

but what's an alternative of equivalent speed writing to cells

Meehow

Sep 14, 2017 21:15

didn't we just want to get rid of a ADODB.Recordset :P ?

Meehow

Sep 14, 2017 21:14

that shouldn't be hard, there are plenty of drivers

Meehow

Sep 14, 2017 21:14

something that VBA can easily read and convert to a recordset

Meehow

Sep 14, 2017 21:14

save to a DB file from C#

Meehow

Sep 14, 2017 21:13

recordset work-around ....

Meehow

Sep 14, 2017 21:11

overkill

Meehow

Sep 14, 2017 21:09

well it's like if you wanted to combine a vb.net and c# files into same project

Meehow

Sep 14, 2017 21:08

ever.

Meehow

Sep 14, 2017 21:08

and you won't be able to do that

Meehow

Sep 14, 2017 21:08

you can't

Meehow

Sep 14, 2017 21:07

like Matt said return something Enumerable

Meehow

Sep 14, 2017 21:06

sure, but since you're referencing a COM dll written in C#, do everything in C# and just return whatever VBA needs to cooperate with

Meehow

Sep 14, 2017 21:05

@this dont need to

Meehow

Sep 14, 2017 21:04

@this naugh, use a C# dll that exposes connection done properly without ADO

Meehow

Sep 14, 2017 21:04

that's basically what it's doing

Meehow

Sep 14, 2017 21:03

.tt files?

Meehow

Sep 14, 2017 21:03

loading a .dll that allows you to acces the objject explorer tree in SSMS

Meehow

Sep 14, 2017 21:02

get the idea?

Meehow

Sep 14, 2017 21:02

<#@ import namespace="Microsoft.SqlServer.Management.Smo" #>

Meehow

Sep 14, 2017 21:02

<#@ assembly name="EnvDTE" #>
<#@ assembly name="C:\Program Files (x86)\Microsoft SQL Server\120\SDK\Assemblies\Microsoft.SqlServer.Management.Sdk.Sfc.dll" #>
<#@ assembly name="C:\Program Files (x86)\Microsoft SQL Server\120\SDK\Assemblies\Microsoft.SqlServer.Smo.dll" #>
<#@ assembly name="C:\Program Files (x86)\Microsoft SQL Server\120\SDK\Assemblies\Microsoft.SqlServer.ConnectionInfo.dll" #>

Meehow

Sep 14, 2017 21:02

@Mat'sMug it's done differently

Meehow

Sep 14, 2017 20:59

@Mat'sMug it's not based on a connection string, you could (i think) use COM to connect to SQL and then reverse engineer what's defined in the .txt

Meehow

Sep 14, 2017 20:58

@IvenBach get yourself account on pluralsight (or have your employer, if they have msdn subscription they get that). Many courses that REALLY, and i mean REALLY help

Meehow

Sep 14, 2017 20:57

@Mat'sMug not sure this has been done but you know templates in C# where you can basically mimic EF and create a .txt file and template that will generate model and database context for you in c#. A project idea would be to do something similar in VBA, that would be fantastic

Meehow

Sep 14, 2017 20:55

@IvenBach can you be more specific, what's that you need?

Meehow

Sep 14, 2017 20:51

@Hosch250 I doubt it but I can double check. If I find anything I'll hit you up

Meehow

Sep 14, 2017 20:43

it's how you pronounce my name, dont laugh or I'll show my you surname hahah

Meehow

Sep 14, 2017 20:42

who's this btw -> stackoverflow.com/users/117700/l

Meehow

Sep 14, 2017 20:41

SO

Meehow

Sep 14, 2017 20:41

Siddharth, brettdj, tim william, jeeped, gary, hansup, jean-(the french guy)

Meehow

Sep 14, 2017 20:40

that's great. and how are the other top10 lads, they're still around?

Meehow

Sep 14, 2017 20:39

@Mat'sMug is RubberDuck still around?

Meehow

Sep 14, 2017 20:39

@Mat'sMug nice try buddy buddy! ;)

Meehow

Sep 14, 2017 20:37

if you know what i mean :P

Meehow

Sep 14, 2017 20:37

and the time is now 21:37

Meehow

Sep 14, 2017 20:37

@IvenBach been done done that ;) I used to live in the USA for about 5 years so yeah I know what you mean my american brother from another mother

Meehow

Sep 14, 2017 20:35

@IvenBach you know there still are a lot of companies in the UK running on spreadsheets...a by a lot I probably mean every 3rd mid size company :P

Meehow

Sep 14, 2017 20:34

changed job and pursued C# which turned out to be a great career move

Meehow

Sep 14, 2017 20:33

@IvenBach naugh :) but that would have put me in a better spot over having to explain to my boss why there's 20 people a day trying to get me to talk to them... using the company phone line... long story

Meehow

Sep 14, 2017 20:30

just had to kind of disappear for a while

Meehow

Sep 14, 2017 20:30

banking companies in london etc.

Meehow

Sep 14, 2017 20:30

people were calling my workplace asking for me etc.

Meehow

Sep 14, 2017 20:29

1st

Meehow

Sep 14, 2017 20:28

thank you but I just came by to say hi :)

Meehow

VBA Rubberducking