Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

Recent questions tagged vba

0 votes
1.4k views
1 answer
    I have a problem in a VBScript that I am using with a VBA/Excel macro and a HTA. The problem is just ... exclusively select a FOLDER in HTML. See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.2k views
1 answer
    I am trying to remove a string from selected incoming MS Outlook (2016) e-mail. The string is two sentences ... parts of it for deleting? See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.2k views
1 answer
    I am trying to prevent database users from being able to view the linked tables in the navigation pane of an ... in the office atm) Thanks See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.5k views
1 answer
    I have the following code: Sub AddSources() Dim pubPage As Page Dim pubShape As Shape Dim hprlink As Hyperlink Dim ... what I'm doing wrong? See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.7k views
1 answer
    I have the following 'set recordset' line that I cannot get working. The parameters seem correct according to all ... but no joy. Many thanks. See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.2k views
1 answer
    I have tried to define a lastrow code that would return the last row value of the last non empty cell in a ... regards and thanks in advance /D See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.1k views
1 answer
    I just solved a problem I was having putting the "Set" keyword in a definition line but what I would like to ... Range". Why would that happen ? See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.3k views
1 answer
    I have a form which includes a data sheet. I would like to make it possible for a user to select multiple rows ... obscure on the net... Thanks! See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.5k views
1 answer
    I'm trying to open an Excel file from SharePoint using VBA. Because the file I'm looking for might be different ... Why doesn't VBA like it? See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.4k views
1 answer
    I've got an Excel spreadsheet, with a Macro, that inserts a conditional formatting, like this: Selection. ... work on ALL versions? See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.3k views
1 answer
    I am a novice at Visual Basic. I can use either Excel 2010 or Excel 2013 for this task. I have dozens ... be called combined.xlsx for example. See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.5k views
1 answer
    My client is using Access as a front end to a SQL Server database. They recently started getting ODBC - 3146 ... on how to diagnose this. See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.4k views
1 answer
    At present I am opening a file with my vbscript as follows: strFile = "C:Usersestfile.txt" Set objFile = ... how to complete in a VBScript. See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.2k views
1 answer
    Given numbers like 499, 73433, 2348 what VBA can I use to round to the nearest 5 or 10? or an arbitrary number? ... -> 2350 7343 -> 7340 etc. See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.4k views
1 answer
    There are a lot of questions here to create a macro to save a worksheet as a CSV file. All the answers ... continue working in my original file? See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.4k views
1 answer
    I have an excel file with one order on each row, and I want each order to have a unique identifier, so ... appreciated. Thank you in advance. See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.1k views
1 answer
    I have been looking at FormulaR1C1 as a function, how does this exactly work? I understand what has been said ... So could it be FormulaR2C3? See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.2k views
1 answer
    Why are there 2 types of controls available in Excel? (2 buttons, 2 combo boxes, 2 check box, etc...) ... and how can I tell the difference? See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.2k views
1 answer
    How come IsDate("13.50") returns True but IsDate("12.25.2010") returns False? See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.1k views
1 answer
    I've just finished writing a spiffy macro for automatically generating reports. It works well, but I need it ... with the incorrect separators? See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.4k views
1 answer
    I have the following Code and I would like it to run in 25 other sheets of the Workbook and instead of repeating ... Field:=1 End With End Sub See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.4k views
1 answer
    I have a list of names that has been exported from another database into excel. The names in the list that ... help would be much appreciated! See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.5k views
1 answer
    Set objOutlook = CreateObject("Outlook.Application") Set objMail = objOutlook.CreateItem(0) objMail.To = " ... body into objMail.HTMLBody See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.2k views
1 answer
    I want to paste a range of cells in Outlook. Here is my code: Sub Mail_Selection_Range_Outlook_Body() Dim rng ... this property or method. See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.2k views
1 answer
    As the title says. Is there any function or VBA code which does the same function as a countif and is a lot ... lists are around 100,000~ rows See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.2k views
1 answer
    Does anyone know how to sort a collection in VBA? See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.4k views
1 answer
    It seems that Visual Basic can not reference sheets according to user-modified sheet names. The worksheet tabs can ... each new sheet or sheet tab re-naming? Question&Answers:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
1.1k views
1 answer
    I am brand new to coding. This macro runs slow and I'm hopeful that someone can help me clean it ... :=True, Scenarios:=True ActiveWorkbook.Save End Sub Question&Answers:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
To see more, click for the full list of questions or popular tags.
Ask a question:
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...