Answer Questions

• Felixredwoody Spreadsheet 'call' from VBA function macro

  I'm familiar with the usual application of VBA function macros - pass arguments from the spreadsheet to a function, the function then returning a value to the spreadsheet. Is it possible to do this in reverse Can a function macro pass arguments to a spreadsheet, with the results of the spreadsheet calculation passed back to the function The job I'm trying to avoid is reprogramming an existing spreadsheet as a VBA function, in an effort ...Show All

• ssmile73 MS Access key problem

  I'm doing a little work for a lawyer that has an Access VBA system to handle billing and printing of some legal documents. I am not an Access VBA expert; I'm a C++ expert who has picked up a few Access skills. When his secretary adds a new client, she has to pick a record key, which they call MGMT_CODE. It is a four-character text field. Most of the existing MGMT_CODEs start with 0 and consist of four numbers. Some of them start with 9, though, ...Show All

• VB.IS.NOT.PYTHON Products Roadmaps

  I wonder if MSF does help to create, or at least to follow, a product roadmap... Or what is the best way to create a software product roadmap Ximena Per the product team: Yes, MSF v4.0 provides clear guidance on creating a vision statement for a product and planning a series of releases of that product based on prioritized functionality described in usage scenarios written around a set of persona ...Show All

• philfishing Problem about the "Find" function in VBA editor

  Hi all~ When I use "Ctrl F" or choose "Find" in VBA editor, the "Find" pop-up window close and do nothing after I press the "Find Next" button Can anyone help me I use MS Office 2003 and the VBA editor version is 6.3 Thanks! Please~Please help me!!!!! Per the support engineer: Would you please ask out ISV to check the ...Show All

• vpopadic Read data from excel through VB.NET

  Hi friends, I need to read symbols(like ALPHA,BETA,MEU) from excel and show it in a data grid through VB.NET.Later insert it into Oracle 8i DB. I am able to read entire data but i am getting 'a' instead of ALPHA symbol and 'b' instead of BETA symbol. I am querying excel via OLEDB provider.The following snippet is using for accessing excel. Dim MyCommand As System.Data.OleDb.OleDbDataAdapter Dim MyConnection As System.Data.OleDb.OleDbConnection ...Show All

• HonzaHornik vlookup on unions

  I have two ranges on a sheet; rngOne and rngTwo, they both contain 2 columns and 5 rows of random numbers I want to run a vlookup in VBA on the union of the two ranges so I run the following code:   Sub test()     Dim a As Range, b As Range, c As Range, d As Range     Set a = Range("rngOne")     Set b = Range("rngTwo")     Debug.Print Application.VLookup(0.52011206 ...Show All

• BENHILL saving exel data

  i like to make a program  in visual basic where  at first i will open a exel file.then in a WORKsheet i will include some data and then it will save as a ms access(as a mdb file)all will happen in my program..then i will can do some quaries in access and open it in my program as a .mdb file. kindly help me. per the support engineer: Please clarify the requirements: Please let us know the version of Vi ...Show All

• Parthenan Need VB6 Code to direct sound waves to computer speaker

  Hi Pros, I need VB6 code to direct WAV and other sound files to the computer speaker. I do not have a problem directing them to msplayer.exe, but can't figure out how to get them to the computer speaker. I don't even know if this is possible. Would appreciate any response, please email me and let me know you have posted, or send the post directly. Thanks for any help. Hugh Hi Hugh, You have indicated that ...Show All

• som How to change the DisplayAlert Response?

  Hello all, I have a program that use Application.DisplayAlert = false, then save in the same workbook. The DisplayAlert will not show the dialog which asking to overwrite the workbook. When the code has run, the default value is chosen to Cancel. Then, the workbook cannot be overwritten. Is there any ways to change the Default Response to Yes in VBA, so i can save the workbook in Excel 97, 2000 and 2003 by using Application.Display ...Show All

• Dotnetjunky Automation to send a Microsoft Outlook message using Access 2000

  I'm trying to send an email from my Access 2003 database, using MS Outlook. The users must have the ability to attach a file that resides on the network share drive. I have a field that holds the path to the existing file. Please Help!!! Everything out there is referencing libraries that I do not have. I'm currently referencing Microsoft outlook 11.0 Object Library. Per our support engineer: Base my unders ...Show All

• Michael K. Barnett Save Each page of a Word merge as a seperated pdf file

  I have a word merge, and I need to save each page as a seperate pdf file. I would think i could do something like a for each page in document.pages and then use the Contact field in the doc to save the file, I have never worked with word vba so my excel experiance doesnt seem to translate as well as i thought it would Thanks All Per our support engineer: We must insert a page break in the word doc to identify the page ...Show All

• devlindark Excel, Forms, and Charts

  I am pretty much a beginner when it comes to VB. I need help with a project I am working on that has me ready to rip my hair out. Here is the what I need to do: When I open a workbook (excel) I want it to display a form where I can enter in the date and various data. I need that form to add that data that I entered to the worksheet in the coloumn that corrisponds with that particular information. It also needs to copy that row's for ...Show All

• Rafael Morales To download Messenger 8.0

  hi hi yo dawgs... i no how to download 8.0... yea dudes thats right.. #1) you go to this page: http://www.ideas.live.com/ #2) You sign into the ideas production site: http://login.passport.net/uilogin.srf lc=4105&id=67118 OR when you get into the first page, you will see "Beta users sign in here". Press, put in your email address and where you are living in now (country). #3) After your're done that, scroll down until you can see the lit ...Show All

• nagajim 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

• raagz Custom file description keywords: read/write in VBA via API

  In Windows Explorer, I can select a file, go to properties, and under 'summary', I can input keywords into the description, for use later when searching for the file. I would like to be able to read/write these file keywords via VBA. I assume I need to access the Windows API, but more than that, not sure what library etc. I would need to use. Can anyone advise me how do to this            & ...Show All