Answer Questions

• Haarissh Introducing our newest forum!

  I'll actually let Michel, the host for this new forum, make the "official" introduction, but I just wanted to welcome you personally since I'm the one you normally see on the ISV forums. Our team was excited when presented with the opportunity to host this forum and I hope that you'll find it a valuable and informative resource. Happy New Year! -brenda and the MSDN / ISV Buddy Team ...Show All

• G4_Fighter Excel edit mode

  How can i detect "edit mode" in excel macros Thank's for idea(s) Hi Vlado, Here's the engineer's response... Thanks for letting me know your detailed concern. Your idea is quite cool. I understand that you want to make Excel not only a viewer, but also a full-blown database application. However, by design, Excel is not a full-blown database application. I seldom see partners use Excel as an updater of ...Show All

• TheTheTheTheTheThe Microsoft Business Scorecard Security

  Hello,   I have an anomaly on security report view in MBSM. In my cube I create two roles. First role has a full access and second role has Restricted access. When I create a report   view with using an admin user.    All the others users with a restricted access profit from its privileges. In the window of the "report view" it there is no tab   Administration or Safety contrary to the data sourc ...Show All

• EddiRae Progress Bar

  Hi all, I am using a macro in excel and i added a Form too. i added the form through the excel workarea code (insert ->form) i have 2 questions: 1. can i add a form from VB, is there any difference between a form from VB and a form from Excel VBA 2. i want to use a Progress Bar on the form. i found it but i dont know how to use it. any help thanks, S Disregard... I figured out that the ...Show All

• Curtis_more Output property to save as

  Hi people, I've been trying to generate a result from a MSXML used with Excel. When I apply the output property sampled below, it shows me a HTML into the message. Now I'm trying to display it right to a sheet or save it in a format xls, no results. Would anyone show me a way Else Set xslProc = xslt.createProcessor() xslProc.input = xmlDoc xslProc.transform MsgBox xslProc.output end if Marcos Hercules ...Show All

• morgandfgdfgdfgefdgdfgdftgdfgefd Does the VBA save word as XML???

  Hello! I'm really needing to know if there's any VBA code able to save a Word document as an XML doc. Any sample is appreciate. thanx Marcos Hercules dos Santos Hi Brenda, I'm trying to apply this macro you did, but in the line after "End With" it's been a sintax error. Would it be anything to include in references or troubles with the version I'm using Office2003. Hi Derek, I' g ...Show All

• meArun Program code fro sorting coloumns in a listbox VB Excel

  Hi I have in my UserForm a listbox, where I capture the A2:G10 in Spreadsheet1 And my problem is that I want to manage to click on the column header (in the listbox of the userform) to sort the coloumns. I hope that someone pls can help me sort this out! tullaolsen;)   Hi Derek and Wassim, Thank you for your help! I have now managed to get a sorting code for the commando button. Thank you both! The ...Show All

• PatrickSkelton run a macro in excel

  i would like a macro to run as soon as i open the worksheet that the macro is contained within any help would be appreciated Hi Tony Try using the worksheet activate event Private Sub Worksheet_Activate() Your code goes here End Sub Also consider if you want to perform your code just when the workbook opens, if so use the Workbook open event HTH ...Show All

• Vasso create a chart based on QueryTable

  i had QueryTable and i wanna create a chart based on it. i already assign each range with its name already (as a column name). next, i have to make a graph based on parameter choosen by the user. so first i'm gonna make user interface with checkbox of parameters, n the user should choose what are the parameters and then choose the X and Y value afterwards. is it a good idea to make such kind of concept in order to create a graph or ...Show All

• OOC# copy chart from excel to word

  The advance report currently made manually, make chart in excel, then copy it in word by hand, add adequate data, put it in nice layout, and print it. My project is to generate an advance report automatically, just push a few button, and the report is ready to be printed. My progress so far, I had a code to generate chart(s) and put it in new workbook .why not in the same workbook Because I want to separate the program and the result, s ...Show All

• tmichals Distributing a Macro across an organization - how to delete existing .bas files within a .dot file?

  I have been maintaining a large macro within my workplace.  It is basically a find and replace macro that let's the users easily create client documents.  It is housed within the Normal.dot template and contains a "MyName" module and "AcctMgr" module.  I have just completed an upgrade and I simply want to replace the "AcctMgr" module with a new one.  Replacing the whole Normal.dot file just causes too much pain for the person ...Show All

• NizarJalal Runtime error '13' - type mismatch problem! Again...

  Hey all Thanks to the help of the forums here i thought i had most of my code working however, this infamous 'runtime error 13' keeps cropping its head up on only 2 of my 10 sub routines! :( Ive spent most of my work day searching through forums and google but i am no closer to finding a solution. The 2 functions that it is affecting are important and i need to get them sorted else i may as well scrap my two days work! Ive posted the co ...Show All

• grainne foley Run-time error 3706:

  We have front end application which is developed in PB and resides on Citrix server. One of the module in PB application opens a screen which is developed in VBA. When we upgraded the citrix server and Ms Office on the server to higher version, the module which is developed in VBA is not working and gives the following error.   Run time error – 3706: Provider cannot be found it may not be properly installed.   Here is ...Show All

• Mihailik Provider cannot be found its not correctly installed

  Hi, I developed one application using VB6.0, datbase as SqlServer and Operating System is Windowsxp.that application i made as exe.when i was executing the application its properly running in those operating systems windows95/97/2000. But when iam executing another windowsxp system means iam getting the error like this. Error :3706 Provider not found its not installed properly can anybody help to slove this Hi, ...Show All

• Spetluri Compiling Excel VBA-code?

  Hi, I have developed an application in Excel 2002/XP to handle a spreadsheet.In order to make the execution faster I want to compile the VBA-code into mashinecode. The "Visual Basic Editor" in Excel can only find compiling errors, but not "compile". - Which "tool/s" do I need to compile code written in Excel 2002 and 2003 - Are there any free downloads so I can try out the technique before bying ...Show All