vba tag

72 questions


3 answers
87 views
0
Cannot change font size on VBE

Unable to change font size for VBE.BE.You can change the font itself or any other changes.I tried changing FontHeight in the registry, but it doesn't reflect on VBE.The environment is Windows 10 (1703...

2 years ago

1 answers
91 views
0
a method of determining whether the value of a variable has increased or decreased

I'd like to implement it on Swift, but any language is fine as long as logic is applied. The value (numeric) of a variable changes dynamically, but I'd like to branch the process by whether the value ...

2 years ago

1 answers
75 views
0
VBA and IE Operations [Closed]

Do you want to improve this question?Edit your post to clarify the issue you are trying to resolve by adding details.Closed 2 years ago.Two years ago<a href=onclick=return csvDownload(); onmouseo...

vba
2 years ago

1 answers
108 views
0
I'm looking for a way to save it as a separate file for each page in Excel.

How do I save a separate file for each sheet in Excel? https://incloop.com/excel%E3%81%A7%E3%82%B7%E3%83%BC%E3%83%88%E6%AF%8E%E3%81%AB%E5%88%A5%E3%83%95%E3%82%A1%E3%82% A4% E3% 83% AB% E3% 81% AB% E3%...

2 years ago

2 answers
115 views
0
I want to unify the size of the PDF created in Excel VBA (in VBA).

I implemented the PDF version of the Excel sheet in the VBA, but some pages are not consistent in size.The reason seems to be the same as the link below.When you create a PDF from Excel, the page size...

2 years ago

1 answers
106 views
0
I want to delete MS Word rubi in VBA

Good job, everyone.Use this code to add furigana.https://stackoverflow.com/questions/34602598/how-to-add-phonetic-guides-to-all-the-texts-at-onceHow do I delete rubies on a VBA?Thank you for your coop...

2 years ago

2 answers
81 views
0
I create Outlook mail in Excel VBA, but the mail screen may not be active after execution, so please tell me how to activate it (frontline).

When I create Outlook mail in Excel VBA, the mail screen may not be active after execution. How do I activate it?The code looks like the following DimobjOutlookAsOutlook.Application DimobjMailAsOutloo...

2 years ago

1 answers
119 views
0
Export PDF bookmarks and annotations

Is there a way to list PDF bookmarks (Bookmark) and annotations (Annotations)?If possible, I would like to export it to the system check.For example, VBA, command line, or Script.You can use a third-p...

2 years ago

1 answers
88 views
0
I would like to convert the attribute of the HTML link tag (a tag) in the VBA regular expression to add rel="noopener noreferrer" as a separate tag.

ExcelVBA is creating software that automatically prints HTML. so that all link tags can be opened with a separate tag (a separate window)I would like to convert it.And automatically for security measu...


1 answers
77 views
0
Excel Macro: Error 9, If x Countif

How do I resolve the error code '9'?Below is the If(WorksheetFunction.CountIf part.Sub Downloaded() n=Cells(Rows.Count, F).End(xlUp).Row Dimi Fori=2 Ton If Range(o & i) = 0 Then Range(a&i).V...

2 years ago
« - 3 - »

© 2024 OneMinuteCode. All rights reserved.