-
- How to override windows settings using macros in excel-urgent help
by arunnc84
- 3 Replies
- Last post
by arunnc84
- Hi guys, i had written a macro to get a date value and convert it to the date format which i need using the below code. date = Format(tempworksheet.Cells(1, 1).Value, "yyyy-mmm-dd"). it is getting converted fine when the regional language is US(English).When i change the language to czech it is not getting converted fine.The month is taken as date and date as month i.e if i enter 06/05/2
-
- aggregate functions: problem with SELECT SUM()
by Maximus
- 4 Replies
- Last post
by Cringing Dragon
- Hi there, I wonder why the function below returns 0 (it should return 4335) * the conn to the db is ok (this function works with diff parameters, it has somthing to do with the SUM) * I check the SQL code on the db - and the return result is not 0
Code Snippet
Function test3() Dim objDB, arrRecord, strRecord, strOutput Dim oRS, nRec, oFld Dim row Set objDB = DBConnect()
-
- How to Get Position of Scribble line's Points?
by Sstar
- 4 Replies
- Last post
by Sstar
- I have scribble line object in my Ms Word document.
Shape.Type = msoFreeform
Now I want to get position of the controls points and change it slightly. How can I get the controls points' position in the first place.
I noticed that
Shape.ShapeNodes.SetPosition ( index, x, y)
helped me to set position of each node. However, no ShapeNodes.GetPosition functio
-
- Excel Command Button - Hide multiple sheets based on IF statement
by suznal
- 9 Replies
- Last post
by suznal
- I have a sheet in a workbook that acts as a sort of table of contents.
All of the sheets in the workbook are listed in a column and the column to the left of each worksheet name is either blank or contains an ¡®X¡¯ depending on whether the sheet was used on a particular occasion.
I have a command button on the page that will hide a sheet if a particular cell is empty. Currently this only wor
-
- Out of Memory
by James Simm
- 4 Replies
- Last post
by Jamie Bates
- Hi there, I'm working with an Excel application, and I've written a .Net C# wrapper to it, to allow me to interact with an Oracle DB. Whenever I run the following code, I get the error "Out of Memory":
Code Snippet
Public Function Create(ByVal marketID As Long, ByVal ws As Worksheet) as Boolean Dim colDetails As Collection Dim xlName As Excel.Name Dim iRow%, iRow1% Dim iCol%
-
- code for binary to decimal conversion in access vba
by Anonymous555927
- 0 Replies
- Last post
by Anonymous555927
- Help... I need to convert a string of binary numbers to decimal using vba code. Tried the cdec function in access but no good.
-
- Does Winqual accept WER reports from Vista systems?
by Claus Brod
- 14 Replies
- Last post
by Jason Hardester - MSFT
- Hi all, we recently registered for the Winqual site. Reports are coming in about crashes in our application which occur on Windows XP systems, so it seems like the whole registration process worked as expected. However, we also ran our application (same version as on XP) on Vista, and provoked several crashes (same type of crashes as the ones on XP) there - but don't see *any* reports on the Winqu
-
- Obtain Unique Work Units via SQL
by AlDeb
- 14 Replies
- Last post
by AlDeb
- Below is the SQL I have for a Query. The results of my query are below the code. Everything works great except for the WorkUnit totals.
I am getting the total Records for the date range and I really need the Unique workUnits for the date range. For this particular daterange I
have a total of 197 WorkUnits but in reality there really are only 89 Unique WorkUnits.
In the example below on on
-
- 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.
-
- Querydef Conundrum
by Fred Morstatter
- 0 Replies
- Last post
by Fred Morstatter
- I have a QueryDef Object that executes a stored procedure on SQL Server. My problem is that I cannot get the QueryDef to see the following Stored Procedure as an action query, rather than a select query:
Insert into TempTable Select * from myTable;
This works just great out on SQL Server, but when I run it from within access I get the following error:
Runtime error '3065':
-
- referenced memory error
by rham
- 2 Replies
- Last post
by rham
- hello people. I have an error in my computer that I don't know how to fix. IT says instruction at "0x269e7875" referenced memory at "0x269e7875". The memory cannot be "read". click ok to terminate program.
-
- Sum of columns
by Sreeja561936
- 1 Replies
- Last post
by Keithyboy1
- hi,
I want to get the sum of a perticular column.. however the column range may differ .. so first i need to check the no. of rec in the column and then add them ....
pls help
-
- SharePoint 2007 Zone Tab Work Around?
by Hummell
- 0 Replies
- Last post
by Hummell
- Hey everybod, i'm totally noob here, I know. I've got a question that i'm hoping one of you might be able to assist me with. My company is in the process of migrating from the MOSS 2003 platform over to MOSS 2007. I think it's fantatstic because of the additional functionallity offered in MOSS 2007. However, I do have one MAJOR concern.
Currently, I am responsible for reporting on our opera
-
- 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
-
- Saving a pic
by Edday
- 7 Replies
- Last post
by Andy Pope
- hey
i really need help with this, i have posted in tons of forums and the descussion groups, no replies! gar
lol, well i have this macro in excel 2003 and it has a userform and there are a few elements (3 pictures, 3 text boxes) that get modified during the macro then i need to kinda merge them and save it as one picture, can a macro do that
any help would be great thx
-
- Microsoft Office Document Imaging Printer Missing in Office 2007 (RFP) (86)
by rjo2
- 11 Replies
- Last post
by andria72
- Can anyone tell me how to install Microsoft Office Document Imaging Printer in Office 2007 (RFP). Although the Imaging program installs, the Printer does not, and the Microsoft Office 2007 Professional (86) Installer say that it is not an available feature.
-
- How to copy combobox value to active cell in excel worksheet Automaticaly vba
by abkarino
- 5 Replies
- Last post
by abkarino
- Thanks for help . I Make a userform with combobox and make the row source but
How do I get the highlight value from my combobox to active cell in excel worksheet automatically.
Using Excel 2003.
Pls.help me
thanks
-
- run-time error '1004' Method 'Range' of object '_Global' failed wen using refedit
by MarkH001
- 1 Replies
- Last post
by Andy Pope
- I have looked around the web and cannot find a solution .. hope somebody can help..
I consistantly get run-time error '1004' Method 'Range' of object '_Global' failed when I hit the Range command.
The refedit contanis text somthing like (select a range of cells with my mouse)
'Sheet1'!R5C2:R15C2
But I cannot turn that into useable information.
My code is launched from a command bu
-
- Is there a way to abort during runtime
by ke wenzel
- 5 Replies
- Last post
by JoAnNaT
- Hi, If I am running a VBA program in MS Access 2003 that has a programming error such as an infinite loop, is there a way to abort the program without killing Access from the task manager (and losing any unsaved changes) KW
-
- column headings in a combobox
by CaRecycler
- 2 Replies
- Last post
by CaRecycler
- I have a VBA application that fills a combo box from an array and I'd like to display column headings as well. By using columnheads = true I can reveal the headings but getting a value into that heading space is proving tiresome. Any ideas
-
- Clearing a manually created indent for a paragraph
by kkrishna
- 3 Replies
- Last post
by Andy Pope
- I am testing the process of removing indents from headings. I created a manual tab indent (pressed Tab and created an indent for the heading text). Now I want to remove this indent by code. I tried the following:
oPara.Outdent
oPara.TabIndent(-1)
oPara.TabStops.ClearAll
The above codes were tried individually and collectively. I was not able to clear the indent created.
Ho
-
- Compatibility Issue Excel 2000 and Excel 2003
by rcash864
- 11 Replies
- Last post
by Jon Peltier
- I wrote a macros for a customer in Excel 2003. He didn't tell me he used Excel 2000 until after the project and like an idiot I forgot to ask. The macros will not run on his version of Excel 2000. A compile error shows up.
So he got a version of Excel 2003 and the macros will still not work for him. I have tested this macros on other machines using 2003 and they all work correctly for me. I liv
-
- more than character count.
by M. Nicholas
- 3 Replies
- Last post
by M. Nicholas
- We use several custom made templates in Word 2000. I need to write a VBA subroutine in each template that will fill a variable with a character count of the document when prompted by a button.
Along with the normal (obvious) characters, I need to count such things as spaces, bold-on and bold-off, carriage return, tab, underline-on and underline-off, etc.
I know that if you turn on al
-
- Help to convert file (delimited)
by DBrooks
- 2 Replies
- Last post
by magicalclick
- I have an application that produces a comma delimited text file (that¡¯s the only option). I have another application that requires this file to be in tab delimited format. My staff does not know how to do this automatically (through program).
Is it possible to write a vb script to automatically convert the file from comma delimited to tab delimited Would this be an easy task, or woul
-
- Macro picture question
by dblakely
- 2 Replies
- Last post
by JoshZ
- I had written a macro (V11) that would strip out pictures from a vendor's price sheet and perform other cleanup functions.
Now, it leaves the pics in when I run it in V12!
Is there some coding that will allow me to a) select a pic in each sheet in a workbook and b) delete it
I've been searching around and cannot come up with a solution.
Thanks in advance.
-Frustrated
If y