Microsoft ISV

Page 14




  • Topics
    Replies
    Last post
  • Overflow (error 6)
    by une
    5 Replies
    Last post by Keithyboy1
      • I have code that executes fine 99% of the time. The other 1% I get an overflow error (error 6) that relates to the following line; startTime = Year(Now) * 365 * 24 * 3600 + Day(Now) * 24 * 3600 + Hour(Now) * 3600 + _ Minute(Now) * 60 + Second(Now) startTime is declared as a double; Dim startTime As Double The value of startTime at this line (according to debugger
  • Using VBA macro to locate next free column on worksheet
    by rabbitoh
    14 Replies
    Last post by magicalclick
      • I need a macro that locates the next free column (i.e. has no data in cells) and then places the cursor in a cell on a designated row. Would like search to start from column B and to place the cursor on row 4 on the free column. <> My VBA code thus far: Function NewColNumber(Range1 As Range) As Integer Dim j As Integer For j = 1 To Range1.Columns.
  • Disable toolbar button in macro
    by oryan_dunn
    2 Replies
    Last post by oryan_dunn
      • I have a macro that I want to disable after it is finished running. I would like to grey out the button on the toolbar. Is this possible If not, how would you recommend removing/disabling the button Thanks, Ryan
  • Active directory information from VBA
    by Sunder
    2 Replies
    Last post by Sunder
      • Hi, I would like to get the display name and other details of the user logged in from the active directory. Can this be done using VBA Thanks in advance.
  • Outputting histograms and graphs
    by une
    4 Replies
    Last post by une
      • Instead of outputting data in text from in a message box, I would like it to appear on screen as a histogram or graph in a window (message box ). Where should I start to get this done
  • VBA Macro created in Word Template not running when template is launched in Internet Explorer
    by S Prasad
    6 Replies
    Last post by S Prasad
      • Hello: I have a Word template that contains a VBA application. This application is launched through a macro and runs fine when I double click and open the template using MS Word. However, when I tried to open the same WORD template file in Internet Explorer (this is the final requirement), it fails to launch the application or run the macro. I am already using the following code in the ThisDoc
  • Dragin and dropin file names
    by Dougy
    2 Replies
    Last post by YaelS
      • Hello All I am relatively new to VBA and have a question that I cant seem to find an answer to on then net. Not sure if it is possible, but here goes anyway. I would like to drag and drop a file path\name from explorer into a text box in an excel form where the text box would then display the full path and file name. Thanks D
  • CRM 3.0 Outlook Client
    by keithpsft
    9 Replies
    Last post by DavidJennaway
      • I have a question regarding the settings necessary for the CRM 3.0 Outlook client to be installed. I have the CRM and Exchange on seperate servers & networks, both running SBS 2003. I have the CRM server setup as localhost in my office, and Exchange is hosted off-site. Whenever I open outlook I am getting errors saying: "Your Web browser options are currently set to disable cookies. Mi
  • Error 216 at 0001D61B
    by Dale Tonge
    2 Replies
    Last post by Cringing Dragon
      • I have a terminal server which has many software packages installed. All of the software packages work fine when you are sat infront of the server. However i have a problem with one application when i am connecting to the terminal server via microsofts remote access tool. What happens is when i try to connect via remote access and try and run the application they gat an error Error 2
  • Publishing BSM Scorecard programmatically
    by bayofbengal
    1 Replies
    Last post by MS ISV Buddy Team
      • Hello, I need to publish BSM Scorecards programmatically in a BSM Server. How, if possible, can I use the web service to do the same. Or is there any other way to do the same
  • SeriesCollection(i).Delete
    by chrisger
    3 Replies
    Last post by tronTech
      • Hi, I added some series to a chart and .seriescollection.count results = 6. That's OK. Now, series(6) references to empty cells. I want to delete the series but that's not possible. Err. 1004. Series with data can be deleted without problems. How can I access the series 6. Chris
  • AutoExec will not execute properly
    by J&amp;#252;rgen1234
    4 Replies
    Last post by Jurgen1234
      • Hello there I have an .dot file in the Word 2003 start-folder. When opening word, the file is read. The autoexec-macro should make a new entry with a number of commands and subcommands in the standard menubar. On about 300 PC's this works fine. On a few ones only part of the commands appear. All PC's run W2000 and Office 2003. Any idea regards Jurgen
  • Ways of sharing data between VBA and another non-dotnet application.
    by Aleksey Nagoga.
    4 Replies
    Last post by Aleksey Nagoga.
      • Hi All, I need to share some text data between VBA and another non-dotnet application. The solution needs to be easily deployable as both application are on the client side and need to be hidden from a naked eye, meaning that I can't just create a text file in one app and read it from the other. (sensitive material like passwords may occasionally be sent as well) I considered using shared me
  • Merry Christmas and Happy New Year
    by Derek Smyth
    3 Replies
    Last post by RhysDavies
      • This is the forum I've maybe spend the most time in, although not so much recently but that can't be helped. To everyone who posts here often enough to know my name, and to anyone else to happens to read this... have a great Christmas and New Year... and even if you don't celebrate them I hope you enjoy the holidays.
  • Unbale To Read File
    by Karthik Doss
    4 Replies
    Last post by Eyal
      • Hi , I am generating an Excel File using the " Response.ContentType = "application/vnd.ms-excel" after generating the excel file when i tried to open the excel it give me an error "Unable to read file "..... This particuclar error gets only for a case ...
  • Access 2003 Long Binary Data
    by vanduzee_t
    0 Replies
    Last post by vanduzee_t
      • In Access 2003, I have a table that contains a field of OLEObject. If I open the table, of course I see Long binary data displayed. I am trying to write some code that would allow me to take the entire table and fields and place them into an excel worksheet or in a form within Access and display the contents of the fieilds (recordset), but I do not know how to convert the long binary data to a
  • Run Time Error 9 when Calling a Userform
    by Joe Dawson
    6 Replies
    Last post by Joe Dawson
      • Hi folks, I am getting a run time error # 9 when I run a macro that calls a Userform or when I try to run code in a Userform module. The code performs beautifully on my computer, but it did not work on a coworker's computer. It ended up working on 3 out of the 5 computers I have tried it on. I have tried changing security settings to low, and a bunch of other stuff, but I cannot get the code to r
  • IEXPLORE.EXE - Application Error
    by Jaymie1989
    2 Replies
    Last post by MS ISV Buddy Team
      • Hi when I close Internet Explorer This error comes up "The Instruction at "0x7473c7d6" referenced momory at "0x00000032". The momory could not be "read". Click on OK to terminate the program". Could someone please tell me what that is please
  • Using all controls inside a frame, but in the right sequence.
    by My_Head_Hurts
    8 Replies
    Last post by My_Head_Hurts
      • I have created a form to present a user with a list of choices. These are determined externally, so I read a text file (one line per choice) and then use the text to populate the Caption attribute of an Option (radio button) control. I populate the option buttons in rows and then make the unused ones invisible, adjusting the height of the frame and form accordingly. This all works beautifully exce
  • Pass Shapes property names into module - Plz help
    by rexwrx
    4 Replies
    Last post by JoshZ
      • Hi all, Ok, i'm not an expert at all with programming, so please bear with me: This is a dashboard design. In my spreadsheet I have (example) 4 drawings (shapes) -> they are all arrows. I have a column called STATUS which basically has list of GREEN, AMBER, RED, which I can select. Whenever I select the GREEN/AMBER/RED, the drawing change from UP, DOWN or HORIZONTAL. Each arrows will have its o
  • pop up window
    by keilah
    0 Replies
    Last post by keilah
      • Hi Does any one know how to create a pop window with data in it from another worksheet........and the window can be refreshed on on the click of a button.......and close window button also the user must specify the range of data that is going to be displayed. regards
  • Highlight Row depending on truncated text - Excel VBA -
    by lyosha
    1 Replies
    Last post by sjoo
      • Is there a way to highlight a cell if it has truncated text like the cells that show #### Thanks in advance for your help! -Lyosha
  • VBA for MS Word 03 - Open Unicode data file and assigning text in Chinese to a variable to display in Word
    by mjasj
    1 Replies
    Last post by John Oliver (UK)MSP, VSIP
      • Several years again (actually, over ten, now) I developed a rather elaborate macro in WordBasic for reading Chinese characters from a text file, followed by their English meaning and some other particulars. This data was read and displayed as text in a Word document. At the time, one Chinese character was specified by means of two ANSI character codes, and various combinations of software and Chin
  • open adobe reader from within excel
    by tonycro
    1 Replies
    Last post by Shasur
      • Hello peeps, hope you can help me out here. We have a simple spreadsheet that we log memos and other similar documents in and with some code to open these documents in word - and we're looking to see if we can have something similar for opening drawings saved in a PDF format. Unfortunately the code was written by a chap who has moved on and I have absolute zero experience in this field The
  • Can't open regedit
    by Jebat
    14 Replies
    Last post by mtn
      • Hai.... Why if I want open regedit (run>regedit), and then show message error like that The application failed to initialize properly (0xc0000005) Please anybody help me... Jebat Thanks