Search results for query: *

oops, so sorry I'm in the wrong forum, feel free to move the thread if you want. I don't fully understand how to make conditional formatting. --Metahari

Wow, thanks! Ok, now it goes through the selected cells I used cell.select from pbrodsky. What about not checking blank cells, or... haha, I hit select all and had to escape out as it started checking to infinity. So, perhaps a way to only check the rows and columns that exist? --Metahari

oops, I meant to say this is for Excel 2000. --Metahari

I have created a macro to highlight the cells in my file if they exceed 55chars. (So I can decide how to abbr the cells myself) If the cell is fine(before or after I fix it), then the macro sets the cell back to no color. The macro actually works, but I have two issues. 1) I can't seem to...

I'm sorry, I've never done a proposal like this before, so you can understand my confusion. I'm open to suggestions. I'm also quite limited on time to submit this. (less than a week now) They are asking me for time, money, hardware and software considerations. So, it looks like I'm looking...

I'm not sure I can trust this to open source, as the company has all win machines, and no one to support linux/unix solutions. It needs to be robust and stable. Personally I like open source, if the product works well enough, installs easy enough and does all we ask, it may be a viable...

Hello there, I'm working on a brief Web Proposal for a global company. I know they need some sort of CMS to empower a variety of people in the company to post and update news and articles, ect. I'm looking for a some sort of software that I can install that can use templating, and MSSQL and...

Thanks so much for your help. It's crazy, I'm in SQL everyday for something, mostly some queries and testing, and there's still so much to learn. Thanks for letting me ask the little questions too. --Metahari

Oh wow, thanks! Oops, must have been scrolled down when I put the second language line in. And I forgot a </p>! Just another quick clarification. northwind..employees == database..table ?? Good call on the export location, again, I'll make that clearer. --Metahari

Ok, so, I need to make a stored procedure that does this? So I should: Right-click Stored Procedures; then click New Stored Procedure called 'procExportTable' Enter the text of the stored procedure. (Paste this?) exec master.dbo.xp_cmdshell 'bcp "select firstname,lastname from...

I'm not certain that the asp page would be on the machine that needs the table exported to csv. That is a good point/option to keep in mind. So this would look like Dim fso, MyFile Set fso = CreateObject("Scripting.FileSystemObject") >loop through the file here? Is this where I'd add...

How would I call this from the asp. I've never used a stored procedure from asp, I would need some sort of object? --Metahari

Whoah, I'll have to dig into xp_cmdshell and osql, I've never even heard of those things. (looks through the msdn) Any tips? thanks, Stacie --Metahari

Hi there, I have a question. I'm trying to figure out how to make a trigger or stored procedure or a combination of those that will export a table to a .csv file when you click a button on a webpage. Has anyone done something like this? I'm not really sure a trigger is even what I want or...

This post helped me too. I had to not import my first column (which was an an empty id column) so I could use the auto-increment. --Metahari