-
- WSS 3.0 "This stock feature has been retired."
by bafadam
- 14 Replies
- Last post
by cis365
- What is this error No hits on google, nothing wrong with the page....nothing (that I know of) has changed recently.
Anyone have any clue with this could possibly be referencing
-
- Excel - Resize image to specified target cells' dimensions
by suznal
- 4 Replies
- Last post
by suznal
- I have a command button on a worksheet that calls up the ¡®getsaveasfilename¡¯ dialog, and inserts the selected image file into a merged range of cells. The images are automatically re-sized to fit into the cell (aspect ratio maintained). Everything works well, but I ran into a problem.
There are about 70 sheets in the workbook, and this command button can be found about 250 times throughout the
-
- 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!
-
- VBA Using InsertObject function to insert graphic file into Form
by ThomasStricker
- 0 Replies
- Last post
by ThomasStricker
- I use the a Module attached to OnDoubleClick Property of Form named ModelPicture1 to InsertObject into the ModelPicture1 form. The Object (*.bmp graphic file) is inserted correctly into the Form during runtime (MS Access Runtime), but is not saved Form when closed. How do I get this file to save into the form
Please and Thank You.
-
- Regarding getting references that can be applied towards ISV Competency
by H Patil
- 2 Replies
- Last post
by Dean Cline
- Hi:
We are an ISV that has developed a financial software using .NET. We are currently in the process of certifiying this product for Windows Vista.
I had a little confusion over getting customer references for the purposes of getting the ISV Competency: The MSPP Program Guide mentions that we can get references for projects that we have done, but since we are primarily a product company,
-
- CRM 3.0 "Server might be unavailable".
by trep
- 4 Replies
- Last post
by DavidJennaway
- Hi, I'm having an issue with CRM 3.0 Clients get this error message where it says "Server might be unavailable". Server is running, services are running, everything looks fine, so i started the Environment Diagnostics Wizard and i get the following: Some of the domain controllers do not appear to be running. The following list of servers should be checked. PrivUserGroup {9cd76ed6-ec49-4e
-
- How to check if a date exists
by HMote
- 5 Replies
- Last post
by HMote
- Could anyone point me in the right direction I just need a way to see if a date exists...example: "6/31/07" doesn't exist, whereas "6/30/07" does exist. Thanks!
-
- Subscript out of range
by NutoVBA
- 6 Replies
- Last post
by NutoVBA
- I am new to VBA and am trying to create a copy of a sheet from one workbook to another workbook using the following code:
Workbooks.Open Filename:=bw_path & "\" & bw_file
'Opening the file from which I want to copy.
Sheets(bw_sh).Copy After:=ThisWorkbook.Sheets(3)
'Trying to copy the open worksheet into the workbook housing the macro.
I am getting the "sub
-
- iexplore.exe - Application Error
by bennett1016
- 14 Replies
- Last post
by rreynard
- I get the following error message when I close my internet explorer.
The instruction at "0x62304320" referenced memory at "0x62304320", The memory could not be "read". Click on OK to terminate that program.
Any ideas what is causing this
-
- using keyDown event to stop non-Hex input in Access form textbox
by .ken.
- 3 Replies
- Last post
by .ken.
- Trying to only allow hex input into a text box. I just started to learn visual basic a few days ago and it is all very neat how powerful it is. My code doesn't work, but any help would be appreciated. or any other ways of only allowing 0-F into a text box would work as well. Doesn't necessarily have to not allow G-Z into the box but needs to stop the program from running if it is entered.
-
- Excel ComboBox and VBA
by truongn2
- 1 Replies
- Last post
by ADG
- Hi, I am really stuck on this, please help!!! I would like to have a ComboBox on a worksheet (worksheet1) that is populated by a list on another worksheet (worksheet1). Each time I select something from the ComboBox, it would display text in a cell within worksheet1. For example, the ComboBox would have "Cat", "Dog", "Cow". And when I select "Dog" from th
-
- Microsoft Access 2465 Application Defined Error - Form control code reference/Compile issue.
by Jamie Clayton
- 2 Replies
- Last post
by Jamie Clayton
- G'day,
One of the problems we have faced recently with an Access application that our company has written and supported for the last 11 years (Access 2 originally and now in Acccess 2003 ) is global variables and the VBA compiler. We had some significant development, debugging issues with global variables going out of scope. So in a crude solution to this problem we have move them all to fo
-
- vlookup
by Namrata Prashar
- 14 Replies
- Last post
by Namrata Prashar
- Hello
can anyone help me with how to write the excel vlookup function in vba
the function in excel looks like this
VLOOKUP(O2,'[Consolidated list of supplier.xls]Sheet3'!$A$5:$F$218,6,FALSE)
how can i get something similar working in a macro.
thanks
namrata
-
- excel 2003 - sp2 - OpenTextFile(,ForAppending,,)
by jdrean
- 1 Replies
- Last post
by Peter Mo.
- in vba the following command will generate an execption:
Set fs = CreateObject("Scripting.FileSystemObject") Set f = fs.OpenTextFile(filename, ForAppending, , 0)
Instead one needs to replace ForAppending by 8 (the default value from the system is 3)
note: it is confusing because it is working for ForReading and ForWriting
-
- Problems with VB solver code
by Stacy B
- 1 Replies
- Last post
by Jon Peltier
- I am writing visual basic code behind an excel spreasheet and am having difficulty making it work. It involves using the solver function. The code is listed below:
Sub signif_control_pop()
Dim cntlpc Dim pop
'Clear any previous solver settings. SOLVERReset
'Prompt user for population size. pop = Application.InputBox(Prompt:="Population Total:", Type:=1) Range(&qu
-
- Inserting rows and columns in protected sheet.
by Anulas
- 2 Replies
- Last post
by Anulas
- I have got a protected sheet in which some of the columns and rows are locked. Hence the user will not be able to edit these cells. But they can edit the unlocked cells. i have set the lock property of all the cells in the sheet to unlock. Then i locked only the requried cells manually.
But when i am trying to create a new column next to locked column or new row next to the locked row, the newl
-
- CreateWorkspace() call fails after installing Office(Excel) 2007 - using ODBC
by HedleySohn
- 3 Replies
- Last post
by HedleySohn
- We have a VBA component that we've used for a long time. Our users have recently begun to report that the component no longer runs once they install Office 2007.
We have always created an ODBC workspace as in the following:
DIM workODBC As DAO.Workspace
Set workODBC = CreateWorkspace("ODBCWorkspace", "Admin", "", dbUseODBC)
This call
-
- 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 to reference a reference error in an XL worksheet cell using VBA
by kiloez
- 1 Replies
- Last post
by kiloez
- Hello, I need to know how to reference a cell in an XL worksheet that is showing a reference error (#REF...). I have a number of huge workbooks where I need to be able to delete any row that is showing a REF error in column 1. I see that ERROR 2023 is returned but I get Type mismatch errors when trying to reference this error in code when using something like:
dim strErr as String
st
-
- Use cmdRename to rename Excel worksheet as yesterday's date
by Wendy582482
- 1 Replies
- Last post
by Keithyboy1
- Hi,
Does anyone know what's the code for renaming an Excel Worksheet (sheet1) as yesterday's date in mmddyy format I've made several attempts and was not successful.
Thanks
-
- Now Button
by DinnerPlates
- 1 Replies
- Last post
by sjoo
- Hi
I'm new to coding macros and am wondering if anyone knows how I can create a button that jumps to today's date on a spreadsheet
I have a long column of different dates and would like to make it easier for anyone who accesses the worksheet to go straight to today's date...
I've been trying to use several combinations of the code "Range(Now).Select" but have yet to succeed..
-
- Programming Adobe Acrobat Reader 7.0
by Microhands
- 1 Replies
- Last post
by Alexei_shk
- I have succesfully programmed Adobe Acrobat Standard 7.0, see code snippet below:-
Dim objAcroApp as AcroApp
Set objAcroApp=CreateObject("AcroExch.App") ' Starts up Adobe Acrobat Standard 7.0
Dim objAcroDoc as AcroAVDoc
Set objAcroDoc=CreateObject("AcroExch.AVDoc") ' Create an object to allow a file to be opened
However, when it comes to using the ActiveX
-
- Web Part Editor Doesn't Postback
by NeroArizona
- 1 Replies
- Last post
by NeroArizona
- Hi All.
I have created a master page (as a feature) that I am using on a Moss 2007 site. Everything seems to work fine except when you have webparts.
I can add web parts (eg. Content Editor Web Part) and make changes in the editor for the web part (eg. HTML source editor). However, when I click any of the buttons at the bottom (OK, Cancel, Accept), there is no postback. Its as if the
-
- Windows Error Reporting - handling unanticipated errors
by John Blight
- 7 Replies
- Last post
by John Blight
- For Vista certification, is any handling of unanticipated errors prohibited (other than throwing them)
Let's say an application has to process a large number of files. If an unanticipated error occurs when processing one of those files, I wouldn't want that to prevent the application from processing the rest of them. Could we report the error through WER, but also handle it
-
- Problem with converting numbers stored as text in excel.
by Mr T
- 6 Replies
- Last post
by MyLady
- 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