Recent content by Warlocks

I've managed to sort it now thanks. I didn't want anything set on Workbook open but wanted to ensure it updated every 15 mins even if the server was rebooted for any reason. I therefore created a dummy Excel file which, on Workbook Open opened my main excel file and ran the macro as it if was...

Hi, I have a spreadsheet which has a macro in it that updates the spreadsheet. The update macro takes about 3 or 4 minutes to update and save the spreadsheet so I wanted to do the time consuming updates in the background (current thinking was on the server via scheduled tasks). As you can't...

Tell me about it... (your observation on the DATABASE task in a SPREADSHEET tool)... We are aware og this and the company is in the process of procuring a tool... The actual spreadsheet is a Resource Planner and the colours would indicate when someone is on leave etc. However, having the full...

Hi, I am trying to split an Excel file into 4 smaller chunks so that different people can update their own bit rather that a single person having to make all the changes. Therefore, I will still need a Summary Excel file that will collate the 4 different sheets. I can link the Cell data so that...

Hi, I am trying to add a FLASH object into a Powerpoint presentation programmatically. I can do it through powerpoint the application but I need to automate the process. I have searched the libraries within .NET (object viewer) but there is no reference to FLASH or SHOCKWAVE. Anyone done this...

Sean, Thanks anyway for the tip. We will do that... Woody.

Thanks for the info. I tried to use as you say the following connection string: Provider=SQLNCLI;Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; but then the message came back that it didn't recognise the provider. I therefore found a different one for SQLOLEDB and...

Hi, We have just migrated an application from SQL Server 2000 to SQL Server 2005 and are recording a load of errors as in the subject. Doing a search of the web reveals that this error is not descriptive in any sense, however, here are our specific details: No ASP code changes have been made...

Hi, This seems an odd problem. We have an ASP.NET AJAX UpdatePanel within a UserControl. The UpdatePanel contains a GridView control that binds to a given DataTable to do its work. In order to give the GridView a double-click selection mechanism; the leftmost column is actually created by a...

Hi, GUIDs are quite a unique datatype (if you pardon the pun!). Although they are Unique Identifiers, they are also represented as a string. This is why you are getting the error that you are. Convert the GUID to a string and insert that instead. This should work. Are you using Stored...

So it is. Thanks

Hi, I am wondering if there is a way to choose the fields I want to display in the Jobs area of SQL Server 2005 (in SQL Server Agent). On SQL 2000, you could se the jobs at a glance such as Enabled, Runnable, Scheduled etc but 2005 just has the name and Status. Cheers, Woody.

Hi, We are migrating from SQL 2000 to SQL 2005 and I have managed to import the old DTS packages into the new system. I wanted to make sure we could modify the packages and apparently SQL 2005 uses something called Business Intelligence Development Studio. This has now been installed but...

Thanks for the responses Paul. The second one was the utility I seemed to remember... just couldn't remember how to get to it!!! However, the first one has re-awoken the curious monster in me and I will delve deeper me thinks... Thanks again. Woody.

Hi, We have a very large database (around 13GB) and need to migrate it across to a new server. I know that there are a lot of tables in the DB that are redundant and therefore, to reduce size, I wanted to drop some of them. I seem to remember that I was able to (in Enterprise Manager) view the...