-
- Help in Creating a cell formula with variables using a macro
by dubaikhan
- 1 Replies
- Last post
by magicalclick
- I need help in creating a dynamic excel formula using variables. I have a start date in a macro variable which I want to pass within a macro to the creation of new sheet that takes this variable places it in an excel EDATE forumla and places the data info another cell. I know I have syntax issue going on in the highlighted area and would appreciate some help.
'Populate Variables ProjectSta
-
- Using all controls inside a frame, but in the right sequence.
by My_Head_Hurts
- 8 Replies
- Last post
by My_Head_Hurts
- I have created a form to present a user with a list of choices. These are determined externally, so I read a text file (one line per choice) and then use the text to populate the Caption attribute of an Option (radio button) control. I populate the option buttons in rows and then make the unused ones invisible, adjusting the height of the frame and form accordingly. This all works beautifully exce
-
- Using a formula as the default value in an inputbox (EXCEL)
by OTG
- 3 Replies
- Last post
by Andy Pope
- I currently have this:
Code Snippet NewValue = InputBox("Please enter a new value for the cell:", "User input required", Range(ACell).Value)
That works fine, except for cells in which there are formulae, where only the result of the formula is displayed. I want the user to be able to edit the formula using an input box. I've tried
Code Snippet
-
- Word 2003 AutoOpen Macro doesn't run if Outlook 2003 is open.
by aliank
- 5 Replies
- Last post
by bi-lya
- Good day experts, I written a word template with AutoOpen macro in order to load an object that will update footnote of the word document when user save the document. It works well when outlook is not loaded. But once outlook is loaded, the AutoOpen macro did not run anymore. If I open the document without opening outlook first, then automacro is working fine. But if I open the Outlook and then o
-
- need vba code to read between two different xcel workbooks
by wjulaxer13
- 2 Replies
- Last post
by wjulaxer13
- i am writing VBA code to run behind an excel workbook. I found that I need info that is contained on another workbook altogether and would like to know how i can access a different workbook. I would guess a path/file name, worksheet name, and tab at the minimum but there must be more to it than that. I havent found the solution to it in my experiments. anyone able to help me
-
- app verifier error log - Exception record. Use .exr to display it
by valent|n0
- 2 Replies
- Last post
by MS ISV Buddy Team
- Would this be the right forum to ask what is the message means
- < avrf:logEntry Time =" 2007-06-13 : 08:59:38 " LayerName =" Handles " StopCode =" 0x300 " Severity =" Error " >
< avrf:message > Invalid handle exception for current stack trace. </ avrf:message >
< avrf arameter1 > c0000008 - Exception code
-
- issue in vertical writing support in Uniscribe!!
by VNAHATA
- 3 Replies
- Last post
by MS ISV Buddy Team
- There are cases when copying a glyph from charmap into WORD rotates it 90 degree or sometimes 180 degree in case of Vertical writing .Does this information about rotation come from Uniscribe and if yes,how to get this info Examples of glyphs which are rotated 180 degree in vertical writing are U+2523,U+2517,etc and most other glyphs are rotated 90 degree(braces,brackets,etc).Please help me how doe
-
- Active directory information from VBA
by Sunder
- 1 Replies
- Last post
by Shasur
- Hi,
I would like to get the display name and other details of the user logged in from the active directory. Can this be done using VBA
Thanks in advance.
-
- 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
-
- OUTLOOK EXPRESS
by Rath150
- 1 Replies
- Last post
by Ken Tucker
- Hi,
First time here.
Don't know if I am in the right pew
Have problem with Outlook Express.
When I click on mail - message is totally in script - no graphics - just happened last night.
When I go to view tab - click - message in HTML - message looks fine.
However, when I go to next message same thing happens - no graphics.
Need help to get my messages back to normal read.
T
-
- Cannot find project or library
by Tuzz
- 2 Replies
- Last post
by Tuzz
- Is it possible for an ExCel Spreadsheet created with a most recent revision of an ActiveX Control to not work on a PC running a previous version of the ActiveX Control. In other words, backward compatibility not supported.
The Error code the user recieves is a Compile Error: Can not find Project or Library. This is with respect to the 'Format' function in VBA
With that said, we che
-
- Setting a header to all pages except the cover sheet
by Megaman1982
- 6 Replies
- Last post
by Megaman1982
- Hi all, i'm pretty new to Excell in the workplace and would really love it if you lot could help me with this difficult (TO ME) macro i'm struggling with.
I'm trying to finish off this macro, or mod it so that i get the page number, tab number, a cell reference in the respective headers and footers as explained in the macro below. only thing is i don't really want the tab label, cell refere
-
- Macro to FInd a Text and pick the next 4 chara of the found text.(or GET THE ACTUAL RESULT in side the macro)
by doshivinod
- 2 Replies
- Last post
by doshivinod
- Hello All,
I want to write a macro which will find a particular text in a word document.
(I know this has been discussed almost 100 times and is very easy)
But i want to access the actual found result inside the macro
or the next four chara of the found text.
e.g. (Document will contain the following text).
Pages : 2-3
Now i want to write a m
-
- Problem using Date/Time data type with VBA
by confusedcoder
- 2 Replies
- Last post
by confusedcoder
- Hello.
I'm using Access with a SharePoint list, treating it like it's a regular local table. I'm trying to program a button onto a form that will insert a new record into a different list than the one I'm working with on the form. A user enters a date on a form, and I want the user to be able to press a "submit" button that will transfer that date to a new record on another ShareP
-
- Difficulty using the Findrecord Method
by JBNV123
- 5 Replies
- Last post
by JBNV123
- Hi, for some reason if I use the code following (changed for my spefic data of course) I do not get the desired record to display, in fact I get only the record I am currently viewing to display, ie it is as though nothing is happening. This code is supposed to search for the record with "Joe" in the "FirstName" field and display it and also store the record number of interest
-
- 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
-
- messageBox not showing in current window
by Bajrang
- 1 Replies
- Last post
by Bajrang
- Hi,All I want to show a message box when user click my custome send button to sending a Mail Item. Everything is working fine but Messagebox in not showing in current window (that is Mail Item), but it is showing in parent window of OUTLOOK. To see this message I have to move into OUTLOOK's main window. There in no much coding , I don't know where the problem is Please help me out. my code is here
-
- 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
-
- Vista Shuts Down
by HITMAN
- 0 Replies
- Last post
by HITMAN
- Help ISATAP Adapter, is reporting "tv_ConfigMgrErr31" Also, failure using the VxD loader. Vista crashes when playing installed games or downloading Norton Antivirus updates. Any ideas
-
- 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
-
- Hello, I am trying to get a .csv file to open using the get open filename method! I want excel
by JGttttt
- 4 Replies
- Last post
by Mohamed Shifaz
- I am trying to get excel to open a .csv file using the get open file method. I want excel to open the file and read the data from the .csv file and put the data into an expense sheet. When I hard code the file using the open filename method, I am able to open the file and read the file to the expense sheet using a Do loop. I am using two counters to cycle through the .csv file and expense sheet. T
-
- GET.CHART.ITEM
by Jonas.S
- 3 Replies
- Last post
by Jonas.S
- Hi all,
Anyone having a list over point_index which is used in GET.CHART.ITEM()
Regards
\Jonas
-
- Empower to certified looking for assistance
by Voast Dev
- 1 Replies
- Last post
by MS ISV Buddy Team
- I enrolled in the empower program, and used those tools to get an application tested and ceritified. My company is now a certified partner and I need some assistance with developing a POS application. In the partner portal I am having difficulty locating this assistance. A lot of links talk about empower and how I should re-enroll. How can it be that the empower program, which has a two year max,
-
- 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()
-
- Microsoft CRM Campaign Distribution Error "system aborted"
by Liam Murray
- 0 Replies
- Last post
by Liam Murray
- Hi,
Can anyone help me with CRM Campaigns
We have been trying to create crm campaigns and while the campaign and marketing list are created without any problems when we distribute a campaign activity email it goes to pending (it pauses for an awful long time when you first save it) and then when you go back in it states "system aborted".
We have tried countless test