Recent content by AnnaWnz

Hi Have just discovered that this works okay in Excel 2000 but not in 97 - and most of our stuff is in 97. Is some part of the code only applicable to 2000, and if so, is there a way around it in 97? Thanks in advance. Anna

Hi I am trying to get page breaks to insert when printing or print previewing. There are five buttons in the spreadsheet, each attached to a vba script that sets the relevant pages breaks, sets the print area, etc. All works ok, except the page breaks - any ideas?? Here is the code for one...

Hi I am running a script that includes ALTER DATABASE, which requires a user with one of the following roles: - sysadmin - dbcreator - db_owner We don't want to use sa to run the script, but use someone's usual login. Is there any issue with having more than one db_owner for a database. Or...

Hi Transcend When I run that line I get what I expected, which is why I'm confused that the code you gave me doesn't work. Hang on, think I've got it working now - something to do with the data not the script, shall have to do some more testing but shall post result! Thanks for your help. Anna

Hi Transcend I have tried that - I don't get any errors, but I still get no results. It's still like the values being passed are not being picked up by the stored procedure correctly?? Any ideas? Anna

Hi I am trying to run a stored procedure that requires four value be fed into it, but I don't want to use fixed values, but use values from a table instead and am not sure how to write this out. what I have written is: select value1, value2, value3, value4 from #TEMP1 EXEC stored_procedure...

Hi I am after a couple of bits of help: 1. I want to run a script, which is initiated manually, but it needs to check the Activity table firs to ensure that there are no users logged in, and if there are, then the script won't run and the user will be informed. I know how to find out if there...

Hi Does anyone have any recommendations for books on writing SQL queries? Cheers Anna

Thanks so much. Worked perfectly!! Anna

Hi all I am trying to update a field in one table with information from another table based on a few restrictions. Table 1: holds the fields ITEMNUMBER and VENDORID Table 2: holds the fields VENDORID and VENDORCLASS Table 3: holds the fields ITEMNUMBER and CATEGORY The restrictions include...

Hi The buttons all print okay (the PrintObject is true) and print preview okay, it is when I close the print preview that the buttons actually disappear off the worksheet - as if they were never there. ANd when you close the workbook, they don't return. As I say - as if they were never there...

Hi all This one has me stumped!! I have an excel spreadsheet with extensive code running all sorts of functions etc - this is all working fine! I have a button on the front page that allows the user to print preview all the sheets (13 sheets). If you scroll through the various pages in the...

Hi Just wondering how you go about passing a variable that has a value set within a procedure in the objects part of the project, to a userform. I can pass variables from the userform to the procedure okay, but not the other way around. I have tried declaring the variabe as Public (had to do...

Cheers. Approach 1 is much quicker for my files (due to their size). Thanks Anna

Hi Is there an easy way to open a .csv file, and write the information into Excel, without doing the File Import? I want to open a file that has an undetermined number of rows (changes each month), with 7 columns, and write each row into an exisiting Excel worksheet, column by column. Cheers...