SQL / Excel question - Page 2

BigV · 05-26-2006, 08:20 PM

Oh, I forgot...

The reason I was having trouble was that I made the vba module, but when I tried to go back into the file, or another file, there were two problems. First, I hadn't saved the module as an ??? .xla add-in.

Then, when I did save it, I re-entered the file and didn't have the security certificate to run the macro (?) without setting the security level to low. So (against my better judgement) low it was. Voila! Now I know. (kinda)

BigV · 05-26-2006, 08:35 PM

On a different subject, would you suggest vi or jEdit for my first Unix/Linux based editor? I have to learn one to do part of my new job. vi looks pretty creaky (reminds me of edlin). Your suggestions are welcome. Open source/free has preference.

MaggieL · 05-26-2006, 09:19 PM

Well, jEdit is Java-based, runs on Linux or Windows as long as GUI is available. (and Java, of course). It has a *lot* of fairly cool plugins if you're doing develoment work, understands bazillions of formats and syntaxes, integrates well with Ant and Beanshell. Since it's menu driven and has an extensive help system, I think it's easy to learn.

vi is available preinstalled on most Linux distros, and is fairly ubiquitous on Unix too. The one good thing about it is it will run in a character-based session like ssh or telnet, so it's used a lot to maintain server configuration files.

I use vi when I have to, and jEdit when I don't. Both are free and open-source.

05-26-2006, 08:20 PM	#16
BigV Goon Squad Leader Join Date: Nov 2004 Location: Seattle Posts: 27,063	Oh, I forgot... The reason I was having trouble was that I made the vba module, but when I tried to go back into the file, or another file, there were two problems. First, I hadn't saved the module as an ??? .xla add-in. Then, when I did save it, I re-entered the file and didn't have the security certificate to run the macro (?) without setting the security level to low. So (against my better judgement) low it was. Voila! Now I know. (kinda) __________________ Be Just and Fear Not.

05-26-2006, 08:35 PM	#17
BigV Goon Squad Leader Join Date: Nov 2004 Location: Seattle Posts: 27,063	On a different subject, would you suggest vi or jEdit for my first Unix/Linux based editor? I have to learn one to do part of my new job. vi looks pretty creaky (reminds me of edlin). Your suggestions are welcome. Open source/free has preference. __________________ Be Just and Fear Not.

05-26-2006, 09:19 PM	#18
MaggieL in the Hour of Scampering Join Date: Jan 2001 Location: Jeffersonville PA (15 mi NW of Philadelphia) Posts: 4,060	Well, jEdit is Java-based, runs on Linux or Windows as long as GUI is available. (and Java, of course). It has a lot of fairly cool plugins if you're doing develoment work, understands bazillions of formats and syntaxes, integrates well with Ant and Beanshell. Since it's menu driven and has an extensive help system, I think it's easy to learn. vi is available preinstalled on most Linux distros, and is fairly ubiquitous on Unix too. The one good thing about it is it will run in a character-based session like ssh or telnet, so it's used a lot to maintain server configuration files. I use vi when I have to, and jEdit when I don't. Both are free and open-source. __________________ "Neither can his Mind be thought to be in Tune,whose words do jarre; nor his reason In frame, whose sentence is preposterous..."

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)