Search Results

Search found 27973 results on 1119 pages for 'power point vba'.

Page 10/1119 | < Previous Page | 6 7 8 9 10 11 12 13 14 15 16 17  | Next Page >

• VBA: Read file from clipboard

  - by ReturningTarzan

  I'm trying to load a file in a VBA macro that has been copied from, say, an Explorer window. I can easily get the data from the clipboard using DataObject::GetFromClipboard, but the VBA interface to DataObject doesn't seem to have methods for working with any other formats than plain text. There are only GetText and SetText methods. If I can't get a file stream directly from the DataObject, the filename(s) would also do, so maybe GetText could be forced to return the name of a file placed on the clipboard? There is very little documentation to be found for VBA anywhere. :( Maybe someone could point me to an API wrapper class for VBA that has this sort of functionality?

  Read the article

• intellisense functionality in a custom VBA function?

  - by PowerUser

  In the standard IDE for VBA, intellisense is built-in to the standard VBA functions. Can I achieve the same for my custom VBA functions? i.e. can i write something like: Public Function DoSomething(X as string)(Options X="Option1","Option2") as variant

  Read the article

• How to import multiple vCard VCF contact files into Outlook 2007 using VBA

  - by ydfeed

  How to import multiple vCard VCF contact files into Outlook 2007 using VBA

  Read the article

• Spreadsheet component with VBA support

  - by Renaud Bompuis

  I am looking for a .Net spreadsheet component that could also execute the VBA contained in Excel files. I found Spreadsheet Gears to be very nice for manipulating and allowing the user to edit Excel files, but on spreadsheets that use VBA for calculations, well, these don't work. So, apart from Excel itself, are there any other components that can execute VBA?

  Read the article

• C++/CLI com-Interop: Exposing a reference type property to VBA

  - by Adam

  After long hours of investigation on exposing C# property that accepts a reference type to VBA, I concluded that it was not possible. In brief, a C# property that is of type double[] or even an object cannot be consumed in VBA like this: ' Compile Error: Function or interface marked as restricted, ' or the function uses an Automation type not supported in Visual Basic oComExposedEarlyBinding.ObjectArray = VBArray ' Run-time error 424: Object required oComExposedEarlyBinding.PlainObject = VBArray Or for more details: C# property exposed to VBA (COM) : Run-time error '424': Object required I would like to know if C++/CLI would support such an option? i.e. Allowing a reference-type property to be exposed to VBA so that a syntax like the above is valid. N.B. You can achieve this by using late binding, but losing the intellisense is not an option.

  Read the article

• Programatically rebuild .exd-files when loading VBA

  - by aspartame

  Hi, After updating Microsoft Office 2007 to Office 2010 some custom VBA scripts embedded in our software failed to compile with the following error message: Object library invalid or contains references to object definitions that could not be found. As far as I know, this error is a result of a security update from Microsoft (Microsoft Security Advisory 960715). When adding ActiveX-controls to VBA scripts, information about the controls are stored in cache files on the local hard drive (.exd-files). The security update modified some of these controls, but the .exd-files were not automatically updated. When the VBA scripts try to load the old versions of the controls stored in the cached files, the error occurs. These cache-files must be removed from the hard drive in order for the controls to load successfully (which will create new, updated .exd-files automatically). What I would like to do is to programatically (using Visual C++) remove the outdated .exd-files when our software loads. When opening a VBA project using CApcProject::ApcProject.Open I set the following flag:axProjectThrowAwayCompiledState. TestHR(ApcProject.Open(pHost, (MSAPC::AxProjectFlag) (MSAPC::axProjectNormal | MSAPC::axProjectThrowAwayCompiledState))); According to the documentation, this flag should cause the VBA project to be recompiled and the temporary files to be deleted and rebuilt. I've also tried to update the checksum of the host application type library which should have the same effect. However none of these fixes seem to do the job and I'm running out of ideas. Help is very much appreciated!

  Read the article

• vba variations across office suite

  - by every_answer_gets_a_point

  what kind of functionality variation is there across vba for excel vs vba for access vs vba for word, etc.. i know that probably 95% it's the same. but what is that 5% of differences consistent of?

  Read the article

• gnome-power-manager is running while trying to log in. How to get rid of it?

  - by koushik

  After booting into the ubuntu login screen and clicking on my user name and entering the password, I get a dialog stating that gnome-power-manager is still running. The dialog presents 2 buttons, 1 to Cancel and other to Logout Anyway. This issue happens about 50% of the time and I don't remember doing anything related to power management recently. Also, even if I don't choose any option in the dialog it goes away after about 30s. This is happening on a desktop machine as well as a laptop. On the laptop I have configured power management for myself (not for gdm) whereas in desktop I have not configured power management for any user. This is only an annoyance but still I would like to fix it, especially on my desktop where I am interested in getting it auto-login ASAP into my userid. Any ideas why this could be happenning?

  Read the article

• Windows 7 power management in Boot Camp mode

  - by qntmfred

  I have a Macbook Pro with Windows 7 installed in Boot Camp. I have serious problems with the power management and not sure why. I have the default Balanced power plan selected. Many times when I close the laptop and leave it for more than just a few minutes, when I open it back up, it does not awake immediately. I end up having to press the power button to get it to wake up. Sometimes this causes it to wake up in Windows mode, sometimes it reboots completely, sometimes the battery has been drained and Windows has to restart. Is this a common problem? Can I fix it?

  Read the article

• What is the best position for power unit?

  - by guest86

  I would like to buy new computer case. Last time I bought a computer was in 2008 and many things have changed up to day. Many new computer cases have power unit placed down, on bottom. I'm thinking about buying some of those cases, but i'm not sure about something - if power unit is placed on the bottom it can't take away hot air from the case and pump it out right? All my PC parts are silent - CPU (E8200, placed below 12cm Nochtua fan of power unit) has heat-pipe cooler with Nochtua fan spinning at only 800rpms, GPU has cooler powered by 7V instead 12 and that's why i don't want to HAVE TO place another fan to pump out hot air instead of PU placed on top. That might make some noise. So i ask someone more experienced: if i buy some computer case with PU placed down, do i HAVE TO place some fan to pump out hot air?

  Read the article

• Windows 7 USB power lose after a few seconds / minutes

  - by Stefan Dunn

  My friend's computer has a problem where the USB ports causes problems with the power of some devices connected to the computer. The USB mouse has no problems, however the Wireless Adapter looses power after around 20 seconds of use and USB Flash Drives cause the computer to either freeze, lose power (and become unresponsive) or become disconnected (still shown in Device Manager, but not in My Computer) when trying to transfer any type of file to / from the computer. I have a suspicion it's the Motherboard but could it also be a Software problem? Tried a new case, RAM, CPU and GFX Card which had no effect. The problem occurs on both the Front USB and Back (Motherboard) USB Ports. UPDATE: Tried the USB devices with an Ubuntu Live CD and they work fine, could this mean it's a problem with Windows (x64)?

  Read the article

• Connecting mother board, power supply, and tower

  - by JordanD

  I am working on putting together a desktop for the first time and and ran into a problem, I am not sure how to connect the fans that came in my tower, my power supply, and connect them all to the mother board. Tower Mobo Power Supply There are 3 fans in the tower, each have 3 pin male and female connector that come connected, and 4 pin (larger?) male and female connector which are hanging. How would I go about connecting The fans together then to the power supply and mobo so it is easiest control (or suggest me a smart / better option). Pictures are from fans on HAF 922 Tower. Thanks

  Read the article

• How to disable power to USB ports when laptop is in sleep mode

  - by Greg

  I have a Windows7 laptop with two external 2.5" HDDs and a cooling pad connected through USB ports. When I put the laptop to sleep, these devices are still powered on - the fan in the cooling pad is still spinning, the drives are still spinning. I want to set it all up so that they power down when in sleep. I tried setting the Allow the computer to turn off this device to save power option in the USB Root Hubs' Properties in Device Manager and enabling USB selective suspend in power options - it didn't work. As it's a laptop, BIOS options are extremely locked down, so I can't even see anything relevant to sleep in there. Is it even possible to do this?

  Read the article

• Computer randomly shuts down with a fading alarm power button and CD drive

  - by Shad

  I am currently experiencing something very very odd. Having build my PC myself, I have never had any issues (or anything heat related). A few moments ago my computer shut down very randomly and everything goes blank, when I looked down on my case's power button it was fading on and off in such way I've had never seen before. I noticed the CD drive all of a sudden also started blinking randomly. What do you guys think this problem is related to? It is definitely not a overheating issue and I am pretty sure my 600 watt power supply didn't blow because right now I am able to turn it on and boot up the PC but 20 seconds later it shuts down (sometimes doesn't shut down for 2 minutes). I have no idea what this is... My specs are (built by myself): i5 3570k (unoverclocked) GTX 560ti Asrock Z77 Pro4-M motherboard 8GB Vengeance RAM 600W Corsair power supply 500GB of Seagate HD Case: Corsair Carbide 300R

  Read the article

• Is the 4-pin PSU connector required? (Trying to connect a PSU to a mini case.)

  - by Geeks On Hugs

  I am trying to build a computer, placing an ASUS P8H67-I DELUXE in a custom retro C64 case. The case is an extra small form factor which can accomodate the Mini ITX board, but requires an external power supply, similar to the power-bricks that laptops use. I am looking at different power supplies and like these, but cannot figure out whether/how to power this system because they provide a 24-pin connector, but the motherboard has a 4-pin connector as well. Is the 4-pin connector optional or is it required? If it is required, how can I provide power for this system?

  Read the article

• Dell Latitude E6400 power button and wireless not working or only working intermittently

  - by Droid

  The power button on the laptop stopped working randomly as of a day or two ago. I can only power the laptop on if its attached to a docking station, on which I can use the power button to turn on/off the laptop. Today the wireless card stopped working (the wifi light does not turn on, even after I turn on the wireless switch). What is the problem and how can I fix it? The laptop is about 1 year old. I have not dropped it, but do carry it around a good amount, including docking it/undocking it frequently.

  Read the article

• PC doesn't power up anymore

  - by Andrew

  I will tell you the story behind the problem. The computer needed to be reinstalled, it has 2 HDDs so I had to un-plug one to see which is which, to save as much data as possible. After unplugging the first one, it booted with the reinstallation CD, it wasn't the HDD I was looking for so I turned it off and unplugged the other one. After unplugging and turning on, right after booting test, the HDD was turned off, only the CPU fan was working. Turned it off with the power supply's button help, holding the power button didn't do it. And now it doesn't want to turn on anymore. I tried with another test power supply but the result is the same, doesn't want to turn on. Any idea?

  Read the article

• Computer has power but won't boot

  - by John Isaacks

  When I power on my computer it will not boot. It will not even go into bios or anything. It is as if it is not powering on at all, however the decorative casing lights turn on and the PC is making noise (like from the fans). I am reluctant to think it is the power supply since some part are getting power. I do not know what it is though? For the couple days leading up to this, the computer would make a loud noise and the screen would stop displaying anything. I had to reboot to get it to work again. Now nothing happens when I boot, except the case lights come on and it sounds like some fans are coming on. Any ideas?

  Read the article

• Who does non-decimal bignums with floating radix point?

  - by boost

  Nice as the Tcl libraries math::bignum and math::bigfloat are, the middle ground between the two needs to be addressed. Namely, bignums which are in different radices and have a radix point. At present math::bignum only handles integers (afaict) and math::bigfloat won't let you specify different radices to math::bigfloat::fromstr (ditto). Does anyone know of a library, for any of the major scripting languages (e.g. Tcl, Perl, Python, Ruby, Lua) or less major ones (newLISP for example), which implements bignums in different radices with handling for radix point?

  Read the article

• Using Excel VBA to capture standard toolbar use

  - by vwankerl

  I am looking for a way to capture a click on a standard toolbar tool in Excel with VBA. The primary need is to capture any Copy, Cut, and Paste request by the user. I can capture the hot keys for these functions, but I can't find a way to capture the same functions when the user clicks on the icon on the standard toolbar or when the user uses the menu to select the function.

  Read the article

• Populating Specific Cells Using VBA

  - by Daniel

  I am using VBA to pull from a SQL table and it automatically populates cell E14. Not sure why it's that cell, but is there a way to specify which cell it pulls the data into? Here's what I have right now: strSQL = "SELECT distinct Source FROM dbo.Simulations WHERE SimulationID = 5

  Read the article

• Remove password on Excel 2007 VBA project

  - by MJ

  Is there an application that can remove the password on an Excel 2007 VBA project? Or is this something that I can fix within the program itself?

  Read the article

• Retrive selected group of field from Access table using VBA

  - by karthik

  Hi i am using VBA to connect access db to excel. i want to select the specified group by default.How to i select the specified Group Fields in the table i am not sure about the that field names it is possible to do this ? thanks in advance

  Read the article

• Power states in Windows

  - by Kurt

  Does anybody know or have a link to documentation on how the Power Manager of Windows, determines to go to the ACPI power states S1-S4? Are there any settings that can be configured? I know that by default states S1-S3 are disabled in Vista and later (they can be enabled by a group policy). Can Windows cycle through these states while for instance an application is actively running?

  Read the article

• Intel atom and overall power consumption

  - by amorfis

  I am considering buying of Intel Atom machine. Power consumption is one of my concerns (it is for small server). I know CPU itself consumes a little power, but I heard that chipset consumes much more. Anybody knows how much can such machine consume? I am considering Intel MoBo BLKD945GCLF (chipset: Intel® 945GC Express Chipset with ICH7)

  Read the article

< Previous Page | 6 7 8 9 10 11 12 13 14 15 16 17  | Next Page >