Ask Question Forum:
Model Library:2025-02-08:A.I. model is online auto reply
C
O
M
P
U
T
E
R
2
8
Show
#
ASK
RECENT
←
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Below area will not be traslated by Google,you can input code or other languages
Hint:If find spelling error, You need to correct it,1 by 1 or ignore it (code area won't be checked).
X-position of the mouse cursor
Y-position of the mouse cursor
Y-position of the mouse cursor
Testcursor
caretPos
Attachment:===
Asked by HDM
at 2024-08-07 14:52:33
ModifyPoint:500 Replies:3 POST_ID:828710USER_ID:11606
Topic:
Microsoft Excel Spreadsheet Software;;
If I have three tabs called
1- Arrow
2- Bench
3- Circle
In each of these tabs I use connections called
1- IE.MV.COM IE Arrow
2- IE.MV.COM IE Bench
3- IE.MV.COM IE Circle
In each connection the connection string has an IP address 21x.5x.x3.1xx
I need to change all three connection IP address from 21x.5x.x3.1xx to IE.MV.COM
Is there a way to change all three connection files with out having to modify each file separately??
1- Arrow
2- Bench
3- Circle
In each of these tabs I use connections called
1- IE.MV.COM IE Arrow
2- IE.MV.COM IE Bench
3- IE.MV.COM IE Circle
In each connection the connection string has an IP address 21x.5x.x3.1xx
I need to change all three connection IP address from 21x.5x.x3.1xx to IE.MV.COM
Is there a way to change all three connection files with out having to modify each file separately??
Author: HDM replied at 2024-08-09 07:40:06
Thanks all!!
Great stuff!! :-)
Great stuff!! :-)
Accepted Solution
Expert: Lawrence Barnes replied at 2024-08-08 17:38:14
250 points EXCELLENT
In the find/replace [Ctrl + h] window you can click on [Options] and then change the [Within] selection to [Workbook]. Then the find/replace will happen on all spreadsheet tabs.
Assisted Solution
Expert: duncanb7 replied at 2024-08-07 22:35:59
250 points EXCELLENT
It might work if each separate file has Cell to store the IP location which is
stored in one workbook of three workbooks and a separate new workbook
For example you put cells as
="[otherworkcallIP.xls]sheet1!a1"
Every times, all three workbooks will call the same location of the IP
Duncan
stored in one workbook of three workbooks and a separate new workbook
For example you put cells as
="[otherworkcallIP.xls]sheet1!a1"
Every times, all three workbooks will call the same location of the IP
Duncan
