KnowHow – Page 17 – Form Follows Energy

아이폰(iPhone)을 이용하여, 아이패드(iPad)에 있는 키노트(Keynote)를 원격조종할 수 있다.

기본적으로 와이파이(WiFi) 환경에서는 매우 잘 작동한다. 문제는 블루투스(Bluetooth) 환경이다.
특히 최근 iOS 7으로 운영체제를 업그레이드하면서 블루투스를 통한 원격조종이 원활하지 않았다.
그럼 어떻게 해결할 것인가?
해결책은 이렇다.

문제(Problem):
아이패드의 키노트를 블루투스 환경에서 아이폰으로 원격조종이 되지 않는다.
(Keynote Remote on iPhone doesn’t work with Keynote on iPad via Bluetooth.
Or Keynote Remote locks up (freezes) when using Personal Hotspot.)

해법(Solution):
1. 두 기기의 모든 와이파이와 블루투스를 모든 끈다.
(Turn off wifi and bluetooth of both devices)
2. 두 기기의 블루투스만 켜서, 연결을 한다.
(Turn on bluetooth of both devices and pair Keynote on the iPad with Keynote Remote on the iPhone)
그러면 아주 잘 된다.

사용환경:
아이폰 5(iPhone 5 with iOS 7.X)
레티나 아이패드 미니(Retina iPad mini with iOS 7.x)

VBA Function	역할
Abs	숫자의 절대값을 반환한다.
Array	배열을 담고 있는 variant를 반환한다.
Asc	문자열의 첫 글자의 ASCII 값을 반환한다.
Atn	숫자의 아크탄젠트(arctangent) 값을 반환한다.
CBool	부울(boolean) 형식으로 변환한다.
CByte	바이트(byte) 형식으로 변환한다.
CCur	(currency)형식으로 변환한다.
CDate	Converts an expression to date data type
CDbl	Converts an expression to double data type
CDec	Converts an expression to decimal data type
Choose	Selects and returns a value from a list of arguments
Chr	Converts an ANSI value to a string
CInt	Converts an expression to integer data type
CLng	Converts an expression to long data type
Cos	Returns the cosine of a number
CreateObject	Creates an OLE Automation object
CSng	Converts an expression to single data type
CStr	Converts an expression to string data type
CurDir	Returns the current path
CVar	Converts an expression to variant data type
CVDate	Converts an expression to date data type
CVErr	Returns a user-defined error number
Date	Returns the current system date
DateAdd	Returns a date with a specific date interval added to it
DateDiff	Returns a date with a specific date interval subtracted from it
DatePart	Returns an integer containing a specific part of a date
DateSerial	Converts a date to a serial number
DateValue	Converts a string to date
Day	Returns the day of the month of a date
Dir	Returns the name of a file or directory that matches a pattern
DoEvents	Yields execution so the operating system can process other events
EOF	Returns True if the end of a text file has been reached
Error	Returns the error message that corresponds to an error number
Exp	Returns the base of the natural logarithms (e) raised to a power
FileAttr	Returns the file mode for a text file
FileDateTime	Returns the date and time when a file was last modified
FileLen	Returns the number of bytes in a file
Fix	Returns the integer portion of a number
Format	Displays an expression in a particular format
Format Currency	Returns a number as a string, formatted as currency
FormatDateTime	Returns a number as a string, formatted as a date and/or time
Format Number	Returns a number as a formatted string
Format Percent	Returns a number as a string, formatted as a percentage
FreeFile	Returns the next file number available for use by the Open statement
GetAll	Returns a list of key settings and their values (originally created with SaveSetting) from an application’s entry in the Windows registry
GetAttr	Returns a code representing a file attribute
GetObject	Retrieves an OLE Automation object from a file
GetSetting	Returns a key setting value from an application’s entry in the Windows registry
Hex	Converts from decimal to hexadecimal
Hour	Returns the hour of a time
IIf	Returns one of two parts, depending on the evaluation of an expression
Input	Returns a specific number of characters from an open text file
InputBox	Displays a box to prompt a user for input
InStr	Returns the position of a string within another string
InStrRev	Returns the position of a string within another string, beginning at the back end of the string
Int	Returns the integer portion of a number
IsArray	Returns True if a variable is an array
IsDate	Returns True if a variable is a date
IsEmpty	Returns True if a variable has been initialized
IsError	Returns True if an expression is an error value
IsMissing	Returns True if an optional argument was not passed to a Procedure
IsNull	Returns True if an expression contains no valid data
IsNumeric	Returns True if an expression can be evaluated as a number
IsObject	Returns True if an expression references an OLE Automation object
Join	Returns a string created by joining a number of substrings contained in an array
LBound	Returns the lower bound of an array
LCase	Returns a string converted to lowercase
Left	Returns a specified number of characters from the left of a string
Len	Returns the length of a string, in characters
Loc	Returns the current read or write position of a text file
LOF	Returns the number of bytes in an open text file
Log	Returns the natural logarithm of a number
LTrim	Returns a copy of a string with no leading spaces
Mid	Returns a specified number of characters from a string
MidB	Returns a specified number of bytes from a string
Minute	Returns the minute of a time
Month	Returns the month of a date
MonthName	Returns a string indicating the specified month
MsgBox	Displays a modal message box
Now	Returns the current system date and time
Oct	Converts from decimal to octal
Replace	Returns a string in which one substring is replaced with another
RGB	Returns a number representing an RGB color value
Space	Returns a string with a specified number of spaces
Split	Returns an array consisting of a number of substrings
Sqr	Returns the square root of a number
Str	Returns a string representation of a number
Right	Returns a specified number of characters from the right of a string
Rnd	Returns a random number between 0 and 1
Round	Rounds a number to a specific number of decimal places
RTrim	Returns a copy of a string with no trailing spaces
Second	Returns the second of a time
Seek	Returns the current position in a text file
Sgn	Returns an integer that indicates the sign of a number
Shell	Runs an executable program
Sin	Returns the sin of a number
StrComp	Returns a value indicating the result of a string comparison
StrConv	Returns a string variant converted as specified
String	Returns a repeating character or string
StrReverse	Reverses the character order of a string
Switch	Evaluates a list of expressions and returns a value associated with the first expression in the list that is True
Tab	Positions output in an output stream
Tan	Returns the tangent of a number
Time	Returns the current system time
Timer	Returns the number of seconds since midnight
TimeSerial	Returns the time for a specified hour, minute, and second
TimeValue	Converts a string to a time serial number
Trim	Returns a string containing a copy of a specified string without leading spaces and trailing spaces
TypeName	Returns a string that describes the data type of a variable
UBound	Returns the upper bound of an array
UCase	Converts a string to uppercase
Val	Returns the numbers contained in a string
VarType	Returns a value indicating the subtype of a variable
Weekday	Returns a number representing a day of the week
Weekday Name	Returns a string indicating the specified weekday
Year	Returns the year of a date

Category: KnowHow

iOS 한컴오피스 웹폴더에 동시 저장하기

WordPress에 작성한 글을 Facebook에 공개하기

[MatLab] Rubik’s Cube Simulator and Solver

아이튠즈 백업 파일 관리

Bluetooth를 통하여 Keynote Remote 이용하는 법

[워드프레스] 파일 첨부하는 방법

web content management system

Sketchup 관련 자료 링크

[VBA] VBA Functions for Excel

맥미니를 클라우드 서버로