-
- 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