Recent questions tagged VBA

0 votes

997 views

1 answer

vba - How to connect to OPEN workbook in another instance of Excel

Currently I can run 2 Excel VBA processes simultaneously within 2 separate Excel instances on 1 PC. My goal ... 2 VBA processes simultaneously.) See Question&Answers more detail:os...

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

0 votes

938 views

1 answer

vba - How to extract and plot only minimal and maximal peaks of an array , -graph analysis- With Matlab or excel

I'm doing video analysis. The end result array I get is something like: signal = Columns 1 through 7 ... nicely drawn curve without noise. See Question&Answers more detail:os...

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

0 votes

895 views

1 answer

vba - How can I automatically run a macro when an email is sent in Outlook?

The script below works great but I have to manually run the Initialize_handler routine every time I open ... () Initialize_handler 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 - Is there a way to get ADODB to work with Excel for Mac 2011?

I can not seem to get my Excel workbook (using ADODB) to work with Excel Mac 2011. I am using ADODB code. ... ? Has anyone gotten this to work? See Question&Answers more detail:os...

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

0 votes

943 views

1 answer

vba - How to open specific version of Word 2007/2010 in Excel

I have both Word 2007 and 2010 installed. I need to open Word from within Excel but I need to specify ... Set wordApp2010 = Nothing End Sub See Question&Answers more detail:os...

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

0 votes

993 views

1 answer

vba - How to convert Excel to Adobe PDF

I am trying to find a code that works to convert my excel into PDF (Adobe). So far my research to find the ... this. Thank you very very much. See Question&Answers more detail:os...

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

0 votes

944 views

1 answer

vba - Look Values in column 1 and bring column 2 values

my data set looks like Col A A/05702; A/05724; A/05724;A/05724;A/05725;A/05725; corresponding Col B 1;1; ... by "," Any help is appreciated. See Question&Answers more detail:os...

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

0 votes

927 views

1 answer

vba - How to keep formats when I copy a range from Excel to outlook

Hello i have an Excel table with some formats 10(Red) -> 15(Green), but at the end I loose all the ... Nothing Set TempWB = Nothing End Function See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

vba - MS Access Multi-control KeyPress CTRL+A Handler

I have an Access database with 10+ text controls. I'd like to have some code to handle the CTRL + A KeyPress ... m still a noob with VBA/Access. See Question&Answers more detail:os...

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

0 votes

934 views

1 answer

vba - How can you convert HEX to BIN, one character at a time in EXCEL 2010

I am trying to find a way to take a string of HEX values and convert them to BIN. I need to convert 1 ... help would be great. Thanks, Larry See Question&Answers more detail:os...

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

0 votes

843 views

1 answer

vba - MS Access 2007 - Cycling through values in a list box to grab id's for a SQL statement

Lets say I have two tables, one for transactions, and another table who's primary key is the foreign key in ... that escapes me. Thanks Justin See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

vba - Delete Blank Rows after AutoFilter

I have the following code in my Excel sheet: Sub DeleteRows 'Filter CMReport to delete (Blank) rows. With ... What am I doing wrong. See Question&Answers more detail:os...

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

0 votes

852 views

1 answer

vba - Automating the HTML document in an IE web dialog window?

Posting this question do I can provide a full example for anyone like me who needed to figure this out... ... if you need something similar. See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

vba - Pasting Excel Chart into PowerPoint Slide

The below Sub is supposed to paste an Excel chart into a newly created PowerPoint slide. It then exports the chart ... setting the focus or so. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

vba - GetElementsbyClassname: Open IE vs. MSXML2 Methods

The following macro works just fine. It opens an instance of IE and uses the "getelementsbyclassname" method to ... Screenshot for D. Zemens See Question&Answers more detail:os...

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

0 votes

926 views

1 answer

vba - How to retrieve data from Excel with ADODB connection if the first line of the worksheet does not have the column name?

I use the following type of code to retrieve data from some Excel Workbooks (path is a Parameter) Dim strSQL As ... first row of my data table? See Question&Answers more detail:os...

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

0 votes

900 views

1 answer

vba - Get position (in number) of selected item in dropdown list

In a dropdown list I have a few items. Can I, when I select an item, get the position of that item in the list as a number? See Question&Answers more detail:os...

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

0 votes

927 views

1 answer

vba - Why doesn't VBE.ActiveCodePane.CodeModule work when the VBE (code window) isn't open?

Create a form that runs the following code. MsgBox (VBE.ActiveCodePane.CodeModule) And this message appears. Now save, ... What's going on here? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

vba - Is there an Open File dialog for Access 2010 64bit?

How do I get an Open File dialog for Access 2010 64bit? Normally I would use the common dialog control but ... used with Access 2010 64 bit. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

vba - Wildcard search of dictionary

After searching google and SO, I see that there is a way for me to search a dictionary for an ... wildcard searching the dictionary keys? See Question&Answers more detail:os...

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

0 votes

983 views

1 answer

vba - How to call a macro on send button click?

I have a macro that takes the description of an email that I've selected and populates the "message" field ... BLA.. ComboboxValue: Item1 Thx See Question&Answers more detail:os...

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

0 votes

904 views

1 answer

vba - Vlookup Excel, Referencing A different Sheet

I am trying to create a simple VLOOKUP function for my spreadsheet using the below: In the first sheet =VLOOKUP( ... what is causing the error? See Question&Answers more detail:os...

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

0 votes

991 views

1 answer

vba - Excel Macro - Comma Separated Cells to Rows

I have have the following data in excel: a, b, c d e f, g h i with each row, representing a row ... .ScreenUpdating = True End With End Sub See Question&Answers more detail:os...

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

0 votes

794 views

1 answer

vba - Run through a loop for more than 100,000 rows of data in two sheets in the same workbook

I currently have code to allow me to look through the rows with matching ID from Sheet 1 and Sheet 2. When both ... code that I have for now. See Question&Answers more detail:os...

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

0 votes

853 views

1 answer

vba - Attempt to connect to a valid database from outside Access (Outlook/Excel) using DAO generates a 3343 unrecognized database format error

Thanks for your site. Wonderful information. In a nutshell, I'm trying to execute the following code from ... be greatly appreciated. Thanks! See Question&Answers more detail:os...

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

0 votes

1.8k views

1 answer

vba - Get Last Row From Filtered Range

How do you find the last row of data when the data in your worksheet is filtered? I have been playing around ... to Sid's solution below... See Question&Answers more detail:os...

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

0 votes

767 views

1 answer

vba - How to detect changes in cell format?

I want to embed a procedure in an Excel sheet that will detect when a cell's format changes, e.g. from ... whether the content type has changed? See Question&Answers more detail:os...

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

0 votes

933 views

1 answer

vba - "Undo" history button clear after run macro excel

I have a macro that fires on the "Worksheet_SelectionChange" event. The macro validate data of one column, it ... solve this problem? Thanks. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags