This is a method to retrieve the folder containing VBS files using VBS. This allows you to perform operations using the absolute path to the folder containing VBS files.
Continue reading VBS: How to get the folder which contains the .vbs file itselfCategory Archives: Code
Case Statement in Access SQL
For Loop of Controls in Excel VBA
(日本語) Visual Basic: Integer に 3桁の区切り(カンマ)を入れたい場合
Crystal Reports: Displaying Explanatory Text on the First Page
In purchase orders and other documents, it’s sometimes necessary to display explanatory text on the first page. However, this can be problematic when placed in the report header, as it will appear in an awkward position. On the other hand, if placed in the page header, it will be displayed on every page. In such cases, you can follow these steps to set up an item that will only appear on the first page, which is recommended for brief explanations.
Insert the desired text into the page header.
Select the inserted text, go to the CrystalReport menu, and choose Formula Workshop.
In the tree view on the left, select Page Header and then select the text object where you’ve written the explanatory text.
Next, choose New, and select “Hide” as the option.
Enter the following code:
1234If pagenumber = 1 thenfalseElseTrue
Now, this item will only appear on the first page.