-
- 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
-
- Action Pack Question
by Tone Southerland
- 12 Replies
- Last post
by Mark.Rowe
- I am interested in the Action Pack. I understand that it comes with the Vista upgrade, not the full edition. I do not have 10 licensed copies of XP Pro to upgrade from. So does that mean I will need to purchase a licensed copy of XP Pro for each machine that I want to put the Action Pack upgrade version of Vista on
-
- .mdmp files not being created
by David Ching
- 14 Replies
- Last post
by JPSA
- Hello, Under what conditions is the .mdmp file created or not I have written an app that (deliberately) dereferences a NULL pointer, but the generated error report does not have the "Files that help describe the problem" section when listing the report from the Control Panel "Problem Reports and Solutions". Viewing other reports that had been put there, some of them have the f
-
- VBA Powerpoint - identifying textboxes by type
by Peter Caisse
- 3 Replies
- Last post
by Peter Caisse
- Hi everyone, I'm writing an add-in for Powerpoint 2003. I'd like to know how I can identify textboxes by type if such a thing exists. For example, when reading a TextFrame, how do I know if I'm reading the title textbox, the subtitle, or a the big textbox with bulleted points depending on the slide model I've found the Shapes.Title property, but that only gives me the title if it exists, not the v
-
- Tough keyboard?
by darkfeffy
- 1 Replies
- Last post
by Claus Brod
- I own a Toshiba Satellite which runs a Windows XP Home Edition SP2. As well, I have an HP tower running a Windows XP Pro SP2. On both computers I use a physical French keyboard. Often I change it into a US keyboard on the language icon of the task bar of the Windows operating system for my word processing needs. The fun is lately I can't swap back to French on the keyboards of both computers. When
-
- Access and Graph
by AmberMara
- 1 Replies
- Last post
by Andy Pope
- Is it possible to change the Markers than come ready to use in MS Graph . I need to print a chart using this markers: "<" and ">" instead of tiangle, * , - , _ , + etc. does any one can give me any kind of help in this matter .
-
- Is there an event for when a modeless userform closes due to a runtime error ?
by Genki2
- 0 Replies
- Last post
by Genki2
- Hi, I have a rather large application running in VBA in Excel. The application can allow several userforms open at the same time (showmodal=false), each of which have a larger number of controls, variables, subroutines etc, so effectively each acting as a separate instance of a class. The main application itself keeps track of the userforms that are open, so that by clicking in an index worksheet
-
- Excel Advanced filter critera Question...
by Scott Boyd
- 2 Replies
- Last post
by Scott Boyd
- Hi Guys,
Just a quick one here... use advanced filters all the time and usually with data containing over 30,000 rows. I don't know of any way to use criteria such as 'Not equal to' or 'does not contain' etc. This is available along with many other advanced criteria in the auto filter > custom filter however this only works with upto 1000 rows. Any ideas how i could implement these to my fil
-
- Pulldown menu in MS-Access query
by dude313
- 0 Replies
- Last post
by dude313
- Hi all,
I have the need of a MS-Access report in which I can select a field value in a pulldown menu before the preview of the report is opened. Now I use a query, but there I have to fill in the complete field value. This means users have to remember exactly how the value is stored in the database.
Hope someone can help me out.
Cheers, Dude
-
- Download .xls files from the web and access their data
by Yossarian22
- 0 Replies
- Last post
by Yossarian22
- Hi,
I wanted to download a series of .xls files(over 2000!) from the web and copy the data in them into one file.
Given the URL's can excel (using a macros) download/open these files on its own and copy the data
Thanks!
-
- Extracting text from a text file
by DracoM
- 2 Replies
- Last post
by DracoM
- I have a text file which begins with a few lines of comments and then is followed by the text string ' FESTWERT'
I want to extract everyting from the first instance of 'FESTWERT' till the end of the textfile and put this in another file.
Can somebody help me
-
- CRM Case Creator also owns Activities for Case created by others
by CRMNewbie
- 0 Replies
- Last post
by CRMNewbie
- I am writing reports on CRM activities and am running into the issue where the inidividual who creates the Case also shows as the owner of activities created under the case. This means I cannot use ownerid when selecting activities for a user as the as the person who created the case and did the work does not necessarily OWN the activity.
We do have the scenario where a individual creates a
-
- displaying a table at vba word
by nta1
- 1 Replies
- Last post
by Peter Mo.
- How can I display a table in vba word (like DataGrid) that is not connected to any data base
-
- A question from a beginner...
by meisaka
- 6 Replies
- Last post
by meisaka
- Hi all:
I am new to the programming world, and I am interested in learning VBA. So, please provide some tips where should I start
Thanks in advance.
-
- Printing multiple PDF files from VBA (excel)
by Vik B
- 0 Replies
- Last post
by Vik B
- Hi All,
I performed a quick search and there was another thread about this but the solution they had did not work for me..
All I need is to have a function in VBA that can take the file path as an input parameter and print a PDF file..... The issue here is I will call this function a few times as I will need to print multiple files in the one go...
I have tried the shell execu
-
- 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
-
- Excel Checkbox - Multiple controls-only one may have value of true
by suznal
- 10 Replies
- Last post
by suznal
- I have checkboxes on a sheet of which, the value of only one may be true at a time. (By the way, I am not allowed to use option buttons on this workbook). I have figured out the basic code to use if there are only two checkboxes involved, but each instance I have involves a minimum of three and sometimes five checkboxes.
The code I have works well (for a pair of checkboxes) provided I supply it
-
- Select/cut/insert
by Bluzdude
- 4 Replies
- Last post
by Bluzdude
- I need to select all rows in an Excel worksheet in which the value in cell "F" is not blank, cut each of those entire rows and insert them in another worksheet at row "4".
-
- Winsock
by he.ll.cat
- 0 Replies
- Last post
by he.ll.cat
- Hello.
Would please me to know how if it is possible by means of VBA in ACCESS, to connect themselves to a machine with UNIX and to generate a listing with the last created archives in a route.
I am dealing with winsock but I do not have much experencia in the subject.
If somebody has example code, it would be thankful to them allowed to see it me, to guide Thanks and greetings to me.
-
- Excel Macros Loop Help
by Thundermocos
- 3 Replies
- Last post
by MyLady
- I am trying to figure out how to create an Excel Macro that will loop through worksheets and stop running when there are no more worksheets. I need to collect data from each tab "worksheet", so I want it to collect the data move to the next worksheet, collect the data.. etc until there are no more worksheets and stop.
Thanks
-
- Microsoft Office 2003 "word" not working properly after copying transferring hard-drive info via DiscWizard by Seagate
by zebaztianz
- 4 Replies
- Last post
by Harpreet Singh Khandiyal
- Microsoft Office 2003 "word" not working prperly after copying transferring hard-drive info via DiscWizard by Seagate.
I got a new SATA Seagate hard-drive and used their DiscWizard program to copy/transfer all the entire "OS" files.
PROBLEM
Windows Office 2003: when opening office 11 . . . the program trys to 'install' itself again and giving the message "sour
-
- How can I see the stack trace from the .mdmp file?
by Vedratna
- 14 Replies
- Last post
by Vedratna
- hi, everbody
we have recently created account in winqual and also successfully mapped our product over there. We also receive some error reports(buckets) in it. We have downloaded some of them in form of cabinet file. After extracting it we get the file having extension of .mdmp. I have opened it in windbg through open crash dump option. It opens it successfully but I can't see any stacktrace i
-
- Copy Past and Replace
by wojtyna
- 2 Replies
- Last post
by wojtyna
- Hallo everyone, Probably i should say at the begining that im a newbie. I have couple problems with my code. I need to copy, paste and replace text in a Word document. I created a code but its not sufficient for my needs. To be more specific. My text looks like:
[case1] a="case1" [case2] a="case 4" and so on... It needs to look like [case1] a="case1" b="case
-
- microsoft jet database engine could not find the object... with Excel named ranges under 64 characters in a closed workbook
by tbaker818
- 0 Replies
- Last post
by tbaker818
- I'm wondering if anyone has had this problem which seems to happen between the Microsoft.Jet.OLEDB.4.0 provider (could be others too) and Excel. I've gotten the error when creating a table in Access that links to an Excel named range and with ADO code. Microsoft says the cause is named ranges over 64 characters but this has never been the case. I n Access, I can successfully link a table to Excel
-
- How can I see the stack trace from the .mdmp file?
by Vedratna
- 14 Replies
- Last post
by Vedratna
- hi, everbody
we have recently created account in winqual and also successfully mapped our product over there. We also receive some error reports(buckets) in it. We have downloaded some of them in form of cabinet file. After extracting it we get the file having extension of .mdmp. I have opened it in windbg through open crash dump option. It opens it successfully but I can't see any stacktrace i