Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Mighty

    Sending Email from Scheduled Tasks

    Nothing in the event viewer Mighty
  2. Mighty

    Sending Email from Scheduled Tasks

    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
  3. Mighty

    Sending Email from Scheduled Tasks

    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...
  4. Mighty

    Updating Pivot tables in Excel

    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
  5. Mighty

    Updating Pivot tables in Excel

    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
  6. Mighty

    Updating Pivot tables in Excel

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

    Updating Pivot tables in Excel

    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...
  8. Mighty

    Updating Pivot tables in Excel

    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
  9. Mighty

    Updating Pivot tables in Excel

    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...
  10. Mighty

    Updating Pivot tables in Excel

    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...
  11. Mighty

    Updating Pivot tables in Excel

    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...
  12. Mighty

    Updating Pivot tables in Excel

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

    Updating Pivot tables in Excel

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

    Updating Pivot tables in Excel

    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
  15. Mighty

    Updating Pivot tables in Excel

    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...
  16. Mighty

    Setup Multi-Threaded ASP Application

    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...
  17. Mighty

    Lock Inputbox

    Is it easy to disable the keyboard? Mighty
  18. Mighty

    Lock Inputbox

    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...
  19. Mighty

    Get Remote Ip Address

    Did that in the end - thanks Mighty
  20. Mighty

    Get Remote Ip Address

    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...

Part and Inventory Search

Back
Top