Search results for query: *

Nothing in the event viewer Mighty

Thanks for the response Unfortunately I have quite a number of script programs and some of them are very complex so changing to Powershell would be a big job Everything works fine apart from the email issue. Any other suggestions? Mighty

Hi All, I am currently using a Windows 2003 server to send out reports and perform other tasks. These are primarily VBscript programs which I am executing using wscript and are all setup as scheduled tasks. These have been working away fine for years. However, as Windows Server 2003 is now end...

Hi Skip, A combination of names ranges and your first post in relation to refreshing the pivot caches has appeared to work. Thanks for all the advice. Nick Mighty

Skip, Can you advise how to update a named range in VBScript. I had tried to do this but couldn't get it to work Nick Mighty

When I run on server running Excel 2003, it tells me that it doesn't support the Pivotcaches.Create method Mighty

The query is not in the excel file. I run the query in the VBScript program and loop through the query in the VBScript program and write it to the excel file. In relation to the Excel file, I have hit another glitch. The code above works fine when I run it on my machine (Excel 2007) but not...

Apologies Skip. This is an Excel template file that I was given and asked to populate automatically. I run a query which adds data to this table and then attempts to reset the bounds of the pivot table data based on the new rows that have been added Mighty

Hi Skip, I changed the code to the following and it appears to be working: For Each ws In orderFile.Worksheets For Each pt In ws.PivotTables pt.ChangePivotCache orderFile.PivotCaches.Create(1, "'Work Order Detail'!R3C1:R500C24", 2) Next Next The red section above would then...

Hi skip, Spotted that and changed it and now have a different error: The PivotTable field name is not valid. To create a PivotTable, you must use data that is organized as a list with labeled columns. If you are changing the name of a PivotTable field, you must type a new name for the field...

Hi Skip, Updated my code to the following: For Each ws In orderFile.Worksheets For Each pt In ws.PivotTables pt.ChangePivotCache orderFile.PivotCaches.Create(0, orderFile.Worksheets("Work Order Detail").Cells(3, 1).CurrentRegion, 2) Next Next Get the following error message...

Hi Combo, So what would be the destination - is it the first cell of the pivot table? Mighty

Hi Ship, That is obvously not VBScript syntax so I tried changing it and could not get it to work Nick Mighty

Hi Skip Thanks for the suggestion. Unfortunately I can't just do a straight refresh as the number of rows in the source data changes so I need to specify the new data source Mighty

Hi All, i have to admit that it is a long time since I have been on Tek-tips - used to be a regular user but just getting back into development now after an absence and I am having a problem. I have severl VBScript programs that I am using to update Excel files regularly. Some of these Excel...

Hi All, I am having a performance issue on my IIS server (IIS 6 on Windows Server 2003). I am running two ASP applications - each with their own application pool. Both sites are Intranet based applications and are in heavy demand. I need to be able to introduce some form of load balancing as...

Is it easy to disable the keyboard? Mighty

Hi All, I have a simple script which uses an inputbox to prompt the user for a lot number. The inputbox is populated using a barcode scanner when they scan a barcode on their documentation. What I want to do is prevent them from changing that scanned value or manually entering one. Can you...

Did that in the end - thanks Mighty

I am having an issue on a few pages. I have an intranet site where I only want to allow pages to load if the person accessing the site is on the internal network. So I am using the REMOTE_ADDR servervariables value to get the IP. The problem is that if I access the site from an external...