Search found 10 matches

by americanaustralian
Tue Jun 09, 2020 1:32 am
Forum: BasicMaker 2018 for Windows
Topic: SendKeys behavior is erratic...
Replies: 2
Views: 3466

Re: SendKeys behavior is erratic...

Didn't occur to me to exit the cell first. Thank you for the solution...
by americanaustralian
Tue Jun 09, 2020 12:19 am
Forum: BasicMaker 2021 for Windows
Topic: Feature request - Paste Special(s) script command
Replies: 7
Views: 6133

Re: Feature request - Paste Special(s) script command

Yes, it is strange. I don't get any errors at any time. If I run the code from PlanMaker with the Run Script ribbon command, the spreadsheet blinks momentarily as if something happened, but nothing gets updated. I tried the Run Script command both from the ribbon and the quick launch toolbar. If I o...
by americanaustralian
Mon Jun 08, 2020 7:01 pm
Forum: BasicMaker 2021 for Windows
Topic: Feature request - Paste Special(s) script command
Replies: 7
Views: 6133

Re: Feature request - Paste Special(s) script command

Checked the results of running this code (modified with my cell addresses, of course), and it doesn't work. Specifically, the %v command does nothing when the script runs, but using the command manually works as expected.
by americanaustralian
Fri Jun 05, 2020 8:58 pm
Forum: BasicMaker 2021 for Windows
Topic: Feature request - Paste Special(s) script command
Replies: 7
Views: 6133

Re: Feature request - Paste Special(s) script command

Thanks for the help, SuperTech. So, I tried exactly what you suggested. Here's the result: If I step through the code (with the F8 key), execution stops on the "pm.Range("G2:G52").PasteSpecial" line, and gives "Error in line: 36 - Object doesn't support this property or meth...
by americanaustralian
Fri Jun 05, 2020 3:04 am
Forum: BasicMaker 2021 for Windows
Topic: Feature request - Paste Special(s) script command
Replies: 7
Views: 6133

Feature request - Paste Special(s) script command

Hmm...apparently there is no way to do a scripted Paste Special. I'm replicating a trailing stop tracking system for my stock portfolio (I have it set up and operating in MS Excel with VBA), and it absolutely requires the functionality of copying a column of cells and then pasting ONLY the values. I...
by americanaustralian
Thu Jun 04, 2020 2:59 am
Forum: BasicMaker 2021 for Windows
Topic: Feature request - Page Setup Scaling Options
Replies: 1
Views: 3560

Feature request - Page Setup Scaling Options

There is one scripting choice for this at present, the fixed scaling option percentage. I suggest adding scripting capability for the 4 Specify modes as well.

Page Setup -> Options -> Scaling Options -> Scaling Mode
by americanaustralian
Thu Jun 04, 2020 2:49 am
Forum: BasicMaker 2021 for Windows
Topic: Freeze Cells...
Replies: 1
Views: 3587

Freeze Cells...

I'm assuming that there is no script command for Freeze Cells (on the ribbon - View->Freeze Cells). If I'm just missing something, let me know...otherwise, this is a feature request to add this as a property.
by americanaustralian
Mon Jun 01, 2020 10:09 pm
Forum: BasicMaker 2018 for Windows
Topic: SendKeys behavior is erratic...
Replies: 2
Views: 3466

SendKeys behavior is erratic...

When I use SendKeys, and I run the script using F8 to step through it, the SendKeys commands don't work. If I run the script using F9, the first instance works, the second doesn't do what's expected, and the third causes a system alert beep, otherwise does nothing at all. Here's the script: Sub Main...
by americanaustralian
Sun May 31, 2020 11:17 pm
Forum: BasicMaker 2018 for Windows
Topic: Can't find scripting commands for Paste Special and Fill Down...
Replies: 3
Views: 3719

Re: Can't find scripting commands for Paste Special and Fill Down...

Thanks for the reply, Miguel. Doing as you suggested works manually, but I can't find a search/replace script command. I'm looking in the BasicMaker 2018 manual...maybe that's the wrong place. Any suggestion where I'd find it?
by americanaustralian
Sun May 31, 2020 3:40 am
Forum: BasicMaker 2018 for Windows
Topic: Can't find scripting commands for Paste Special and Fill Down...
Replies: 3
Views: 3719

Can't find scripting commands for Paste Special and Fill Down...

I have a PlanMaker document that I'm converting from a .csv file, and some of the dollar amounts are in a string format...which PlanMaker can't read as values. Using the Value and Currency functions only results in a #VALUE! error. I've figured out a script to convert those amounts into usable value...

Go to advanced search