Recent questions tagged VBA

0 votes

1.1k views

1 answer

vba - There is no Wait Method associated with Application in VisualBasic Word

I have VBA code to run a particular code and I am trying to pause the next execution by giving it a wait ... : Method or data variable not found See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

vba - Create brand new XML node to append as child to other node

I would like to create a new XML node to append to an existing one in my XML file. Specifically, the ... ? trade.appendChild(newNode) Next trade See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

vba - MS Outlook 2010 .SenderEmailAddress returns a huge string of characters

I've searched and searched for an answer so I'll post this here. I'm trying to create a macro that will ... would be greatly appreciated! :-) 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 rename attachments and save to folder

I have a script that I found that currently saves attachments but I also need it to rename those attachments to ... is generated by the ERP. See Question&Answers more detail:os...

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

0 votes

878 views

1 answer

vba - Is there a way to write to/edit a otherwise read-only Recordset for the context of the form and work with the data?

In my database there is a form that displays records filtered by an abbreviation you can choose from in a ... thread for clearer structue. See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

vba - Copy Excel theme color in a new workbook

I want to make a macro that copies two sheets in a new workbook. But the theme color in the new ... = ThisWorkbook Need help... Greetings See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

vba - Deleting rows with values based on a column

I have a monthly base with almost 373,000 lines. Of these, part has a low value or is blank. I'd like to ... Then Rows(i).Delete Next i End Sub See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

vba - Make it faster?

I am currently with a bit of a dilemma. After months working on a Macro/vba project the thing's gotten massive ( ... work if they feel like it) See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

vba - Check whether Excel file is Password protected

I am trying to open an Excel (xlsm) file via VBA. It may or may not be protected with a (known) password. ... not want. How to get around this? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

vba - How to embed image placed inside the excel into the .htmlbody of vbascript

This is my code of the .htmlbody .htmlBody="<html><center><img src='https://website.com/images/logo- ... and concatenate it inside the .htmlbody See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

vba - How do you disable "Save and send" in Excel 2010 (in the File ribbon (called backstage in Office 2010)?

I have the following VBA marco running in Excel 2003, it blocks the Save, Save as, Save Workspace, Send To ... False Thank you for your help. See Question&Answers more detail:os...

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

0 votes

984 views

1 answer

vba - PowerPoint Add-In Loss of RibbonUI

I have been struggling to identify the cause of an error in a PPT Add-in that is distributed across about 40 end ... . So, what am I missing? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

vba - Searching for Text in Header Section of A Word Document

I am trying to confirm if a document contains some text, the only problem is this text is in the Header. ... help would be greatly appreciated. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

vba - Insert INTO NOT EXISTS SQL access

I am trying to insert records from another table into a table in Access using sql. I have pasted ... SELECT * FROM ShouldImportMetricsIDsTable); See Question&Answers more detail:os...

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

0 votes

935 views

1 answer

vba - Cannot seem to move worksheet's content reliably

This is already part 4 of what has now become my 1st StackOverflow trilogy :) Hopefully bringing it all together ... users than average... :P See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

vba - Trouble making my parser scroll downward

I've written a script in vba to parse some information from a webpage. The thing is before scraping any information from ... 1);"></div></div> See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

vba - Loading an image makes listbox & textboxes blink once

In Access 2016 I have a form with a listbox, and an Image Control named imgFrame. When a filename is clicked ... same way but saw no difference. See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

vba - Workbooks.OpenText not parsing csv files properly Excel 2016

I'm pretty sure this worked properly in previous versions of Excel Test File: d/mm/yyyy hh:mm:ss 5/12/1999 ... ) Set WB = ActiveWorkbook End Sub See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

vba - Saving embedded OLE Object (Excel workbook) to file in Excel 2010

I am trying to save an embedded OLE Object (Excel workbook) from my current/open workbook to a location on the ... Workbooks.Open(fName) End If See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

vba excel - find string wildcard

I am doing a simple search engine in excel and I want to make some wildcards, for example: I have a cell where ... :=False) any ideas? thank you See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

vba - Download Files (PDF) from Web

I am fresh-starter at VBA. How do I download PDF file using UrlDownloadToFile from http://cetatenie.just.ro/wp- ... End If Next i End Sub See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

vba - Get email from non default inbox?

I am using the following vba code to get emails from my inbox folder and move them to a sub folder called ... = myItems.FindNext Wend End Sub See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

vba - Add print area content (appending) at the end of initial existed pdf file in a new page section

For generating a report, I have create pdf with bellow approach. ActiveSheet.ExportAsFixedFormat _ Type:=xlTypePDF, ... in VBA references. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

vba - Save as an Excel file embedded in another Excel file

I want to manage with VBA an Excel file embedded in another Excel file. I can find many results with .docx ... could you help me a bit? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

vba - When using range.find to find bold text it won't find if the entire selection is bold!

I'm trying to extract bold text using the range.find method and all is peachy except if the entire range ... . What does stackoverflow think? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

vba - Changing Textbox.DefaultValue in Access

I would like to be able to change the Textbox.DefaultValue during the 'On Load' event of a form such that ... Sub I am using Microsoft Access See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

vba - Module variables don't survive CodeModule.InsertLines call

I am trying to add a button to my worksheet during run-time. This button should just display different worksheet ... doing it the wrong way? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

vba - excel: check for duplicate rows based on 3 columns and keep one row

This might be a bit much to ask but I'm wondering if the following is possible. this is all based on my ... then it is considered a duplicate. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags