Recent questions tagged VBA

0 votes

1.1k views

1 answer

vba - Get Unique Values Using Advanced Filters Not Working?

I have two sheets: Sheet 2: Column C Supplier Name A A B B C Sheet 1 (Desired Result) Column G A B C I am ... so: Sheet 1 Column G A A B C See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.3k views

1 answer

vba - Use comma instead of dot for decimals when saving as text

This question looks similar to Visual basic handle decimal comma, but that one is about an entirely different ... not bringing any inspiration. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

vba - Speed up an Excel Macro?

Right now I have a macro PopulateYearlyValues But it seems to me it's taking way too long Sub PopulateYearlyValues( ... other way to do this? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

vba - Extracting Unique values from a list

I have the following code that returns 50 random color-coded numbers: Sub RandomNumberColor() Dim Numbers, i As ... would be much appreciated! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

vba - Programmatically extract embedded file from PowerPoint presentation

I am working on a VSTO PowerPoint add-in which involves recording and playing sounds. I was requested at ... find that person on StackOverflow! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

vba - AutoFit doesn't work with wrapped text

I have one Chr(10) in the cell cell.WrapText = False cell.EntireRow.AutoFit ' AutoFit works ' ---------- ... last line. ver - famous excel 2010 See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

vba - Working with multiple discontinuous selection

I'm trying to do something with a multiple selection. I wanna add some text before every selected paragraph but, when ... ("TEXT") next End sub See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

vba - Data type Number-Decimal

until few days ago everything was working fine and then I run into this problem. I wrote some code for ... vba related. Any suggestion? Thanks See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

vba - Opening Microsoft Access with parameters

Similar to the OpenArgs property of the Form object, am I able to open the Access Application itself with a ... a different menu screen etc. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

vba - OLE Automation to launch MS Word and bring to front

What is the "correct" (recommended) method for connecting to a running instance of MS Word and bringing this application ... with, I am OK. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

vba - MS Access: Action "onchange" event after a delay?

Good morning! I have a "fancy" search function in Microsoft Access where the list of possible options shrinks ... by a narcoleptic gerbil. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

942 views

1 answer

vba - Copy a row in excel if it matches a specific criteria into a new worksheet

I'm a novice to VBA and having issues in copying rows in one sheet to another based on certain criteria. I ... ) End With wb2.Save wb2.Close See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

vba - Cancel sorting or disallow sorting on Access form

I have an Access form with a datasheet subform. This datasheet subform is displaying a dynamically created ... .subformControl.Form.LoadRS rs See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

vba - AutoFilter Criteria Using Array (Error) - Too Large String?

Update: Through some additional testing I discovered: 1) 255 Characters does seem to be the breaking point ( ... will be much appreciated! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.4k views

1 answer

vba - Get full path with Unicode file name

I have a path in short version or in DOS format ("C:/DOCUME~1" e.g) and want to get the full path ... StackOverflow but can't find out. Regards, See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

vba - BCC in ItemSend event in Outlook 2007 no longer works

I inserted code in ItemSend and saved the ThisOutlookSession module. It worked once and no longer works. It was ... objRecip = Nothing End Sub See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

vba - Remove currently looped item from collection?

How do I remove the currently looped item from a collection? I get run-time error 13: Type mismatch on the line ... vl End If Next vl End Sub See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

vba - VbaProject.OTM deployment

I came by this page and was thinking about the best method to distribute my VbaProject.OTM file (located into ... but still years from now. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

vba - Get MAPI Folder in Outlook from Folder Path

I am trying to use the function from on this page: http://www.outlookcode.com/d/code/getfolder.htm to use ... Set objApp = Nothing End Function See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.5k views

1 answer

vba - Case in-sensitive dictionary

I have set Dictionary as an object an added several items to that dictionary, however it seems to be case- ... PHIL etc. Thanks in advance! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

vba - Detect end of new message in email conversation body

When a message gets replied or forwared the previous thread gets appended on your new mail by placing i.e. ---- ... .. no nothing at all unique! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

vba - Paste vs PasteSpecial

After two hours of futile search and frustration. I am posting the question here. Can anyone please explain ... some resources which can help See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

871 views

1 answer

vba - How to understand autocorrelations caused by seeding a RNG too much?

In response to this question I ran the following VBA experiment: Sub Test() Dim i As Long, A As ... rather than a positive autocorrelation? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

931 views

1 answer

vba - MsgBox not big enough for text

I have a string (msg) that is pretty much a very long list of items. I need to put this in a msgbox ... an alternative to this? Thank you! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.4k views

1 answer

vba - XMLHTTP and Special Characters (eg, accents)

I am using Microsoft.XMLHTTP via VBA to pull in the body of a web page. In doing so, characters such ... object strResponse = .ReadText End With See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.3k views

1 answer

vba - Outlook Application.FileDialog not found

I'm writing a VBA macro for Outlook and the Application.FileDialog method is not available. The intent is ... engine Object Library Any ideas? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

vba - Curious behavior of Access.Application.Eval()

Explain why Access.Application.Eval() (commonly abbreviated as Eval()) produces a different result than just evaluating the ... .575) * 100) 58 See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

vba - Convert Excel Text to Time

I have to convert some formatted text to excel time, but I could not find a solution by myself. Here are ... approach this problem? Thanks, Paul See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags