Recent questions tagged VBA

0 votes

756 views

1 answer

vba - Looping through a Scripting.Dictionary using index/item number

Similar to this issue, when using a Scripting.Dictionary object in VBA, the outcome of the code below is ... through the items by number. See Question&Answers more detail:os...

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

0 votes

530 views

1 answer

vba - How does Excel's worksheet password protection work

This code has been floating around the net for quite a few years - it's apparently able to provide a ... not understanding due to syntax? See Question&Answers more detail:os...

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

0 votes

887 views

1 answer

vba - Set formula to a range of cells

this is simple demo of what i want to do. I want to set a formula to a range of cells(eg. C1 to C10). Range(" ... ("C1:C10").Formula = "=Ax+Bx" See Question&Answers more detail:os...

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

0 votes

648 views

1 answer

vba - Export tables to an excel spreadsheet in same directory

I have two tables in my access database that I want to be able to export to excel. I can do it by ... historical exports as well. Any advice? See Question&Answers more detail:os...

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

0 votes

646 views

1 answer

vba - Lock down Microsoft Excel macro

I've spent some time writing an Excel Macro that is potentially worth money to a lot of companies. How ... forwarding to other people? Thanks See Question&Answers more detail:os...

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

0 votes

630 views

1 answer

vba - Changing linked table location programmatically

I have an Access database with a linked table in a second database, located in the same directory as ... adjusts the linkage accordingly. See Question&Answers more detail:os...

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

0 votes

686 views

1 answer

vba - How do I loop an excel 2010 table by using his name & column reference?

Since Excel 2010 I'm using a lot of tables within Excel. For example, I have a table "tabWorkers" with 3 ... (like with [tabWorkers].Rows) See Question&Answers more detail:os...

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

0 votes

765 views

1 answer

vba - How to get the procedure or function name at runtime?

Is there any way to return the name of a function or procedure at runtime? I'm currently error handling ... kernel memory via API calls. See Question&Answers more detail:os...

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

0 votes

772 views

1 answer

vba - How to change Named Range Scope

When I create a named range through the Name Manager, I'm given the option of specifying Workbook or [worksheet ... :B2 with 'sheet1' scope? See Question&Answers more detail:os...

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

0 votes

635 views

1 answer

vba - Run-time error '91' (Object variable or With block variable not set)

I am relatively new to VBA and am trying to put together a msgbox that will give me a specific number from a web ... (CRD# 5944070)</span></div> See Question&Answers more detail:os...

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

0 votes

719 views

1 answer

vba - Search structured text in Outlook body

I need to find a line in a selected mail and copy it. The line contains Mailbox: ???????????? ... .CurrentItem Case Else End Select End Function See Question&Answers more detail:os...

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

0 votes

757 views

1 answer

vba - Select Newest Record and Create New Table of Unique Values in Excel

I have an Excel table that records vehicle progress through work stations within a business. A given work station may ... I seek, in Excel? See Question&Answers more detail:os...

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

0 votes

897 views

1 answer

vba - Handling Events for OLEObject CommandButtons created at Runtime

I have struggled with this problem for while now...I want to do something very simple. I want to create ... .Add Item:=OLEBtnObj End Sub See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

vba - UrlDownloadToFile in Access 2010 - Sub or Function not Defined

I am trying to use the function URLDownloadToFile in Access 2010 VBA code. When i run the code it tells me that ... a url to to a file? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

vba - Finding a workbook in one of multiple Excel instances

I have a macro in Outlook VBA to grab data from an open Excel workbook ("Workbook1"). I reference the ... running more than one Excel instance? See Question&Answers more detail:os...

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

0 votes

943 views

1 answer

vba - Excel (Office 365) restarts automatically while executing UDF

Thanks in advance for your help. I am not sure where the problem in my UDF but the excel restarts ... & Office 365 is my environment See Question&Answers more detail:os...

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

0 votes

818 views

1 answer

vba - Slice array to use index on larger than 65000

I use the code hereunder to calculate max values as described in this post (vba max value of group of ... Function End If Next End Function See Question&Answers more detail:os...

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

0 votes

788 views

1 answer

vba - Speed up multiple replacement

I'm writing a Word macro that reads about 1000 word pairs from an Excel file and does replacement accordingly ... to speedup the replacement? See Question&Answers more detail:os...

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

0 votes

769 views

1 answer

vba - Declare PtrSafe Compatibility in Excel

I am using this statement in VBA Private Declare PtrSafe Function GetTimeZoneInformationAny Lib "kernel32" Alias _ " ... happens. any ideas? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

vba - MSHTML: CreateDocumentFromString instead of CreateDocumentFromUrl

I'd like to use the MSHTML library to parse some HTML that I have in a string variable. However, I can't ... using the oDoc variable' .... See Question&Answers more detail:os...

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

0 votes

927 views

1 answer

vba - Return the selected text from a dropdown box

I am trying to return the text from a dropdown box that is selected on an Excel form. I have tried many ... .Shapes("DropDown1").Value etc. See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

vba - Xmlhttp request is raising an Access Denied error

The following Excel macro, which is making an xmlhttp request to this webpage to retrieve some values at a second ... and 1 at every call? See Question&Answers more detail:os...

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

0 votes

983 views

1 answer

vba - Can I Get the Source Range Of Excel Clipboard Data?

If the Clipboard contains an Excel Worksheet Range, you can access that Range's Data with the DataObject ... Preferably using Excel 2003 VBA See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

vba - VB6/VBScript change file encoding to ansi

I am looking for a way to convert a textfile with UTF8 encoding to ANSI encoding. How can i go around and ... Basic (VB6) and or vbscript? See Question&Answers more detail:os...

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

0 votes

960 views

1 answer

vba - How can I create text files with special characters in their filenames

Demonstration of my problem Open a new Excel workbook and save these symbols 設計師協會 to cell [A1] insert the ... the VB script run-time library See Question&Answers more detail:os...

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

0 votes

831 views

1 answer

vba - Excel Useform: How to hide application but have icon in the taskbar

What I want to have is Application.Visible = False, so that my users cannot see the excel/worksheets, only ... .Visible = True End Sub See Question&Answers more detail:os...

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

0 votes

934 views

1 answer

vba - How to loop through all controls in a form, including controls in a subform - Access 2007

As the title of my question suggest, how is it possible to loop through all the controls in a form, including ... help or pointers. Cheers Noel See Question&Answers more detail:os...

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

0 votes

976 views

1 answer

vba - Reverse order of For Each loop

One of the most powerful things about VB is ability to loop through objects in a collection WITHOUT referring to ... the for each loop syntax? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags