Answer Questions

• Jay Shanker Multithreading, Callback & VBA in PowerPoint 2003

  Hi, I'm currently trying to get to work a VBA application which uses an external DLL (which I program parallely). The DLL starts a separate worker thread which calls a previously registered VBA callback function. This works perfectly (e.g. I can do a MsgBox "I was called with argument " + str(arg)) but if I try to change a slide in my slide show, PowerPoint says that "Hyperlink ^0" doesn't exist and crashes. At the end of ...Show All

• Curtis Gray Microsoft Access Chart Question

  I have a graph that i'm trying to display showing the history of a few fields. There are 2 tables: Person and PersonHistory... For each person there is 1..many records in person history... So the chart would show the trend of these fields in PersonHistory over time (week_ID is one of the records in personhistory...) I am putting the chart on form that will enable the person to select a person from a dropdown containing all of the rows in the pe ...Show All

• di96rtpn How to handle CLOB Data in VBA for Excel?

  Please, somebody, I need ASAP a solution to handle CLOB Data in VBA. I need to pick a String variable and insert and update it in a CLOB field. I need also, to store whatever is in the CLOB field in a string Variable. Does anyone know how to do it Thanks! per our support engineer: Would you please ask our ISV to check whether the document (below) can resolve the issue How To Use ADO GetChunk/Ap ...Show All

• Shelby Goerlitz Linking Outlook to Excel

  I would like to send an email via Outlook by clicking on a button in a Excel spreadsheet. The mail would contain some of the values in the spreadsheet. I think I know how to send with VBE an email given the server name but it does not go through Outlook. Thanks, Antonio Hi Antonio, Here is a line i wrote, which send an email with the file attached to it. x = the address you want ...Show All

• Tamilmannan transaction processing in an Access app?

  In an Access app, is there the concept of a transaction, with "start transaction", "commit", and "rollback" If so, how do I implement it in VBA My app will have a main form withfour subforms on it. It will also have a Save button and a Cancel button. I would like to start the transaction when the main form is loaded, and commit only when the user clicks the Save button. The Cancel button would trigger a rollback. ...Show All

• Midget01 VBA eBook

  Apparently, there was a free eBook on VBA available a short while ago. Can someone point me where to download it Thanks, Antonio http://msdn.microsoft.com/archive/default.asp url=/archive/en-us/office97/html/web/FULLTOC.asp It's for Office 97 but still worthwhile reading if your using a newer version. Derek, That is very helpful. Thank you again. I could not find for ...Show All

• tuny1 fm20.dll

  The thing is that I need to redistribute fm20.dll with my program which uses it my VisualBasic project. But since this dll ain't redistributable I'm in a little confusion. It is senseless to ask people that will use my program to have MicrosoftOffice installed... Then I read about Microsoft ActiveX Control Pad and thought that my problem was solved....but unfortunatly I couldn't find it using 'Search Microsoft.com'...So as I already said I'm in ...Show All

• AndrewMurdock NEW

  I WAN THE NEW MESSENGER BUT IT'S HARD TO DO this post is a little off-topic for this forum, but try this Messenger FAQ: http://support.microsoft.com/kb/316660/en-us -brenda (ISV Buddy Team) ...Show All

• Nitin Unni Excel Pivot Tables - Dynamically Changing Pivot Table Structure

  I have one pivot table which is associated to a Excel Range. I dynamically change the structure of the pivot table (eg Columns, Row, Data) to create different outputs. I used the following code to "empty" out the Pivot Table structure     With Sheets("Pivot").PivotTables("PivotTable1")         For intLoop = 1 To .PivotFields.Count          &nb ...Show All

• rdelgado Passing commands to unix from VBA EXCEL

  Can any one tell me how can i pass commands to unix from the VBA EXCEL programming Thanks in advance --KK Hello, This appears to be the information I am looking for but I'm struggling a bit. All I need to do is create in a VB Script is a call to a UNIX command. Basically I want to kick off a script in a UNIX environment and that's all. Is that feasible I see what you are saying about openi ...Show All

• Antonionini MS Office document and image writer print driver

  Besides removing this feature from Office during setup, is there a process to remove this virtual printer from 300 users with roaming profiles on an active directory network We are having an issue with this printer assuming the "default printer" selection for our users. As a work around we have changed their default printer, but after they reboot or log off / on it has defaulted back to the MS Ofc doc and image writer printer. ...Show All

• Cyril Porseland Is Partner program open for non-consulting/non-ISV companies?

  We're a company that is building a web based product to be offered as an online service. Our platform is all Microsoft based using the latest .Net technologies. My question is whether our company is suitable as a Microsoft Partner I'm having difficulty identifying the best Competency for us as a company. Any insights are most welcome. Regards, Neil Well, there is no "Silver partner level". Actually, there are 3 lev ...Show All

• Reagal passing data from a form to a module

  I have the following module Option Explicit Public Currency_Sold As String Sub AutoShape1_Click() UserForm1.Show Cells(10, 11) = Currency_Sold End Sub In UserForm1 I have Public Sub OK_Click() Currency_Sold = Currency_Sold_Code.Value MsgBox (Currency_Sold) Unload Me End Sub When I clik on the AutoShape1 button in the spreadsheet I do get the correct value of Currency_Sold in the MsgBox, but it i ...Show All

• Lorenzo Colautti VBA runs slowly in Excel 97

  I have a module attached to a button in Excel. The module deletes a number of cells, reads some data stored in a list on a separate sheet and writes some data back to the area deleted, based on criteria in some cells. First time I run it, it runs in seconds. If I run it again it takes minutes. Any ideas I'm thinking it might be due to Excel automatically refreshing or all its calculations on each of the cop ...Show All

• Maria Setting Chart Title through VBA sometimes works sometimes doesn't.

  Hello folks, Wonder if anyone has the solution to the following problem. Got an Excel addin that the user can use to generate Charts. The users are very lazy and want the addin to set the titles for the chart as well as for the axis. When I tested the code everything works fine and the charts including it's titles are set. Everyone is happy. However in certain spreadsheets the code throws an error. Method 'HasTitle' of object '_Chart ...Show All