Answer Questions

• Jfun Why Excel 2003 keeps PivotItems with zero record count after refresh?

  After a pivot table is refreshed, if some pivot item is no long exist in a pivot field, the pivot field drop selection still show that pivot item to allow user to select.  Selecting this kind of pivot item will lead to no data showing at all. This is no good. I perfer Excel will remove zero record count pivot item from the pivot field drop down selection box after a refresh. (I don't mind Excel keeping zero record count pivot item inte ...Show All

• DirkW deleting record

  Do Until rst_local.EOF CurrentLevel = rst_local("Level") CurrentDeptId = rst_local("DeptId") LevelUp1 = "L" & CurrentLevel - 1 & "_DEPTID" LevelUp2 = "L" & CurrentLevel - 2 & "_DEPTID" Set rst_pplops = dbs.OpenRecordset("SELECT " & LevelUp1 & "," & LevelUp2 & ",Dept_Level,EFF_STATUS,DeptI ...Show All

• alphanexxus Help On Error GoTo

  Hi Everyone, I`m creating a Workbook that protect and unprotect the sheets... The part of protect and unprotect is ok! But, the part of tratament of errors I don't get to do... I want that when the workbook show the error, it go to Erro: Thiago If you whish to continue your program, you you must put your error-routine before 'Next' Your err-routine can be something like this Regards, FiftyFive Erro: Select ...Show All

• tonyhinkle Using Built-In Constants in VB.net / Word

  I'm using vb.net to create a Word document (COM) and perform some simple operations on the docment , then close it. I have everything working except the use of built-in constants, such as wdFormatRTF. I keep getting compile errors cause they can't be found. Any help I've tried a sample out and couldn't replicate the problem, can you get this code to work. Dim x As New Microsoft.Office.Interop.Wor ...Show All

• elfw getting web pages from VBA?

  Dear VBA gurus, I would like to open and process a web page in a function in VBA version 6. (I am calling VBA from Excel 2000.) Thank you! Hey, Is this what you mean Sub CallWebPage() ActiveWorkbook.FollowHyperlink _ Address:=" http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=225018&SiteID=1 ", _ NewWindow:=True, _ AddHistory:=True Application.WindowState = xlNorm ...Show All

• LoneOakBill Newbie - Sending mail via Excel

  Hello everyone, Here's my problem : I'm trying to send a email via VBA in Excel using this code :     Set ol = CreateObject("outlook.application")     Set myItem = ol.CreateItem(olMailItem)     Set myAttachments = myItem.Attachments     myAttachments.Add "c:\SDE.xls"          With myItem        .Subject = "SDE"    ...Show All

• NewScience Excel macro to send email not running

  We have an excel macro that finishes with sending the file as an email. This is working on most people's PCs, but one of our users has Excel just hangs up during this process. We tried uninstalling any office programs, making sure the program files folder was empty and reinstalling the programs. We use Excel 2002 and Outlook 2003. This has worked in the past. I tried logging into my user's PC as myself and ran into the same issue. So ...Show All

• Bipin Agrawal Problem with VBA script

  Dear all, Can you please help me with the following problem I wrote a script to get the data out from the SQL Server and then format the cells. However, it seems it doesn't run the part B to format the cells. Any idea Thanks. 'Part A : Get the data from the SQL Server sqlstring ="select custid, custname from customer" connstring = "ODBC;UID=uid;PWD=p123;DATABASE=prod;DSN=HK0001" With ActiveSheet.QueryTables.Add( ...Show All

• aaronp What's your experience with the buddy program?

  Started by admin at 03-28-2005 5:11 PM. Topic has 2 replies. 03-28-2005, 5:11 PM admin Joined on 12-16-2004 Posts 14 What's your experience with the buddy program We've already received a couple of posts on buddy experiences (thank you!) and would love to see more of them, so feel free to jump in and reply to this post and share yours! Thanks, Brenda [msdn/isv] ...Show All

• GaneshParam Suppress Linked View Unique Record Popup

  Hi there im linking a view on an ms sql server to my access database using VBA using DoCmd.TransferDatabase acLink, etc.etc. How ever, I can NOT get the `Select Unique record Identifier` pop up to stop coming up when the link is being made. I dont care about needing a unique identifier, its a read only record source. The only way ive found is using sendkeys command to cancel the popup - however this can not be relied on, if it happens when the u ...Show All

• radhesh Autosave using VBA after n minutes

  Question: Using Excel 2002 SP2, I use VBA to drive a database of currently 15,000 records which automates a number of tasks such as letters, faxes, etc. Problem is, is that I don't know how to create an autosave function. I've integrated a save button instead but would like it to autosave after, say, 10 minutes. The only thing I can think of is to give the workbook shared access. I don't want to do that. Any assistance will be appreciated. Cheer ...Show All

• sorunsal Error with Data refreshing in the background?

  Hello, I have a spreadsheet with a lot of embedded queries pointing to SQL Server 2000. To update those queries in Query Builder, I would have to spend long hours doing that. So I decided to create a macro that is going to replace names of tables accordingly. But I am getting Run-time error 1004 saying that: "This operation cannot be done becuase the data is refreshing in the backrground. I am wondering if someone could help me to find a ...Show All

• fxtentacle Needed urgent to download Windows live messenger

  It have been offul to get a Beta Messenger 8.0 Y need this program. Please tell me how ando were can I have it. HI PLS HELP NEED TO DWNLOAD WLM 8.0 I know were to download it, www.ideas.live.com dont worry u dont need to thank me, u can get everything beta there. I need mto join MSN beta 8.1. I need ur help ...Show All

• shone xiao How to preserve the date format while reading Excel cell (Date) in to combobox?

  Hi, How can i display a range of date values from a sheet (A1:A200) in a combobox and preserve the format. When i set the RowSource property to A1:A200 in the combobox, and click on the dropdown arrow it displays the the date values in the correct format, but after i pick a certain value, it chnages it into a number. - Srini. Thanks for your reply. Could you please guide me on how to get th ...Show All

• AEC-JD outlook code modification

  the following code executes in the some machines..but it fails in some machines...please help and point out the line to be modified var app= new ActiveXObject("Outlook.Application") nameSpace = app.GetNamespace("Mapi") var AddLists = nameSpace.AddressLists var AddEntries = AddLists.Item(1).AddressEntries var AddEntry = AddEntries.GetFirst for(i=1;i<AddEntries.Count;i++) { alert(AddEntry.Address); ...Show All