Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 18th 20, 09:49 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2015
Posts: 192
Default Using registry for data storage and transfer?

I posted this a week ago in 'Copy multi-line variable to first empty
row' but suspect it may have been overlooked in that very long thread.
I'm still interested in opinions on using the registry for data transfer
please, so here's a paste:

--------------------

My macro is now working sweetly, thanks to Claus, using an intermediate
text file to transfer the variables from the external source, my macro
written with Macro Express Pro.

I've just come across the SaveSetting and GetSetting VBA functions to
save and recover data from the registry. MX Pro also has similar
commands. So would this be a viable and possibly superior alternative
method?

Terry, East Grinstead, UK

  #2   Report Post  
Old February 18th 20, 12:40 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2019
Posts: 86
Default Using registry for data storage and transfer?

"Terry Pinnell" wrote in message
I've just come across the SaveSetting and GetSetting VBA functions to
save and recover data from the registry. MX Pro also has similar
commands. So would this be a viable and possibly superior alternative
method?


Form most purposes in VBA SaveSetting, GetSetting and DeleteSetting are a
very viable alternative to using the various registry APIs.

They might be considered superior in the sense of very simple and no risk
using the APIs incorrectly. Less superior in the sense you are restricted to
this path in the registry:
HKEY_CURRENT_USER\Software\VB and VBA Program Settings\

Peter T



  #3   Report Post  
Old February 18th 20, 01:37 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2015
Posts: 192
Default Using registry for data storage and transfer?

"Peter T" wrote:

"Terry Pinnell" wrote in message
I've just come across the SaveSetting and GetSetting VBA functions to
save and recover data from the registry. MX Pro also has similar
commands. So would this be a viable and possibly superior alternative
method?


Form most purposes in VBA SaveSetting, GetSetting and DeleteSetting are a
very viable alternative to using the various registry APIs.

They might be considered superior in the sense of very simple and no risk
using the APIs incorrectly. Less superior in the sense you are restricted to
this path in the registry:
HKEY_CURRENT_USER\Software\VB and VBA Program Settings\

Peter T


Thanks Peter, understood. That restriction doesn't worry me. I already
use one other 'fenced' key for working with Macro Express Pro. Once it's
in the Regedit Favourites it's easy to find, and means I'm unlikely to
cause widespread damage!

I'll aim to try a small project.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
XML Data Storage Rookie_User Excel Discussion (Misc queries) 0 June 30th 08 07:11 PM
storage data base southbound Excel Discussion (Misc queries) 1 May 20th 07 03:02 AM
Data Storage gregory.barrett Excel Discussion (Misc queries) 3 March 30th 06 10:23 PM
newbie needs help with data storage mrclox Excel Discussion (Misc queries) 0 November 22nd 05 09:52 PM
data storage from one worksheet to another coal_miner Excel Worksheet Functions 3 May 3rd 05 04:42 PM


All times are GMT +1. The time now is 10:11 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017