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...
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...
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...
Hi,
We are creating an application that we wish to use the impersonation items in .NET v2.0.
When creating the impersonation on a single page (using windowsidentity), this seems to be fine and the user changes.
However, when redirecting to another page, the windowsidentity.getcurrent() reverts...
Hi,
We have recently upgraded one of the servers from Windows 2000 to Windows 2003 Server and re-installed the SSL certificate for the site.
However, since then, certain users have had horrendous response times from the server whereby other users' response times are fine.
There seems to be no...
I am looking at building asp.net apps that contain the likes of javascript etc. But I am assuming I can alter the code by adding in javascript(s) in a similar fashion to VS.NET2003?
Also, I have looked at the MS site for the express site (thanks for that) but it doesn't indicate whether it is a...
Hi,
I have downloaded and installed V2.0 .NET framework and have read through the notes that came with it.
I admit I am a little rusty (not touched .NET for about 12 months) but when I open VS.NET 2003 and look for some of the new controls, I can't find them. One in particular is the Login...
Hi Jeff,
I am mainly interested in IE only (probably just for PCs).
The issue I have is that I need a page that displays different pages but that looks like it is all on a single page to have just a single scroll bar for the entire page and not an individual one for each iFrame.
I would...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.