Microsoft ISV

Page 46




  • Topics
    Replies
    Last post
  • Macro To Delete Spreadsheet Columns if no data in column
    by GB Allan
    8 Replies
    Last post by AussieJames
      • Hi, I need a routine that will go across and delete any columns in a spreadsheet that don't contain any data. The spreadsheet will always be from columns A:BB. There are column headings on row 1 going across. Thanks for your help - I very much appreciate this forum. It has helped me out greatly! Gary
  • Automate the Excel Camera Tool
    by jrc1378
    2 Replies
    Last post by jrc1378
      • I'm dashboarding with Excel and have everything finished except for programmatic placement of camera objects. Here's the gist: My dashboard selects an image to copy with the camera tool based on the results of various lookup and choose functions applied to data pulled from an ODBC query embedded in a worksheet. The Camera object is placed on a display worksheet so that the dashboard is noth
  • Once copied, can we export as a GIF file?
    by Perry Choy
    28 Replies
    Last post by Perry Choy
      • How to convert MS Excel to jpg or gif and paste/insert to MS Word thank you very much    
  • LBound and UBound functions
    by Keithyboy1
    7 Replies
    Last post by Shlizar Axis
      • Is there a reference library I need to enable in the VBE to get LBound and UBound functions They don't appear to exist in the Object Browser with the current reference libraries I have enabled. Many thanks!
  • Configuration Failed: Windows SharePoint Services 3.0 (Beta)
    by KevinTunis
    9 Replies
    Last post by lindi_xp
      • Downloaded SharePoint Services 1.I selected Basic Button ¡°install single server stand alone using default settings 2.Closed SharePoint Service Install and checked to start the configuration wizard. 3.Next I said yes to the popup message: The following services may have to be started or reset during configuration: Internet Information Services SharePoint Administration Services SharePoint Timer Ser
  • Excel 2003 CommandBarButton
    by RonBonBon
    4 Replies
    Last post by RonBonBon
      • Hi I have added a CommandBarButton to my excel workbook. My question is how can i make it load with my workbook (i mean when i open my file) Thank's. My code sample is: Dim cb As CommandBar Dim b As CommandBarButton Set cb = Application.CommandBars("Standard") Set b = cb.Controls.Add(msoControlButton, , , , True) b.Caption = "Hello" b.FaceId = 234 b.Style =
  • how to fit charts to eachother in excel
    by Jonas S.
    4 Replies
    Last post by Jonas S.
      • Hi all, I am creating charts inside VBA code and I wonder how I can make them be located directly under eachother. The first plot is located with : Charts.Add ActiveChart.Location = Worksheets("BUS").Range("D27") But how do I type the location for the other charts that will be created so they get the location under eachother I want it to be controled
  • Increase prompt in message box
    by une
    3 Replies
    Last post by Jon Peltier
      • I have a userform that contains a command button that when clicked displays a message box. This message box contains help notes for the user. However I can't quite fit all the text in. When displayed, the message box cuts off the last couple of sentences. I think this is because my help text is the prompt in the message box and it is too long (> 1024 characters). How can I get a few extra sente
  • Accessing USB/HID port
    by dbrother
    0 Replies
    Last post by dbrother
      • Hello all, Firstly, thanks in advance for any replies that will come this way. I appreciate the time you take to answer my questions. I need to access a USB port that has a camera attached for verification purposes. I have written programs that have accessed serial ports and network address before (for printers), but can't seem to find a solid answer or understaning to do the same fo
  • removing an object VBA
    by gilad_gy
    1 Replies
    Last post by Andy Pope
      • Hi, i'm having a trouble to remove a Object.... a few strange errors occurs.... My Code uses: Me.Controls.Remove "txt1_1" i'll be happy if you could help me with that... thanks gilad.
  • SmartArt macro
    by JAndreassen
    1 Replies
    Last post by JAndreassen
      • Is there any way to assign different macros to different sections of a SmartArt
  • "StackHash" crashes
    by Claus Brod
    3 Replies
    Last post by Jason Hardester - MSFT
      • Hi all, this is probably not the right place for this question, but I'm giving it a shot anyway, counting on the fact that we have experienced people here who crash applications for a living I recently noticed APPCRASH report data which specify something like "StackHash_1703" in the "faulting module" parameter of the Windows Error Reporting crash data. When this type of crash
  • Problem with converting numbers stored as text in excel.
    by Mr T
    12 Replies
    Last post by Mr T
      • Hi, I'm trying to make a macro that converts numbers that are stored in textformat for example "1.987,00 kr" to normal numbers so I can process them further. To accomplish this I am trying to replace the . with nothing. When doing this manually in excel it all works fine but when I let the macro do it for me I a get really wierd outcome. when doing it manually the above example tur
  • Run-time error '3000': Reserved error (-1038); There is no message for this error.
    by ADG
    1 Replies
    Last post by ADG
      • Hi all, New problem to me, the above error occurs on the seek method below. My PrimaryKey is correct. Cannot see the problem any ideas Private Sub btnBuildLastMoved_Click() Dim rsPart, rsLastM, rsSQL As DAO.Recordset Dim lngSI As Long Dim strSQL As String Set rsPart = CurrentDb().OpenRecordset("Part Table") Set rsLastM = CurrentDb().OpenRecordset("tbl Last Moved&quo
  • Random sort in Excel
    by MegamanSA
    1 Replies
    Last post by Peter Mo.
      • Hi I have asked this about four years ago and got sent the perfect code but have since lost it :-(. I have a list of items in the rows and prices in the columns, I have four different prices in col C,D,E,F. Eg. Item Code - Item Neme - Price 1 - Price 2 - Price 3 - Price4. Now I need to bubble sort columns C.D.E.&F so that it mixes up the prices in the columns without affecting the
  • variable types?
    by gr44gs
    1 Replies
    Last post by Andy Pope
      • My "File" variable returns exactly what I want, the problem is the Query doesn't reconize it. When I watch "File" this is the result "W:\Work\BFI\BFIResults\Copy2of05455100b\N1.BFI" I think it is the quotation marks because when I just type the path, without the "", it works the Macro uses many files within the certain directory so typing in the
  • How to read the value of a non-linked to a cell control from an Excel Sheet?
    by av197
    5 Replies
    Last post by av197
      • I am building a Visual Basic program that has to read an Excel SpreadSheet and get the values of unprotected cells as well as the values of any control (placed anywhere from the spreadsheet creator), use them somewhere else and vice versa, i.e. open a preconstructed Excel spreadsheet and place values in cells but also in the controls. I've found more than one ways to read and modify the cells. I'v
  • Excel Solver VBA Problem
    by cgufl
    10 Replies
    Last post by Redskin9
      • I have a problem with programming Excel solver using vba. I have the following micro in a workbook named "Book2.xls": Sub Macro1() ' ' Macro1 Macro ' Macro recorded 11/8/2005'     SolverOk SetCell:="$H$10", MaxMinVal:=2, ValueOf:="0", ByChange:="$G$10"     SolverAdd CellRef:="$G$10", Relation:=3, FormulaText:="$G$11"     SolverOk SetCell:="$H$10", MaxMi
  • how to stop mouse scroll to change records
    by darko4
    0 Replies
    Last post by darko4
      • I found a very cool way of solving this issue. You can make the mouse scroll change the record, but make it go back to it's previous record. This is the code: Private action As Integer Private Sub next_rec() On Error GoTo Err_next_rec DoCmd.GoToRecord , , acNext Exit_next_rec: Exit Sub Err_next_rec: MsgBox Err.Description Resume Exit_next_rec End Sub
  • Email Recipient Error Handling - Macro to create Black List
    by sree
    0 Replies
    Last post by sree
      • Hi All, Here is a small description of the situation. I used a smart mass mailer to send emails to around 20,000 recipients. And this mailer allowed me to direct mail bounces to my outlook mail box. And in Out look i have created a rule to filter and redirect all mails with this subject "abc", i used and having User unknown in its body to the Folder "XYZ".
  • Need help writting a script similar to...
    by jdwilliams543
    5 Replies
    Last post by Derek Smyth
      • Sub CommandButton2_Click Me.Textbox7.Text = My.Computer.Filesystem.ReadAllText("C:\info.txt") End Sub I'm a newbie at VB all around, thought that the My namespace was part of the VBA build. I have no clue how to write this kind of script in VBA. Basicall, I have a file (C:\info.txt) that I need to copy all of the info in this file into a textbox (textbox7 to be exact) on the form when
  • VBA Access 2003 - Insert a constant into db table
    by ajliaks
    1 Replies
    Last post by Van T. Dinh
      • Hi guys, I hope someone can help me with this VBA Access 2003/2007 question. I have oppened a new access file, and created a table named "myTable", with a field named "myFile". What I need is that every time the access file initiliazes (get open) the code write "hello" into a new record in the table myTable / myField. Thanks in advance for any help.
  • How can I see the stack trace from the .mdmp file? [CLR version]
    by Vedratna
    2 Replies
    Last post by Vedratna
      • Hi can any one tell me what to do I have also tried it from the very begining as described earlier in this post. After getting another fresh crashdump from WER I have opened it in windbg; gives me following verbose output: Microsoft (R) Windows Debugger Version 6.6.0007.5 Copyright (c) Microsoft Corporation. All rights reserved. Extracted D:\Users\proseon\AppData\Local\Temp\00000f680_min
  • Excel UserForm - TextBoxes - can't load data on open
    by suznal
    14 Replies
    Last post by Cringing Dragon
      • I have a UserForm that contains several textboxes used to display data from a worksheet. I want the data to load and be visible when the userform opens, currently I have to tab through the TextBoxes to get the values to show. I would like to know what event (I can't seem to find one) will load the data when the UserForm opens and require no user input to display. Sample code for the first th
  • Creating a named range using cells from another worksheet
    by Cowlers
    4 Replies
    Last post by Cowlers
      • Hello All, I have been trying to create a named range using a button in one worksheet to create the range in another worksheet but have been having some problems. Please find below my coding for this: ActiveWorkbook.Names.Add _ Name:="Users", _ RefersTo:=Worksheets("Data Sheet").Range(Cells(3, 4), Cells(e, 4)) Where variable 'e' has