-
- Beginner in VBA
by VBNewby
- 2 Replies
- Last post
by VBNewby
- I'm using a macro that runs before saving the workbook and allows the user to spell check each individual protected worksheet. How do I also allow the user to be able to format cells, format rows and insert rows while still doing what it is already doing Please see the code below that I am currently using...I can't figure out how to modify as stated above....
Private Sub Workbook_BeforeSav
-
- Calculate hieght
by YaelS
- 1 Replies
- Last post
by Bruno Yu - MSFT
- Hi,
This method change the hieght and Width of the sub form in the form calling in
form resize event.
I don't know what is 6615 parameter meens ctrl.height = fHight - 6615 + DEF_H
Code Snippet
Sub sub_forms_hieght(frm As Form) Dim FLeft As Long Dim FTop As Long Dim fHight As Long Dim FWidth As Long Dim ctrl As Control Const DEF_H = 3850 Const DEF_W = 7335
Call GetFormD
-
- MS EXCEL VBA Project password message
by PCNUT
- 1 Replies
- Last post
by Luiz Claudio - MVP
- Hello!
I am trying to write a macro for one of the worksheets in a workbook, and keep receiving a prompt for "VBAProject Password". I am not sure what that is as I did not set a password before.
Can anyone please provide some guidance.
Thank you
-
- Searching for a string value and copying the first row and colum entries.
by NeilNeil
- 3 Replies
- Last post
by AussieJames
- I have a spread sheet that gets data from a data logging software and puts it into my spread sheet. The first colum contains the name of the tags for the data ("On" or "Off"), the top row contains the time when the data was sampled. What I am trying to do is write a macro to search the data for "On" entries and if it finds a cell that contains "On" it will t
-
- TextBox height
by suznal
- 8 Replies
- Last post
by suznal
- Excel 2003 - TextBox
What would the code look like to have a text box maintain a specific width and a minimum height but increase in height as data is entered
-
- Outputting to a Listbox
by UniRyan
- 7 Replies
- Last post
by Andy Pope
- Hi;
I have a list of data, and need for values outside a lower and upper bound to be flagged up to the user. I was thinking of outputting to a listbox, but cant get the code to work. I was wondering if anyone had any ideas for possible code, or a better way of outputting to the user.
Ryan
-
- Are these valid bucket ids ?
by DHON
- 14 Replies
- Last post
by Claus Brod
- Hi Jason, Saar,
The reports at my end is having following bucket id : 456012092, 455976259, 455999458, 49984945. But these reports are not available in Winqual - atleast I can't see when I log in to Winqual. One of them is as old as 6 days. Others are one day.
Could you please, confirm whether these are all valid bucket id If not then reason.
Thanks,
DHON
-
- Local Folders - Inbox
by DivaMaggie
- 1 Replies
- Last post
by DivaMaggie
- In Outlook Express 6, under Local Folders - Inbox, I have a (1) and there is no actual mail. In other words if beside Inbox it says (5), there really are only four emails and the (1) always stays beside inbox. Was hoping maybe someone could help.
-
- Search & Replace macro, formatting characters
by Robin Haynes
- 0 Replies
- Last post
by Robin Haynes
- I am writing a (supposedly) simple macro with VBA to take a log file and slice it to create several smaller files to ease troubleshooting.
All my formatting and naming and path placement work beautifully.
But I'm spawning over 1000 handles to do so, which strikes me as odd.
The original file is local, as are all the created files. The original file is rather large, some 10MB for ~2000
-
- Automatic Updates
by rodcon
- 2 Replies
- Last post
by rodcon
- Using Office 2002. How do you have a master Excel spreadsheet update automatically from a separate, source Excel spreadsheet whenever the master document is opened
This is new to me; I hope I am not wasting people's time
Thank you,
Rodney Conroy
-
- LCS 2005 - Configuration and Archival facility
by Bikash Kali Maity
- 2 Replies
- Last post
by Bikash Kali Maity
- I have installed Live Communication server 2005 and SQL SERVER 2000SP3a. But I am unable to activate and create pool. Can you please tell me the steps how to activate and create domain/pool etc
Has LCS SERVER 2005 facility to archive all the communication between the users
-
- Corrupt CDs received
by RPKJBP
- 0 Replies
- Last post
by RPKJBP
- I joined Microsoft Empower ISV Program and received my first set of software last month. After installing the products one by one, I was stunned to see that few DVDs contain corrupt installation of Visual Studio 2005 Professional and SQL Server 2005. I guess what's the use of getting licensed software in this manner.
-
- Can you use VBA to access a spread sheet embedded in a word doc?
by Trisped
- 13 Replies
- Last post
by Trisped
- I am trying to use VBA code written in MSWord to access an embedded spread sheet. I can't find any documentation on how this is suppose to work. Does word access the sheet through an instance of excel Is the sheet part of the document so I can find it in the "ThisDocument " I have tried everything I can think of, so any help would be appreciated.
-
- Dusting up on VBA - Excel/Powerpoint
by Rockstar
- 2 Replies
- Last post
by Anonymous
- I have a few projects requirying knowledge of VBA for PPT and XLS - can anyone recommend any online guides to get me updated and back into VBA ...... tis been so long since I have touched this language!
Cheers
-
- Application.ScreenUpdating Problems
by SethEden
- 6 Replies
- Last post
by SethEden
- I've been developing this really massive VBA Excel Application as part of a government contract and it's gotten to be about 55,000 lines of code, optimized down from more than double that of course.
Everything seems to be working nearly perfect and I think I've even solved my problem with the call to Application.ScreenUpdating, but I'm not really sure why, and I couldn't find documentation
-
- Directss Install
by Edday
- 4 Replies
- Last post
by AzmathMoosa
- hey i have written a program in Excel using VBA and it used a module called DirectSS which is like the application.speak but is much more customisable (speed, tone, visual) which is why i used it. When i got home, i went to work on it and DirectSS isn't installed on my computer. I have googled quiet abit and found next to nothing on DirectSS. Does anyone here know how to install it or where to get
-
- Worksheet_Change event and dropdown list
by ADG
- 4 Replies
- Last post
by x_centric
- Hi all
In Excel I have a cell with validation set , (restricting input to values in a range), and a dropdown list for the user. When the user changes this cell by using the dropdown list it does not seem to trigger the worksheet change event. I want the change of cell to trigger an event to collect data relating to the selection. Any ideas why the drop does not trigger the event as expected
-
- seek for a file
by Bortch
- 1 Replies
- Last post
by ADG
- Hello I want to seek for a file in a directory from Visual Basic and to know if is opened or closed.
-
- Visual Studio 2005 and Sharepoint
by David M Barlow
- 0 Replies
- Last post
by David M Barlow
- Have just bought a new server with Windows 2003 R2, and Visual Web Developer 2005 for laptop. I have been learning and developing my app locally with local iis - no problem. Network dude says server is ready, and instead of good old fashioned IIS with FP server extensions, there is this strange sharepoint stuff!!!! If I try to create a new website from within VS2005, I get an error saying sharepoi
-
- What are the main parameters of my application on winqual account?
by Nikolai Bochkarev
- 2 Replies
- Last post
by Nikolai Bochkarev
- Hello!
I'm build my app with ver (for example 5.0.0.0), map my main .exe with Microsoft Product Feedback Mapping Tool and upload .xml file on WinQual account!
Do I need to repeat to map my .exe and upload .xml file after rebuild my appliaction (after some chage)
What are the main parameters of my application on winqual account - main parameters application of filtering crashes e
-
- opc
by ksona
- 14 Replies
- Last post
by MartinBrasil
- I am trying to develop an opc - da client using .net technology. Have gone through the documents on opc and opc client and all, but am still not sure how to implement it, can someone give me a direction on how to start with it
-
- WMI / Office2003 Critical Updates
by jslusher
- 0 Replies
- Last post
by jslusher
- An attempt to download and install critical updates for Office2033 failed (Error Code: 0x57E) on two separate events, once using the Automated Updates and once through the Windows Update Website. Also, I'm having a new and continuous issue with the WMI feature of my XP(SP2) Professional operating system. I am using a home network with three computers and a router to access the Internet. I've ran W
-
- Can't select option button in Access
by Keithyboy1
- 1 Replies
- Last post
by Keithyboy1
- I don't understand why Access has to be so temperamental and fiddly!!
I've got a simple option group, which contains two option buttons, with values of 1 and 2 respectively. On the Form_Load event of the form that contains the option group, the default value of the group is set to 1, per below:
Private Sub Form_Load()
fraReportInterval.DefaultValue = 1
End Sub
I then have an event
-
- Cannot Find Library
by HowDoIComeUpWithAUniqueName50
- 8 Replies
- Last post
by HowDoIComeUpWithAUniqueName50
- I developed an application in VBA for office 2003. I tested and sent it to a client. Works fine on my machine but compiling or running it on their machine give the error "Cannot Find Library". It then highlights the function LCase$. I tried using LCase$ in the immediate window and it gives me the same error. I open the object browser (F2) and browse VBA. The String library shows as does
-
- How could I count the last column in row 1?
by lyp_sj
- 5 Replies
- Last post
by Duane in Japan
- Hello,
I'm new for VBA, so I'm wonderring how I can count the # of column in row 1. Thanks so much for help!
B.regards/Yaping