Recent questions tagged VBA

0 votes

1.7k views

1 answer

vba - VBScript - How to make program wait until process has finished?

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.6k views

1 answer

vba - Removing a string that includes CRLF characters from body of e-mail

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.6k views

1 answer

vba - Prevent enabling of shift bypass - Access 2010

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.8k views

1 answer

vba - Object variable or With block variable not set (Error 91)

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

2.1k views

1 answer

vba - Run-time error '3061'. Too few parameters. Expected 1. (Access 2007)

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.5k views

1 answer

vba - lastrow and excel table.

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.4k views

1 answer

vba - Difference in type between using and not using Set keyword

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.6k views

1 answer

vba - How do I access the selected rows in Access?

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.8k views

1 answer

vba - Open an Excel file from SharePoint site

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.7k views

1 answer

vba - Excel Macro, inserting internationally valid formula during run-time

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.6k views

1 answer

vba - Combine multiple Excel workbooks into a single workbook

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.8k views

1 answer

vba - Determine real cause of ODBC failure (error 3146) with ms-access?

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.8k views

1 answer

vba - VBScript to open a dialog to select a filepath

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.5k views

1 answer

vba - Rounding a number to the nearest 5 or 10 or X

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.7k views

1 answer

vba - Excel: macro to export worksheet as CSV file without leaving my current Excel sheet

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.8k views

1 answer

vba - How can I generate GUIDs in Excel?

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.5k views

1 answer

vba - What is the function of FormulaR1C1?

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.6k views

1 answer

vba - Differences between Excel's Form Controls & ActiveX Controls

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.5k views

1 answer

vba - IsDate function returns unexpected results

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.5k views

1 answer

vba - How do I name a spreadsheet automatically, by referencing two cells?

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.7k views

1 answer

vba - Loop through Excel Sheets

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.7k views

1 answer

vba - How to count up text of a different font colour in excel

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.8k views

1 answer

vba - Outlook Reply or ReplyAll to an Email

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.5k views

1 answer

vba - Paste Excel range in Outlook

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.6k views

1 answer

vba - Is there a faster CountIF

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.6k views

1 answer

vba - How do I sort a collection?

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.8k views

1 answer

vba - Excel tab sheet names vs. Visual Basic sheet names

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.5k views

1 answer

vba - Can I make this macro more efficient or faster?

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)

Categories

Just Browsing Browsing

Most popular tags