-
- Migrate code from VBA to VBScript
by Fra_Down
- 0 Replies
- Last post
by Fra_Down
- I would like to migrate scripts written with VBA in a third party tool to scripts written with VBScript in another tool. Do you know a web site explaining the differences between these languages or a tool allowing to migrate from one language to other
-
- Visual basic training
by Judy40la
- 2 Replies
- Last post
by JohnWein
- Hello,
I am new to visual Basic we used it in our Access Database for work. Is there a training program that I could take online to learn it fairly quickly for Access I downloaded VB 2005 at home and would like to use it to learn the total concepts of VB for access. Can anyone point me in the right direction
Judy
-
- Debugging
by une
- 2 Replies
- Last post
by une
- I can watch the execution flow of code in VBA under MS Word 2002 using the F8 key. How do I take a step backwards I want to watch a small section of execution flow again without starting from the beginning.
-
- VBA String manipulation problem.
by OM
- 2 Replies
- Last post
by Andy Pope
- (i orignially posted this message in the vb forum... but was told to post in here instead.)
I'm trying to code for an Excel spreadsheet.
Very new to VBA.
I want to replace all comma characters with a newline character.
And then get rid of all whitespaces.
So far, I've got this:
Worksheets("Summary").Cells(i - 4, 1).Value = Trim(Replace(StrConv(Worksheets(&
-
- when to call Uniscribe api??
by VNAHATA
- 2 Replies
- Last post
by VNAHATA
- Hi, While reading GDI commands from an emf file,when should we be calling Uniscribe functions.Is it for every ExtTextOut command or just when we see the ETO_GLYPH_INDEX set in ExtTextOut.Is ETO_GLYPH_INDEX the only indication that the text'll contain complex scripts or with other options too,we may require to call Uniscribe Itemize function Please help. Regards, Vinay
-
- 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
-
- 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
-
- 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".
-
- Hello!!! I want to know how to find a string in a Cell
by JGttttt
- 3 Replies
- Last post
by JGttttt
- I am Importing .csv file into a spreadsheet. There are certain text string values within a column and muliple rows. I need to check to see whether or not that value is there and then use that value to move data in other columns. I am running a Do Until loop that cycles through all the data on the sheet until a null value is found. I'm then running If then conditional statements that checks to see
-
- Macro in excel
by Paul Ked
- 1 Replies
- Last post
by bi-lya
- Hi
I could do with a bit help.
I have created a macro in excel that is basically this;
Sub auto_open()
ThisWorkbook.Worksheets("Aftersales").OnEntry = "DidCellsChange"
End Sub
Sub DidCellsChange() Dim KeyCells As String Dim cells, tmpStr As String cells = range("A38").Text Here = ActiveCell.Address MyColumn = Mid(Here, In
-
- Access 2007 and Vba
by Anonymous_34857345
- 0 Replies
- Last post
by Anonymous_34857345
- Hi
I have a problem with Access 2007 and Vba
I have a mask;
in the mask there are 2 controls:
a listbox
and a textbox.
The source of the Listbox is "Select cat_name from Category1"
I would that
at the event click of the listbox
the source property of the textbox was:
"Select cont from content where cat_nameFk = @cat_nameFk"
@cat_nam
-
- Office Communicator 2005 sign-in name, auto populate after install somehow?
by markm75c
- 14 Replies
- Last post
by Mike@ALS
- Does anyone know of a way to have the sign in name in communicator, auto filled in after an install or doing the install..
Basically every user has the same format.. first.lastname@domain for the login.
I'd prefer to find a way to have this info auto entered after the install when it first tries to open.
I'll be using communicator as a "broadcast" method.. and alot of users prob
-
- How to copy cell value from formula bar in VBA
by Howard Reit
- 1 Replies
- Last post
by Sabaawy
- Hi, I am trying to transfer Excel info into a web based form. For some reason a simple copy/paste does not work. The only way to move the data is highlight the entire selection in the formula bar and then copy. When I paste into the web form this works. How do I do this in VBA Appreciate any help on this Howard
-
- Access 2003 Workspaces
by Toblerone
- 7 Replies
- Last post
by LCarato
- Hi all, I have an app in which I need to create forms and controls on the fly (A form that designs itself from table data). That part i have solved and it works perfectly. The problem i'm faced with is not being able to create forms once the db is compiled and converted to .mde I have been reading about workspaces. My idea is to create a workspace and generate the forms in that. None of the forms
-
- Calculation based on hidden text fields on WORD form
by christy c
- 3 Replies
- Last post
by ke wenzel
- MS Word 2003.... I have a few text fields on a Word form. When the user clicks on TEXT_1, A macro popups a UserForm for user to select data. When the UserForm is closed, I display the user's selection in TEXT_1 and store a numeric value, such as "10" in TEXT_2 field. TEXT_2 is a hidden field (via font). The user do that a few times -- click on TEXT_3 and store numeric value in hidden TEX
-
- About FileCopy
by YaelS
- 1 Replies
- Last post
by Peter Mo.
- Hi,
How can I do this:
Code Snippet
strFile = "myfile.doc" ' check if this this file exist in C:\MyDir
' if not copy this FileCopy strFile , "C:\MyDir\" & strFile
Thank's,
Yael
-
- How to configure CER with no dialog?
by John Brown
- 14 Replies
- Last post
by Claus Brod
- I just tried to configure my XP SP2 workstation to send crash reports to a CER file share such that no dialog box would be presented. It didn't work as expected. ReportFault returned frrvErrNoDW and no crash report showed up in the file share. I have the 'Configure Error Reporting' policy enabled and a corporate file path entered. This works fine when I elect to 'send report' through the dialog bo
-
- ISV Software Requirements
by jk_0321
- 2 Replies
- Last post
by cUtEpInKbUnNiEs
- Hello all,
Sorry I'm new here and was unable to find an answer to my questions using the search feature.
Because Microsoft requires several MCPs to satisfy their non-ISV competancies, I need to take the ISV route to get Certified Partner status.
If I was to go for the ISV Competancy, what kind of application are they expecting me to develop I read on the lionbridge site that games and of
-
- Posting Excel File Online
by kd24
- 0 Replies
- Last post
by kd24
- I have an excel file with vba code and macros behind it. Is there any way to put the file online on a website so that the macros and vba can be run
Thanks.
-
- Access - VBA Script
by phpx2pperl
- 1 Replies
- Last post
by mnptl
- I have a sub form which needs 2 fields updated one is numeric and the other is text both are using text boxes as the control source. I have searched the web and my book references but stuck on getting the input from the user for these two fields and updating the input at my target table. One question is can I update my target table using the dynaset and form I used to build my resultant query You
-
- Obtain formula value in VBA
by DinnerPlates
- 3 Replies
- Last post
by Andy Pope
- Hi all,
I have created a macro (thanks once again to the help of Andy) which looks like this:
-
- 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
-
- 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.
-
- Overflow (error 6)
by une
- 5 Replies
- Last post
by Keithyboy1
- I have code that executes fine 99% of the time. The other 1% I get an overflow error (error 6) that relates to the following line;
startTime = Year(Now) * 365 * 24 * 3600 + Day(Now) * 24 * 3600 + Hour(Now) * 3600 + _ Minute(Now) * 60 + Second(Now)
startTime is declared as a double;
Dim startTime As Double
The value of startTime at this line (according to debugger
-
- A couple of questions regarding the Windows Error Reporting Program
by Straightwaytech
- 2 Replies
- Last post
by Leighton
- Hello,
Recently I discovered that the Microsoft Windows Error Reporting program is open to all developers free of charge if two requirements (more or less were met). The first requirement was that upon signing up for the program, the candidate company must send a unique Verisign certificate that represent's their organization's identity (about $100). The second requirement was that the applic