Answer Questions

• kcdclan VBA Debug

  Newbie -- Access 2003. I have a form with several subs. I cannot seem to get the Debug feature to work with them. F8 (Step Into) does nothing, either with a beep sound or no sound. Note F8 does work with other modules that I have. ...Show All

• mattdawg Office 2003 and 2007 Primary Interop Assemblies (PIAs)

  Microsoft has an MSI for installing the Office 2003 PIA and a different MSI for installing the Office 2007 MSI. The web site says that the 2007 MSI is for Office 2007. Will it support 2003 VSTO routines Will it install with Office 2003 Will it provid a return code if it doesn't install Will VSTO routines written for Office 2003 work with Office 2007 with the 2003 Interop installed Will the 2003 Interop even install in an Office 2007 machine. Yes, we can set up virtual machines and spend hours figuring it out, but shouldn't Microsoft have thought of thi an published it in MSDN or, butter yet, put it on the site that has the MSI's Why not do it right and release an MSI that installs the right PIA regardless of which version of O ...Show All

• cmsesan1 Using Inputbox to detect a worksheet

  Never mind I solved it, see red marked for solution   Hello, I want to let the user add a serie to a chart. While doing so the usr will collect data using Inpubox from a different worksheet. He will need to go there three times to collect all data. I would therefore want the code to recognize on which worksheet the usr collected the first data set on and then when the usr has collected the x-values I want the macro to return to that sheet so the usr can collect the Y-values and finally return to collect the DataLabels. I have earlier here been tiped of Dim ws As Worksheet Set ws = ActiveSheet code... ws.Activate which has worked well earlier but now it lets me down. Can anyone help me with this Be ...Show All

• Joe Buys VB MACRO IN SHARED WORKBOOK(EXCEL)

  HI, PLEASE UPDATE ME HOW TO RUN VB MACROS IN SHARED EXCEL WORK BOOK THANKS, Aravinda Hi, I read the details you have put on the site and a few criteria’s do match to same query, but will put my case in detail below:- I have two excel sheets named "Input" and "backup". The "Input" sheet is an interface and the user has read-only access to it. All the VBA coding has been done in the “Input" sheet and the user will input data on various sheets and click on the save button. This button executes a code to open the password protected "Backup.xls" file which is a mirror copy of the Input sheet and will copy the data from the "input" file to the &q ...Show All

• skeezwiz Textbox won't keep new values after workbook closed

  Hello, I have this issue, I have a Textbox on a Userform that loads when a workbook is opened. If a user modifies the content of that textbox even if the workbook is saved the new values are not kept the next time that workbook is opened. How can I save the new values I would prefer not to store those values in a cell and then load them in the textbox each time the workbook is open. Is there another way Thanks the only other way is to save the data to file or to a database.... I posted an article on saving userform state that might be helpful here... http://dsmyth.blogspot.com/2006/05/saving-user-interface-state.html Or use custom document properties, see http://www.cpearson.com/excel/doc ...Show All

• osamaT Working with a DLL

  I have created a DLL in the vb.net 2003 classlibrary which exposes functions that I would like now to access from an Excel addin. If this is not extra-topical, how does one access or reference an external dll from Excel Thanks, Hi Does the thread "Using DLL file" on 23rd Nov on this Forum help ...Show All

• boston_sql92 Projects, objects & modules

  I started learning VBA in MS Word yesterday. I have some programming experience in C++ and Java. I am trying to understand how the environment is structured and what Projects, Objects and Modules represent. For example I recorded a few macros using the macro recorder and then opened the VB Editor to see what was created. I notice that under "Project" are 3 folders. One is named "Microsoft Word Objects". Within this folder is what looks like a file named "This Document". What does "Project" represent What does "This Document" represent What is the difference between "This Document" and the "Project&q ...Show All

• Dr.Virusi ComboBox: VBCode to select first item in the list.

  Hi I have the following VB code, when someone selects the worksheet name from the combo box in the summary page it takes them to the worksheet. However, the problem is that if they select, for example, worksheet "B" it takes them to the worksheet fine but when they are back in the summary worksheet the "B" is still selected in the combo box and you can not select "B" anymore. You have to select other worksheet name before you can select "B" again. Is there any way to instruct the combo box to always select the first item in the list Thanks in advance. Private Sub AFISGBox_Change() Dim strSheet As String If AFISGBox.ListIndex > -1 Then strSheet = AFISGBox Sheets(strSheet).Select End If E ...Show All

• renyx Run-time error

  Has anyone seen the following run-time error -2147467259 (80004005) Operation must use an updateable query I'm told we need the latest version of mdac installed in order to get past this error. We are using mdac 2.8 and I'm still getting this error message. Any help would be greatly appreciated! Thanks! Without seeing your code, it's impossible to know where this error is coming from. Have you considered making the switch to ADO or, at least, DAO ...Show All

• Pauly C Convert text file to a UTF-8 file

  Can anyone show the code to convert a text file to UTR-8 file but without the Unicode Byte Order Mark (BOM) . Thanks ...Show All

• JCakeC Check if an Excel workbook is opened and in use by somebody else

  Hi, I need to check if a workbook is opened and in use by someone else. workbooks.open does not return a trappable error Excellent, thank you, the second worked very well. Now the second problem is to find out who that "somebody else"-person on the network using the workbook is. I know this is returned in an errormessage when I try to open the workbook directly from Excel, but I cannot find out who the person is when opening from a VBA routine. How about the WriteReservedBy property of the workbook. May not work in networked situations. In which case may using some like this to get open files and username. http://vbnet.mvps.org/index.html code/network/netfileenum.htm Hi, Have at a lo ...Show All

• thechristopher Creating data with a loop based on current info in worksheet

  I have an excel file (.xls) that already has data in it. I have already got my VB app to open the source XML file and change it to a XLS file and delete the top row (blank and not needed) and add a new column in for my new data. The new column needs to have data that will loop down until the other rows have no info. The naming will be generated based on a number. vp0001.jpg vp0002.jpg vp0003.jpg vp0004.jpg and so on until it comes to the last row. This data will be put into column A and it will check column B for the last row. Thanks! that worked like magic! thanks Hello Dustinto, There are many experienced and learned people using this form and (I'm not one of them). But you have not really explained your problem in any d ...Show All

• redneon Excel Chart: How to change chart data source formula when object "Series.Formula" is too short?

  How to change chart data source when Formula object is too short I know that: I can assign data source 1) Series.Values=Range(...) - suitable 2) Chart.SetSourceData souce:=range(...)... - suitable 3) Series.Formula/FormulaLocal="" - not suitable because string is too short I can read data source 1) x = Series.Formula/FormulaLocal - not suitable because string is too short The question is: How to read data source not using Formula object What can you say about this What I will say is with Excel, if you get the data right in the first place, you will save hours of aggravation. Charts were designed to accept a row or column of X values, and a row or colum ...Show All

• Ather. Refreshing table list in Access

  I have an Access 97 database that uses a large number of temporary tables. To save space my code creates the temporary tables in a new temporary database, and then I link the tables to the original database. Once I have finished with the tables I delete them with SQL e.g. strSQL = "DROP TABLE [tblICIMIndex];" DoCmd.RunSQL (strSQL) Then I delete the temporary database, this gets around the problem of not being able to compress on close the Access 97 db. However, the table list still shows the tables that I had linked until I click on one of the deleted tables. I have tried to refresh the list with the below line of code, but this does not work: CurrentDb().TableDefs.Refresh Any ideas how I can force the refresh o ...Show All

• naicul Updating text in a text box on an Excel Graph

  I am automating a spreadsheet, designed by someone else, which has 18 graphs on a worksheet. Most of these graphs have a text box on them which indicates the week commencing that the graph refers to. The text box appears to be a shape object on the chart. I want to loop through each chart on the sheet, then loop through each shape on the chart, and change the text if the shape is a text box. Can anyone put me on the right track, I did try using the macro recorder to get me started but this code does not work in my VBA module. Hi Thanks for the post, the text I want to update is a text box which the user has placed on the charts. It appears to be a shape object. The code that I had from macro rec ...Show All